via MS SQL Server driver configg'd in the Admin or via ODBC datasource (configg'd in ODBC Datasources CP and then via ODBC socket in the CFMX Admin?
The reason I ask is that when I upgraded our servers to CFMX *all* of our datasources that were MS Sql Driver completely blew up. the only way I found to fix the problem was to eliminate the datasource mapping, set one up in ODBC CP and then remap using ODBC Socket. now they work fine, and we haven't had a hiccup since. HTH will ----- Original Message ----- From: "Brook Davies" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 6:56 AM Subject: Remote SQL Server and intermittent connection > Hello, > > I have a CFMX server which speaks to a remote SQL Server 7 Box via the > TCP-IP using the IP address of the remote server. This works fine during > testing and most of the time, but quite often the connection to the SQL > Server can not be made. > > Is there anything I can do to make this connection more reliable? > > Brook > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
