From my research, it appears that it is not possible to have a linked server
created in SQL Server 2005 x64 use a 32-bit DSN (i.e. created with a 32 bit
driver).  The answer is that I need to create a 64-bit DSN in order to
create a linked server in SQL Server 2005 x64.  The ...

I need transfer data from MySQL to SQL Server 2000. Does anyone know how to
make a linked server from SQL Server 2000 (SP3 or SP4) to MySQL? If it's
possible, I need install MySQL client software in my SQL Server box. Am I
right? What kind procedures I need follow?

I get this message when I try to change a record: Transaction cannot start
while in firehose mode!
Anyone now how to solve this problem? I can read/write to my table, but I
cant change records.

SQL Server 2005 JDBC driver connecting to SQL 2000 database all on Windows XP
Professional SP2.
If the stored procedure call SQL Escape syntax "{call proc(a1, a2)}" is used
and the statement contains one or more line terminating characters (carriage

What is the different between MSSQL 2005 Enterprise and Standard edition.
Thanks
Jodie

Is there a way to establish an exclusive SQL 2000 connection, i.e. only
allow 1 user to connect?
In Access I am able using a file DSN with Exclusive=1.  Is there a similar
property to use in the connect string or ADO connection object (I do not see

Is there a way to avoid the following problem:
I have a database created in SQL 2000. I detatch it from the SQL 2000
instance. I attach it to a SQL 2005 instance (I can see the compatibility
mode is SQL 2000). I detatch it from the SQL 2005 instance. I try to reattach

We recently installed SQL Server 2005 on machines that also had SQL Server
2000 present. When the SQL Server Browser service is running on any of these
machines, ALL machines on our network start having a problem detecting the
names of SQLServer instances from SQL Server 2000 ...

Should the transaction isolation level persist across the reuse of a
connection from the connection pool?
From my experiment it does persist and I was not expecting it.
I was under the impression that "sp_reset_connection" will tear down all the

Hello I have a problem to connect to the SQL Server 2005 Express Edition. I
have the Visual Studio .Net 2005 and the SQL Server Management Studio Express
CTP but I cannot connect to the Database from the client to the database
instance through the network. Could be a Domain ...

I have an application that connects to a SQL 2000 database on another
machine.
We are upgrading this to work with SQL 2005 or SQL 2000.
The application uses SQLDMO objects and ADO objects (written in C++)

I have a Java app that is accessing a table on a MS SQL Server.
Yesterday, the location of that table changed (was "ip address\\old",
now "ip address\\new").  I changed my code but the connection is still
failing.  I debugged the code to verify my DriverManager.getConnection

Just a question about MSSQL 2005- When MSSQL 2005 released by Microsoft.
Are there a lot of users using this MSSQL 2005?
Thanks,
Jodie

With SQL 2005 jdbc driver i connect to 2005 database using parameter
selectMethod=cursor.
       //The procedure generates an id(long) and returns it.It also inserts
id and name into a table

Hi, all.
I just want to know how to get the CTP JDBC Driver 1.1? Thanks a lot.
Jet