You might want to try using the tcp/ip network library instead of Named
Pipes - in general people seem to have more success with it. You have to
adjust the network library (the network protocol choice) on both the server
and the clients (including the CF server); the server can support more than
one library simultaneously (different clients connecting with different
libraries) but a client can use only one library to connect to a given
server. On the server you adjust this with the install/setup tool, on the
client there's something called the Client Configuration utility that does
this. All assuming your SQL server is set up to talk tcp/ip..
-----Original Message-----
From: Melanie Maddix [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 8:33 AM
To: CF-Talk
Subject: RE: Strange ODBC Error
Hi Mike;
We would get that error whenever the connection to our SQL database failed,
like is someone decided to reboot the database server while the site was
still running.
Melanie
-----Original Message-----
From: Mike Connolly [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 6:07 AM
To: CF-Talk
Subject: Strange ODBC Error
Fellow CFers,
Has anyone ever seen an intermittent ODBC error, like the following:
"ODBC Error Code = 01000 (General Warning)
[Microsoft][ODBC SQL Server Driver][Named
Pipes]ConnectionTransact(GetOverlappedResults())"
It occurs seemly at random, and is resolved by refreshing the current CF
page in the client's browser.
It doesn't appear to be isolated to one CF application, but to any hosted on
our server.
CF: 4.52 Enterprise
IIS: 5.0
Op.Sys: Windows 2000
SQL Server: 7.0
Anyone got any ideas to a likely cause(s)?
Regards
Mike
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
