I am getting the following error message, when we were executing the stored
procedure from one database to another database using the link....
stored procedure is executing succesfully in the database,but it is failing
from the code...

I want to use  window authentication  for JDBC connection ,but I don't know
how to do ,
In Mircorosoft 's "SQLServer 2000 Driver for JDBC Help" I view the page
which title is "Using the SQL Server 2000 Driver for JDBC on a Java 2

I need help :-))
We use an SQL 2000 Server.
in the Systemmanager one Prozess with PID is sleeping, no databese
context, and I can not cancel the Prozess.

   I have sql server 2000 on a XP/SP2 machine.. with XP firewall active.
But I cannot connect to sql server. I receive this message "Unable to
connect to server xxxxxx: SQL Server does not exist or access denied"; or
Login failed for user xxxxx. With QA same problem... I created ...

Hello
Can you tell me when the JDBC driver for SQL 2005 beta will be available?  
I've tried using the 2000 driver but only keep getting errors such as the one
below:

Our applications (MS Access 2000), all running from the same machine, access
data from SQL server 2k via odbc. I mean setting up linked tables in MS
Access. The sql server,  runs on a different machine, support mix mode
authentication.

Has anyone managed to get update queries working on a mysql linked server.

We have this issue on some systems but not on others. The code queries a
table that stores a file in an image column. On some systems this exception
is thrown intermittently; for some records this query fails 1 of 8 times,
sometimes it fails 7 of 8 times. It seems like there is less ...

Is there a connection property string or API call that can be used to
"set ansi_warnings off"?  
Thanks very much!
Troy

I was wondering if anyone knew of a way to dynamically link a table from a
COBOL (I think) database into a SQL database.  I have an ODBC driver that I
have been using to link the tables into Access, but would like to do the same
in SQL Server 2000.

Is there a way to make an ODBC connection automatically fail to an
alternative ODBC connection if the 1st fails?

I have an application that uses batch updates to insert data into the
database.
The sequence is basically:
Statement.prepareCall()

Services or applications using ActiveX Data Objects (ADO) 2.0 or greater may
intermittently return empty recordsets on queries that should be returning
valid results. At the time the problem occurs, the same queries successfully
return the expected data when run from non-ADO sources ...

We are having one client PC running Win XP. SQL Server has been set to
Windows Authentication, TCP/IP 1433, Windows 2003 (!).
Via Cisco VPN we are making a connection. IAS has been configurated, so the
local user profile doesn't matter. The server recognizes the user that is

I have a problem in SQL Server 2000. I need to connect as a linked server
the AS400 database (V5R3).
I read in the SQL documentation about the SP_ADDLINKEDSERVER stored
procedure and the linked server from SQL Manager but I'm not to be able to