Hi;
   I'm writing a application which access the SQL SERVER 2000 by "SQL
SERVER Driver for JDBC SP3".
I create a thread class to fecth data from database,code like blow:

I have an intranet application running on IIS 6.  It accesses SQL Server 2000
data and the SQL Server is on the same server.  I know that it's not great to
use IIS on the SQL Server, but we're behind a firewall, have a pretty small
user base, and everything's been working fine ...

What is ODBC tracing?

Hi;
I'm installing an application that requires a JDBC driver for SQL Server.
The thing is I am running SQL Server 7.0 and a look at Microsoft seems to
show there are lots of these drivers for SQL 2000 but not for 7.0

When I accessed query analyzer I got the following error:
[ODBC SQL Server Driver][TCP/IP Sockets] SQL server does not exist or
access denied
I had been able to access this feature with no problems until now.

Hai,
I used sqlservr -m to start the server in single user mode , how to get to
multi user mode.
Thanks,

I'm looking for some docs to instruct me how to setup log shipping in a SQL
2000 Standard environment.
Thanks

I'm trying to set up a DSN and get a 18456 error
Here is what I do
start->programs->administrative tools->data sources (ODBC).
On system DSN sheet I press add

I am not sure if this is the right place to post my problem. If not so, pls
do advise me of the right group.
Here is my problem:
I have this problem with SQL server. All of a sudden the insert, updates does

I am using a DTS package to insert data into a SQL table. This has worked
correctly for the last 2 years. However when I run the code now I get a
Timeout error. I have rebooted the server with no success. If I try and run
the data into a temporary table it works fine.

I'm having trouble troubleshooting a remote query using OPENROWSET. For some
reason I can get OPENDATASOURCE to work with a given connection string but
using OPENROWSET with the same connection string fails. I'm a bit baffled.
It seems like it should work basically the same way ...

I have a scheduled task that executes a program that, among other
stuff, every morning connects to a SQL Server that requires a login by
network login id. The problem is that, even if that scheduled task runs
as the network user, it doesn't work if that user is not logged on.

I have SQL (MSDE2000A) installed on a W2003 server.
I can connect to the database OK using either SQL or Windows authorization
from a W2000 (SP3) machine or from an XP Home (SP2) machine. But connection
from an XP Pro machine (SP1) fails every time - unless I specifically define

I have a CGI web application that is connecting to SQL2k sp3 server using a
system ODBC DSN to display data from tables on a web page.
These tables are being populated by another application that is using .net
SqlConnection object to insert data.

I have two xp sp2 machines(one desktop with sql server running, the other is
a virtual pc, on the same domain), I'm trying to connect between the two
using the dtcping.exe tool from ms
the virtual pc has vs2005 etc installed and I can't get it to run a