I'm setting up a development environment on XP Pro.  I'm working with classic
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)

how about for SQL 2000 Enterprise?
what are the concurrent connections?
the reason I am asking is because I had an issue where we
were getting asp errors/access denied during heavy traffic

While trying to connect SQL server from one network to another I'm suddenly
getting this error message:
A connection could not be established to ServerName.
Reason: Login failed for user '(null)'.  Reason: Not associated with a

Is there a method to enable an ODBC client to encrypt all communications
between the client and the server?
I have a client that is having a cow about data moving over the network via
an ODBC driver to DBMS server unencrypted.

I have the situation where I need to attach and detach from an installed
MSDE database and I was hoping I'd be able to do it using the SQLConnect
and SQLDisconnect functions from the ODBC API.
However, if I run a test case where I connect to the datasource and then

If I create a link server on my SQL Server to another SQL Server and run a
stored procedure using:
EXEC otherserver.database.dbo.sp_myproc
Does the procedure actually "run" on the remote server or on my SQL Server?

We periodically receive an error message:  Database 'db
name' can not be found or is busy....
We seem to get it more often with users who attempt to
connect to our DB using a wireless network card in their

I'm calling SQLBindParameter on a prepared statement with the following
arguments for a Varchar column in a SQL Server 2000 database:
// code ...
char val_ptr[] = "whereValue";

How many concurrent sessions can SQL 2000 take?
thanks

There is a possibility that we may need to move our existing W2K servers and
our custom application over to *nix.
I am interested to know what are the options available to us if we stick
with SQL Server 2000 Enterprise as the database on a W2K or W2003 OS.

What is Microsoft's plan for adding SSL support into their JDBC driver?  
From what limited information I could find on the web, it appears
Microsoft has no plans to ever support it!  If they are not going to
support it is there any way I can get the protocol definition so I can

I run Freedom software on my clients machines. When the
computer name changes
we have to completely reinstall the Freedon software or it
will not connect

I am using Visual Foxpro as front end and SQL Server at
backend. This is a Client/Server Database App. I am facing
deadlock problems in this environment. Please provice me
any help in this regard.

I am setting for the first time SQL to access a database. I can get the
Enterprise Manager and the Network Utility to see the databases (on 2
computers) but when I go to the program to access the databases, I get a
Connection error.

Data Link Properties, open by test.udl file, when open don't show any
istance of MSDE sp3 installed.
By Visual Studio.NET 2003 Server Manager I can see the server and database.
If I insert manually name istance and try test connect it return me this