Does SQL server support external link database like DB2 or Oracle through
ODBC?
Any information is appreciated.

I am attempting to use Enterprise Manager to connect to SS 2000 across the
Internet. The machine running SQL Server is behind a NAT router.
Enterprise manager shows that the TCP/IP port that SQL Server is using is
1061. I have forwared port 1061 on the router to the machine ...

I have an application that used an access database and I am currently
migrating to SQL Server.  The software is designed to use Odbc object
found in the .Net framework version 1.1.  I have a simple select
statement that is driving me nuts.  It works fine with the Access

The environment is ASP.Net accessing the SQL server through IIS.
While, I've been told that .Net does not create a cache the behavior I'm
observing for intensive purposes looks as if there is a cache. I'm at a bit
of a loss to explain this behavior. Also, if I wait five or ten ...

Is it generally true that local named pipes are better than TCP/IP? Are there
any drawbacks?
Regards, Per.

when I run an import process that imports a few thousand records,
everything works well for the first ~1000 records (sometimes more,
sometimes less), and then I keep getting the following:
   java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for

system administrator asked me to modify my VB application to authanticate
itself for ISA when wants to connect  to an outer sql server.
the system administrator dont want to open fully the port 1433 (from inner
LAN), and also dont want to set my application name at ISA.

Pal,
Anyone can give me clue how is to do MSDE connection via
ODBC.
My application is coded by VC++ .NET 2003

I am converting an Access 2000 app to use SQL server instead of access
tables.
There is a lot of work ahead to get it where I really want it - especially
after browsing this newsgroup and doing some research.

I need to connect to SQL Server 2000 across the Internet. SQL Server is
behind a NAT router. What port(s) do I need to forward to be able to
connect with Enterprise Manager and ADO?

We have been using Microsoft SQL Server JDBC Driver 2.2.0040 in our products
to connect to SQL Server 2000 Standard Edition SP3 (8.00.760).  Our
functional testing went fine but we have run into serious performance
degradation under simulated heavy loads.

I was using SQL server service manager with no problem.
I've installed "Business Contact Manager" and now service manager cannot
connect to the server.
Thanks for any advise.

I have run into an issue with attempting to process a large result set
returned by SQL Server 2000.  This issue disappears when we reduce the amount
of data in the database that is available to the query by deleting records
and reappears when we add the data back.  I've been able ...

I am trying to instal MSDE 2000 on a Windows XP Pro SP2 machine. I type in
....
"Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA
PASSWORD>" at the command prompt and the MSDE setup begins to take place. At

I am attempting to make 1000 simultaneous osql connections from one Windows
2000 server with sp4 to another Windows 2000 sever with sp4 that is hosting
a SQL 2000 server database with sp3a, but I reach an upper limit of about
30 - 40 connections.