I have an Access database with a SQL Server back-end.  I am new to SQL, so
the problem I have been having is a real puzzle to me.
I have created an Access query called ‘qryIRCasesUnrouted’, which finds
records in a table called ‘IR’ that do not have a matching key in another

I get the following error after trying to do update to an Oracle 9i table
from SQL Server 2000.  :
The operation could not be performed because the OLE DB provider 'MSDAORA'
was unable to begin a distributed transaction.

I need some help.
I have to connect from external network to MSSQL server. There is no problem
to conect to first (main) instance of SQL (just forwarded port 1433 on
firewall). But another instance is using port 1033 to exchange data (I am

After having tried to insert wrong date into datetime field i got "The
year, 3, is outside the range allowed by the SQL Server" which is ok, but
following query issued to the same connection got "The DBMS returned an
unspecified error" and further queries got "Connection reset by ...

I'm using sql server 2000 in Delphi.
I have no any problem on my connection string in local network.
But, I can not make remote connect with this connection string.
I made port forward for 1433 and 1434 ports.

I've been running against SQL2k on a Win2k server which is also the
DC.
We just installed a new dedicated SQL box, and it is not a DC, but
exists in the same Domain.

OK..Ive successfully connected to sql server and can execute stored
procedures...if the result set is an integer it prints the result set
but has a bunch of errors:
Execute: com.microsoft.jdbc.base.BaseResultSet@fc9944

I am using a front end VB application to connect to sql server desktop
engine. Connecting to the (local) server work perfectly. However,  I need to
connect to a sql server on a machine on my network that is also running the
sqlserver destop engine and access a database on that ...

I have a large union query that produces a "timeout expired" error. I've
changed the timeout settings to 600 seconds but I still get the message.
My query and underlying database are characterized as follows:
a) two fairly large database tables (1.5m and 0.7m rows respectively)

I am getting an error "[Microsoft][SQLServer 2000 Driver for JDBC]Row update
failed" while updating an int value on result set. Below is the code snippet
that i use in java. The error is occurring occasionally. Not able to
replicate.

Hi, I'm having problem with a workstation connecting to the Server's SQL
Server. The workstation can access the server's hard drive via share and
TCP/IP seems to be working. But the workstation just can't access the
server.

I am struggling with what surely should be a very simple process. I am
simply trying to establish a basic linked server connection to a number of
foxpro dbf files.
What is the required syntax within Enterprise Manager for both the ODBC

How can I select IP address(es) for listening of MSSQL on server with two
(or more) nics?
Thank you for ideas.
Pavel Balus

when i execute this i get
Error connection to database: java.sql.SQLException: [Microsoft][SQLServer
2000 Driver for JDBC]Specified parameter values not supported for method:
createStatement

Are there any standard things to check for when using SQLServer with JDBC
and tomcat/java servlets?
We have an application with an unreasonably large memory footprint. The java
programmers swear it is an SQL Server memory leak. I can't see a similar