You rule Aaron! I owe you a beer.
The below fixed the problem:
-----Original Message-----
From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 11:12 AM
To: CF-Talk
Subject: RE: Problems setting up a remote DSN to SQL Server
Hey Bob,
Make sure that the production web server uses TCP/IP as it's default network
library and not named pipes. Named pipes will fail as you described below.
You can check this by going to start--programs--MS SQL--Client Network
Utility. Check to see what the default network library is, if it's Named
Pipes, change it to TCP/IP.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.