I am trying to connect MS Access to SQL Server 2000 where the SQL Server is
in the DMZ and the PC with MS Access in the LAN.  I have opened ports 1433
and trying to open an ODBC connection to the SQL Server but it's not
happening.  I simply can't find the SQL Server at all using ...

Our java web application is running into a login failure issue as shown below
after a few hours of its run.
Login failed for user '<user name>'. [CLIENT: <IP Address>]
Please note that application makes several connections to database for its

I been having an issue trying to connect an Access database through SQL
Server as a Linked Server.
The crux of the problem is the Access Database (mdb file) has a Database
Password and this cannot be removed due to the database still being used by a

We're experiencing a intermittent problem with a J2EE application, MS JDBC
2005 1.1 driver, and SQL Server 2005.  The application opens a transaction,
issues a number of prepared statements in batches, and then commits.  The
problem we are seeing is that the transaction hangs up. ...

How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?

first of all, i hope this is the correct newsgroup for this question :)
I've hit a scenario where I'm execuing a view from inside some .NET code.
I've set a timeout of 10 minutes, although this should be more than enough.
However, the query times out. When i connect to the ...

Hi ng!
The facts:
SQL Server 2005 is installed on a Windows 2003 server within a domain. Every
XP-Clients can connect to SQL Server via ODBC without any problems.