-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Friday 08 February 2002 04:58, Ian Tait wrote: : -----Original Message----- : From: fluffy bananachunks [mailto:[EMAIL PROTECTED]] : Sent: 08 February 2002 04:56 : To: CF-Linux : Subject: Transactions not supported by driver : : : SuSE7.3,CF5,MySQL-MAX 3.23.44-5/BDB : : I was all excited that I made some 'big boy' progress tonight by learning : how to set up and use transactions in MySQL using the TYPE=BDB tables... : After mucking around with it via CLI for a bit, I decided, "Woohoo - lets : go learn CFTRANSACTION!". Well, needless to say, but no such luck. : : Error Diagnostic Information : Transactions not supported by driver : The driver for the data source 'TEST' does not support database : transactions. The use of the CFTRANSACTION tag is therefore not permitted : with this data source. : : Bah. Humbug, even. : : I'm using the default CF5 install MERANT MySQL drivers in the CFAdmin. : I've searched and can't find any reference to newer or upgradable drivers : that support MySQL Transactions... Can anyone point me in the right : direction for this? : : TIA : Geo - - : Hiya, : : You could try myodbc : http://www.mysql.com/products/myodbc/ : : Appears to support transactions, but I've not tested that. : : Good luck, : : Ian : - - Ah, thank you very much. For some reason I got it in my head that MyODBC was a Windows thing *shakes head*
I ended up physically changing the /opt/coldfusion/odbc/odbc.ini to Driver=/usr/local/lib/libmyodbc-2.50.38.so from Driver=/opt/coldfusion/lib/CFmysql15.so .. Any way to add this to the dropdown in the CFAdmin? Thanks again! Geo -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8Y8hX6lWSWPFnGFARAg1MAJ0Q5BrG6UoOdhWhYUo7TbmSJ0HsjgCfZJYU h54k7gRJijZ7pka4X4GTboU= =PDko ______________________________________________________________________ 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.
