My apologies if you recieve this twice. I haven't recieved the original message via the list yet. Chad
------- Start of forwarded message ------- From: chad <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: www.webcorelabs.com Subject: Remote MyODBC connection Date: 1/18/2002 5:24:51 PM We have been running a MySQL database on the same server as ColdFusion was on without too much trouble (The Merant mySQL driver seemed to have troubles so we switched to a myODBC mySQL Driver). Now I'm setting up a new webserver that will access a database on a remote machine and I am unable to access the database from ColdFusion. The datasource fails to verify and a cfquery prints out the following (for the MyODBC driver): Error Diagnostic Information ODBC Error Code = 08S01 (Communication link failure) [unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I don't think I can use UNIX sockets to connect to a remote database. What do I have to set to tell ColdFusion or the MyODBC driver to use TCP? By the way the `mysql` command line tool lets me access the databases from the machine CF is running on and PHP pages work fine. Both boxes have Slackware 8.0 (2.4.13 kernel). The MySQL server reports Ver 3.23.39. The ODBC driver is version MyODBC-2.50.39. CF is version 5.0 Apache Server version: Apache/1.3.20 (Unix) Thanks, Chad -------- End of forwarded message -------- ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
