What are the major advantages of the 2005 driver over the 2000 driver?
We are running a active/passive db, with about 800 - 1000 database
connections.
We seem to be running low on available cursors.  We get the server out

When I try to connect to an external SQL Server via enterprise manager I
cannot seem to connect to a named instance. In the past this has worked with
no problem when I do ip\instance. However when I now try I am getting invalid
instance name. The name I am using is correct. I am ...

I've been fighting to get sql server express on my machine to be
accessible remotely.  I've tried many times and quadruple checked all
of the instructions in KB article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Am new to Sql Server Express but using it doesn't seem "easy" .   When
executing a very simple sample program in Visual Studio 2005,  this message
occurs:
Failed to generate a user instance of SQL Server due to a failure in

I didn't find it in MDAC 2.8 SDK.

I have a problem when connecting to a named sql 2000 instance . The instance
is running in a 2 node cluster configuration. The second instance on the
other node works fine.
When I try to connect with a client on another pc, the connection only works

My SQL 2000 enterprise run on win2000Advance server, and 8GB memory, 4 CPU.
one problem, i discover i connect sql server is timeout suddenly. So i check
the CPU ultilization is 4%, and the memory so low view from task manager.
could you tell me what problem happen and how to ...

I developed a programm with dot.net 2.0.
On my environment ervy thing works fine.
When I try to use it on the customers envrionment I get the following error
message:

      My application in another server can't find the SQLServer database
after a restore. The name of the DB is exactly the same! The application says
the the Target Database does not match destination database. My question is:
Is it possible that the reason comes from the ...

some of my colleagues need to connect to my database to retrieve some reports
but they can't connect to my computer. i didn't set any specific passwords as
i'm using my window account ( username - Administrator , password - ** )
during the nistallation but the system always show ...

I am trying to make a unique logon to a SQL server in an Access apd file so
when the file is executed it logs into a specific database.  I set up the new
user name and password in the SQL server and associate it with the database
giving it read, write and admin privileges.  In ...

I installed ASP and MSSQL(SQL Express Edition, SQL Manager 2005 for SQL
Server Lite).
- ASP is runnig correctly
- With SQL Manager 2005 for SQL I can create Databases and tabels and some

Good evening,
I am trying to get the new 2005 JDBC driver to use integrated
authentication.  I have tried adding the
parameter -Djava.library.path=C:\Microsoft SQL Server 2005 JDBC

I have built a SQL2005 64-bit developer edition with SP1 on windows 2003
Enterprise 64bit.
I try to use a 32-bit XP client to connect to SQL2005 server but fail. It
seems the SQL server does not exists. I have tried to use the Query Analyser

I have a problem using the MS SQL Server 2000 SP3 drivers to binary
data from an image field.
The data I store in this field, can be binary or standard ASCII stored
as lines of data terminated by CR LFcharacters.