I am experiencing issues where it appears that SQL Server 2000 is
dropping connections when meta-data is requested from a Cold Fusion 7
server.  We have attempted to troubleshoot this error on the application
side and have exhausted all possible scenarios (different drivers,

Issue:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Hi Group,
This is my probelm, I have a SQL view which holds prices to 2 decimal place
in the Management Console they are displayed to two decimal place i.e. 1.99.
However when I run an ODBC report the values are all to mutiple decimal

I am using Win2k server(sp4)  and Sql 2000(sp4). When register from
enterprise manager by using windows authentication , it was showing 'cannot
generate sspi context'.
When I use FQDN to register, it work fine

I am working one application that is using OLAP Server for reports. I am
rendering HTML tables for reports. This application is using Windows based
authentication.
Connection String for OLAP is placed into Registry. I am not passing user id

We have built an application (VB 6 with a SQL 2000 backend database)
in-house and from time to time, we get the dbnetlib error message. This error
message seems to happen when the machine is just idle and is driving me nuts.
The error message doesnt seem to have the issue while ...

I have an application written in Powersoft Power++ that uses ODBC to
connect to a sql server database.
The program has a search screen that generates an SQL statement like
this:

Is there a way to view the prepared statments submitted by an application
through JDBC driver in profiler or through any other source?
-A

I am not sure exactly which newsgroup to post this to so I will ask here
with the hopes that someone either can answer or at least point me to a
better newsgroup to pose the question.
We have a single SQL Server 2000 server machine. We are increasingly adding

We have a .NET web service running on one of our servers connecting all our
application users to a SQL Server 2000 database with service pack 4. Every
now and then we experince a NETWORKIO wait type which then causes all our
application users to receive a "Object reference not ...

I have developed on application that connects to a sql database using tcp/ip
Sometimes the connection may get broken, for example with laptop users.
What is the most efficient way of detecting when this happens, instead of
the string of sql errors that we get.

I am familiar with constructing ODBC connect strings for SQL server
databases using "SERVER=" and "Database=" clauses.  If the SQL server is
running a named instance, instead of an unnamed one, do you put the instance
name in the "SERVER=" clause, or is there another clause for ...

I have SQL Server 2000 installed on a computer running Windows 2000 Advanced
Server.
I'm using enterprise Manager from the Windows 2000 server to try to connect
to another SQL Server 2000 installed on Windows 2003 server .

I'm trying to create a linked sever from SQL 2000 to an Access 2000 database
on a remote PC with the following command:
EXEC sp_addlinkedserver
@server = 'MyEventLogging',

I set up my SQLExpress server using Windows Authentication only. Now when I
try to create a user account using Username and Password, the connection
returns the error: Not a trusted connection. Does this have something to do
with my previous server setup or is there a general ...