8/28/2002 11:32:10 PM, Stacey Brewer <[EMAIL PROTECTED]>
wrote:
>
>I have need to use Coldfusion 5 pro with MySQL 4 Max on
Linux.
>I also need transaction support.
>
>The Merant driver will not support transactions.
>
>The MyODBC driver does support transactions, yet I can't
get it to work.
>I am using Mandrake 8.2 (current patches) w/rpm install of
MyODBC.
>
>Any help would be appreciated. I get a general error on my
pages.
>The DSN does not verify in CF Admin.
>
>I have modified the odbc.ini file to manually add the Data
Source.
>This still does not work.
>
>- Stacey
I'm not sure if this will help but I wrote it up late last
year when I was having issues with unixODBC.
/chad
When you go to set up CF on a box A and try to connect to a
database on box DB with MyODBC you will be unable to verify
the datasource and a cfquery will get an error like:
ODBC Error Code = 08S01 (Communication link failure)
[unixODBC][TCX][MyODBC]Can't connect to local MySQL server
through socket '/
tmp/mysql.sock' (2)
Solution:
Edit /opt/coldfusion/odbc/odbc.ini find the block for the
datasource like:
[istock_dev]
Description=istock_dev_site
Database=istock_dev
Servername=192.168.1.1
Port=3306
Driver=/opt/coldfusion/lib/libmyodbc.so
Change it by adding one line ( SERVER=192.168.1.1 ) so it
looks like:
[istock_dev]
Description=istock_dev_site
Database=istock_dev
Servername=192.168.1.1
SERVER=192.168.1.1
Port=3306
Driver=/opt/coldfusion/lib/libmyodbc.so
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
------------------------------------------------------------------------------
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.
