1/25/2002 10:02:29 AM, chad <chad @ webcorelabs . com> wrote:
>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?
>
>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
>
I got it, Finally! I just had to edit the /opt/coldfusion/odbc/odbc.ini .
In the corresponding [Database] block I just had to add the line
SERVER=192.168.1.1
The driver defalts to UNIX sockets (and so localhost) unless a
remote server is specified. I just assumed the "Server Host Name"
in cfadministrator was how it was specified. It appears this driver
does not reconize the line (Servername=192.168.1.1) generated
by cfadministrator.
I hope this helps someone in the future.
Good luck,
Chad
< chad @ webcorelabs . com >
Tonight one happy Jr Sys Admin
Webcore Labs Inc
______________________________________________________________________
Macromedia ColdFusion 5 Training from the Source
Step by Step ColdFusion
http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion
------------------------------------------------------------------------------
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.
