I'm trying to link from sql2005 (64-bit) to sql 7 (32-bit).
I get the following error:
OLE DB provider "SQLNCLI" for linked server "sql7" returned message
"Unspecified error".

On my machine I have installed :
Visual studio 2003 - .NET 1.1
Visual studio 2005 - .NET 2.0
All the application made by VS2003 don't work if I try use SQL 2005 (all

I am using "com.microsoft.jdbc.sqlserver.SQLServerDriver" driver to connect
the SQL Server 2000.
Everything is ok if there is one request to the SQL server.
When there are more than one requests to the SQL server, exception was

   Do you people know how to connect MSSQL 2005 express edition with Vb6
ADODB? As I know MSSQL 2005 express connection string is specific the
database path. How do I write the connection string for ADODB?
Thanks in advance,

I have a problem. We have a SQL Database that connects to 2 clustered
servers. The 2 servers are turning off alternatively almost like the plug is
being pulled. There does not seem to be anything wrong with the servers
themselves. Can SQL send anything that would turn a server ...

Trying to extract data from two databases on different servers... I know how
to write Select statements to get data from them seperately but have not
managed to join the two together.
Can anyone help with this issue?

This only happens on a particular user's machine so far. the user is using
ms access, using odbc link to connect to SQL Server 2000 SP3a on W2k server.
With the MS Access running , suddenly the error happend when i ping the sql
server i can get its ip addr

we have written a vb.net program using SQL Server 2000 SP4 over OLEDB.
Our customer has a network which is sometimes quite instable. So we did
some tests in our office, because we wanted to help our customer by
redisigning some of our SQL calls.

Using the new beta 2 JDBC driver I can connect successfully to SQL Server
2000 using Windows authentication.  I can also execute a simple select
statement.  However, when I attempt to execute a stored procedure, the
execUpdate statement gets a java.lang.NullPointerException.

I am getting the following error ...
Connection failed:
SQLState: '28000'
SQL Server Error: 18452

I used the following set of instructions to enable XA transactions on our
SQL box:
For Window 2000:
-----------------------

I'm using the latest (beta 2) jdbc driver to connect to an Sql Express 2005
database.
I'm preparing the following sql statement:
SELECT md_database.database_name, md_database.desc_key,

Trying to set up jdbc/MS SQLServer on XP. I get this message when I test the
conection in java. I'm actually moving code to a new box. I've used the test
code under w2k with no problems.
Thanks for your help

When I use JDBC driver for SQL Server 2000 (sp3) to access SQL Server 2005
in server cursor mode (selectMethod=Cursor), there will be an error (as
below) returning for any select statement.
"[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular

I got error "R_notSupported" from PreparedStatement.setAsciiStream(int,
InputStream, int) method when I'm using SQL Server 2005 JDBC driver
(beta 2). The same code works fine with SQL 2000 driver.
Does it mean PreparedStatement.setAsciiStream hasn't been implemented