I'm trying to setup a dsn-less connection in CF5 connecting to MS SQL
servers.
If I used the following connect string:
"DRIVER={SQL
SERVER};SERVER=(10.100.100.100);UID=me;PWD=pwd;DATABASE=dbtable;APP=App;WSID
=WSID"
I get the following error:
ODBC Error Code = 08001 (Unable to connect to data source)
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
I've also added the port into the ip address, but still no luck.
I can setup a datasource in cf admin and have no problems.
Anybody have any suggestions?
Thank you,
Chuck Brockman
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
