Server: W2K server with SQL 7.0, all WU patches applied
Client: W2K professional, all WU patches applied
I have an application that resides entirely on the server, only a
shortcut is installed on the client. It connects to SQL using mixed

Hello NG,
the code below works, but if i add
the outcommented part of it (the Uid and Pwd section) the
function fails and returns false.

I can't perform a distributed transaction between a remote
server to the central server.
I have 3 sql server 2000 enterprise edition. 2 of them are
installed on win2K server (LOCAL1, LOCAL2) and the other

I had to make some changes to SQL Server tables; not knowing about the Linked
Table Manager, which I guess I should have used to refresh the connection, I
instead deleted the connection to the table then re-established it.  The
minor annoyance here is that any time I query ...

Greetings to readers,
I got this problem with both SP2 and SP3 of the JDBC driver for SQL Server
2000:
The recursive call made in method

Hope someone can advise me (a humble Java Programmer) of a problem I
am having.
We have a char(8) field in a MS SQL Server 7 DB, some of the data is
only 7 chars though.

I am facing a strange problem using SQL server 2000 version with JDBC
driver for SQL server 2000 version SP1/SP3. I have a table with
name-value pairs and I populate the table from a properties file. When
I am doing the insertions in a for loop, it is failing intermittently

Hello.  I have to run many sql scripts each day.  Sometimes I'll have 100+
scripts to run.  The scripts always come in a folder numbered in the order
they need to be run (001 - ScriptA, 002 - ScriptB, etc.).
I've been running them all manaully one by one so that I can look for ...

I run a query through JDBC driver, it takes me about 60 seconds. But I simpy
cut/paste the query to the query analyzer (on the same machine), I got less
than 1 second.  Why got so big difference?
I am using DBCP, MS SQL JDBC driver with SQL server win2k.

I have just set up SQL server on our system.
I would like to be able to connect from accross the internet, like I can
with exchange. (Using EM)
What do I have to do in order to do this?

I am getting this error in the Event Viewer and the clients are unable to
connect to the SQL server.  What is wrong?
PLEASE HELP!!
Scott

I am using SQLServer 2000 on multiple Windows operating systems and
the application accessing the database are also on multiple Windows
OSs namely Windows 2000 server, Windows 2003 Server, Windows 2000 and
Windows XP. The issue is only noticed when the database resides on

MS OLE DB Provider for SQL Server Error: Invalid authorization specification
This is a basic 3-tier system, front end, data broker, database.  The front
end software is written in VB 6.  There are many front end users.  This
error is coming up on one computer only.  No users can ...

I have to transfer an existing SQL-Server with all his databases and users,
to an new Server with Windows 2003. The new mashine has get the same
computername and ip-adress as the previous mashine, so that the client pc's,
wich access to the server with ODBC, after the switching, ...

When creating a SQL Server ODBC connection via Data Source applet on a WXP
workstation, when clicking the drop down menu to select the server, two
instances of the same server appear. We recently migrated our SQL server to
new hardware. Turned off the old server and gave the new ...