Scenario -
On a standalone installation i.e client and SQL server are on same
machine, if network connection is lost while preparing SQL server
connection through client application, then SQL connection could not be

We have a system which uses an Access front end linked to a SQL 2000 database
If we were to move the SQL database onto a new server then would it just be
a case of editing the ODBC settings on each client to point to the new SQL
server?

I've got a SQL2000 server that I need to connect to from a small number of
development boxes.  If the dev box is running Windows 2000 SP5, I have no
problem establishing an ODBC connection.  If I follow the exact same steps
in trying to establish an ODBC connection on a Windows XP ...

Error:
SQLException caught: [Microsoft][SQLServer 2000 Driver for JDBC]Column index
7 is out of range.
SQLException caught:.

can someone tell me how to raise the number of Named Pipes on SQL 2000 SP3,
please? i am aware of http://support.microsoft.com/?id=165189 and the hereby
mentioned registry key, which is for SQL 6.0/65. but no one can tell me what
to use in case of sql server 2000, beside of ...

I'm use class.forName to load SQLServerDriver.  If I want to set the max
connections to other than the default, how do I do that?
Thanks,
 -- Frank

I am receiving the following error when attempting to run my database
application.  The batch file that runs this program uses a different
username and password than 'sa'.  I tried to login the 'sa' account
with Query Manager and received the 18456 error msg.  I reset the 'sa'

We are currently in the middle of piloting a new application usin
MSDE, and some of our users are getting the following SQLExceptio
when attempting to query the database. The exception occur
sporadically, and it only seems to happen after the application i

hi, i've just installed sql server2000 on my home pc, im using to connect to
a sql server at my work. My query analyser works fine, but enterprise manger
seems to freeze and ultimatly not respond when i try to open the data base
folder, I downloaded that latsest server packs, but ...

    If I give a user name or password having special character (mainly
semi-colon) then I cannot connect to the SQL Server. Following is the error:
       Login failed for user 'a`~!@#$%^&*()_+|-=[]'.
       TCP Provider: An existing connection was forcibly closed by the

Having 'Google-ised' I've found that there does appear to be a problem
connecting to an MSDE 2000 DB from a remote machine (either LAN or WAN), but
I haven't found what the concrete solution is.
It definitely appears to be a Windows inflicted problem, as I can connect to

We have written a thread to monitor whether the database connection is still
alive or not.
This monitoring thread executes a stored procedure, sp_TestDB, with ADO
_CommandPtr every 3 seconds.

I recently had to upgrade my WIN-XP SP2 OS harddrive. I am now getting the
following error message when I attemp to start MSSQL 2000 Developer edition
through Enterprise Manager or Query Analyzer: "A connection could not be
established to (LOCAL) Reason:SQL Server does not exist ...

we've created a java commercial application which uses MSDE and JDBC Driver
the question is how to deploy the driver in instalation package?
we would like to avoid the necessity of downloading the driver by each
customer according to the license.

Hi all,
I'm trying to build an application using MSSQL Server and Connection pool.
At my server.xml file I have:
<Context path="/sample" docBase="C:/myprojects/sample" reloadable="true" >