I have a VB6 client application connecting to a SQL2000 server(SP3). The
program alway stops  after it processes around 200 records in the table and
getting a connection error. The client PC has MDAC 2.6 installed and other
parts of the system doesn't encounter this problem.

I've got a SQL Server 2000 database with a table that has two Foreign Keys.  
They are declared as such in the database.
When I use the latest JDBC driver (sp3) to get the MetaData info about these
Foreign Keys, I'm runing into what appears to be a bug.  Here's a snippet

I've Googlet alot, but can't find my solution.
1. I cannot telnet on port 1433
2. SQL Server Network Utility shows 1433 on the TCP/IP.
3. netstat -an doesn't show anything using port 1433

I have an app which connects to SQL Server via an ASP (thru IIS). At
times I get SQL errors which are listed on the site below -
http://support.microsoft.com/default.aspx?kbid=328476
I need to know the following

hello, I'm using Visual Foxpro and ODBC / sql server 2000.
How should i manage conections ?  opening and closing it on each form ? or
opening at the begining of application and closing it at  application finish
?

Hi Firends,
I want to check that particular SQl Server instrance is running or not. SQL
Server may be behind firewall and listening on PORT 1433. If a particular SQL
Server becomes offline its status should be known.

(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail ...

Is there any way to run a procedural TSQL script through Java?  Here is the
scenario:  I have an XML file that contains SQL statements to be executed.  I
have a Java program that reads the XML file, retrieves a statement as a
string, and executes it using the JDBC statement ...

have a question about Classpath on a linux machine.
I set the default profile to include the path to the msbase.jar, msutil.jar
and mssqlserver.jar.
PATH="/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/opt/j2sdk1.4.2_04/bi

I have an application in Java WSAD 5.1 which uses the SQL Server
database. I use the microsoft jdbc type 4 driver.
The query execution time for a particular query is 800 MS from the java
program while in SQL query analyzer it is 100 MS.

I'm really looking for an explaination rather than an answer...
I can't connect to sql instances on a specific server using the normal
structure of <servername>\<instancename> but I can connect to
<servername>,<portnumber>.

I'm using Access as a front end to a SQL table.   What format do I need to
put the SQL fields in to appear as percentages in Access.

I undstand that if you choose to dynamically assign a port number to an
instance this is a once only operation performed the first time that instance
is started and from then on it always attepts to use that port number.
Having just started with a new company I'm trying to work ...

Hi All,
I have recently upgraded our W2K Server to W2K3 Server after applying SQL
Server 2000 SP3a first.  Since upgrading the server, all client machines
(XPsp1) can connect and operate with the SQL database and also run the VB6