java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
       at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
       at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

I have a SQL Server from which I need to query a view in a Oracle database.
I have created a linked server connection to the Oracle machine. Oracle,
version 9i, is running on Unix.
Now when I try to use the linked server connection I have some problems.

My SQL*Server 7 server was working fine this morning...  All of a sudden
anyone that is set up using DHCP to get IP Settings can't connect to any
databases...  If I change them to a static IP Address it works fine...
Can't remember the exact message but it was something along the ...

Is there a system table within SQL Server that will display information about the current connections made to the db?  IE, username, IP they are connecting from, application they are connecting with, etc?
Thanks in advance,
- D

Is there any trick to setting up a System DSN to connect to a SQL 6.5 Sever that is in a different domain.  The domains are trusted.  I've tried every type of authentication but my Win XP system just can't get a DSN to connect again the SQL Server that is running Win NT4 SP6.  Is ...

I'm monitoring our SQL Server over the weekend to see what is happening with the Ecomm login account that allows nurses to renew licenses online. Using the standard trace template which has 2 events, "Audit Login" and "Audit Logout", I find that the average over the weekend for ...

Can anybody tell me how to create a new data source which connect to a SQL
Server db under Tomcat? I followed the steps described in the book-tutorial
"Jakarta Struts Live" but it not seems to work...
merlinO

Since couple of weeks, we got this error in event viewer
and it make the sql server not accept anymore connection
after 2 or 3 days.  We need to stop and restart the sql
service.  

I have a SQL Server Personal Edition installed in a PC running Windows XP
Prof. I can be accessed using Query Analyzer perfectly using SQL Server
authentication. However, I am unable to access it from another computer
using Query Analyzer. That computer also runs Windows XP Prof. ...

I need to create a system DSN SQL connection (Data Source) on my machine to
a server that is a domain controller in a different domain in preparation
for a C# program I'm writing. It is running NT 4.0 server with SQL 6.5 SP6.
I have an account on that domain but I can't get ...

I am using Microsoft SQL Server 2000 Driver for JDBC Service Pack 1
and on occasion receive:
"ServerXact exception: java.sql.SQLException: [Microsoft][SQLServer
2000 Driver for JDBC]Connection reset by peer: socket write error

       We are developing a CRM application using Delphi Front end &
Sqlserver as back end which is
        residing on Windows 2000 server. I need a best possible solution,
if this CRM app fornt end is         installed in  different Location and

 I am using the T-SQL commands "BEGIN TRANSACTION", "COMMIT TRANSACTION"
and "ROLLBACK TRANSACTION" via the Statement.Execute method instead of
setting the autoCommit feature of JDBC.  
We often have objects that contain transactional updates that may be called

I used the following syntax and was able to add a linked server to an
Informix database.
EXEC sp_addlinkedserver
@server = 'Server1', -- defined in

We recently upgraded our SQL 2000 server from Windows 2000
server to windows Server 2003 Small Business Edition.
After the upgrade, the existing server connections still
work (we're using it for Great Plains), but there's a