[WinXP Pro SP2, SQL Server 2000 SP4, VS C++ 2005 Express]
A humble hello to all,
 I have spent days trying to simply connect to an instance of SQL Server
2000 SP4 from a program written in C++/CLI using VS C++ 2005 Express. I

We are in the process of migrating the application that runs our business
from Sybase ASE 12.5.3 to MS SQL Server 2005 SP x64
Our application is a large java application which runs on Redhat Enterprise
Linux 4, Tomcat, etc.

I would like to be able to perform a query
where the database to query is a parameter.
Can this be accomplished? I have tried various methods but none seem to work.
Thank's Everybody

I have developed a software which uses DBLib to access SQLServer 2000.
I tried if the same software will work with 32 bit version of SQLServer
2005 - there was no problem.
But now I have a customer who has a 64 bit version of SQLServer 2005 and I

My sql server 2000 has install two instance,one is a named,some days before
it can work well when connect to the database,but as the DBA has change the
instance environment and I can't conncet to the named instance as follow
instruction:

   I am using SQL Server 2005 Developer Edition, the application is used
ODBC to communicate with database, everything is OK in the beginning, but
when the application running and data is filled into the tables, the size of
the database increase, and now the size is about 11M, ...

On a SQL 2005 server I have set the max user connections to 500 and
restarted the SQL Services. The server is showing this as the current
running value.
However the user connections is reporting over 30,000 and sp_who

Looks like I inherited a little collation problem, and it's causing me
headaches.  This is a little involved, so please bear with me:
Most of the CHAR and VARCHAR columns in the tables of this database are set
to SQL_Latin1_General_CP1_CI_AS collation.  A few are set to

We have developed an application which uses Tomcat + ApacheSSL
installed on Server 1 and connects to a SQL SERVER 2000 database
installed on Server 2. They connect thru a SQL SERVER 200 JDBC
Microsoft Driver with SP3 (the latest one available). We had connected

I'm writing a small app to bulk load some data and receiving strange
results.  Some of the data contains non-standard alphabetic characters, like
the name Jose (with an accent over the e).  It is being loaded into the
table as JosT.  The column is a VARCHAR(50), and it seems to ...

This is more like two issues rolled into one, and I don't know whether
they are related. I am attempting to use the SQL Server 2005 JDBC
driver in conjunction with a third-party JTA transaction manager (JOTM)
to run distrubuted transactions involving a SQL Server 2000 database

I need to create two DSN's on one machine, both pointing to different
SQL Databases (but housed on the same remote server). One runs on the
standard 1433 port and the other on port 1075.
I have both of these setup, but I cannot use a different port in both.

Can anyone tell me what the cause of the error below is?
I have the client tools installed on XP Pro Svc Pack 2.0.  When I try to
connect to the server on the remote machine I get the error message below.
I have set the logins up correctly for the user id I'm using on the client

Ok, I'm pretty new to SQL Server.  I installed SQL Server 2005 Express with
extended option.
I'm able to connect to it using Management Studio Express  I was able to
create a new DB and create a login user "demo" with password "demo".  Gave

We are switching from DataDirect to Microsoft's JDBC driver and the
application code has not changed. the JDBC driver is making a prepared
statement call to the SQL Server and unpreparing the statement after
procedure execution.  The target is a SQL Server 2005 SP1 database on