Hi! I am desperately trying to get the following combination to run:
MySQL (Win32 3.23.44) on host_1.something.tld ColdFusion Enterprise 4.5.1 SP2 for Windows on host_2.something.tld MyODBC 2.50.39 for NT/2000/XP on host_2.something.tld The MySQL-DB ist hosting one database named TEST with one table 'produkte' (for now). I granted a new user 'administrator' with password 'something' all privileges on the database. Then I installed myodbc on the ColdFusion machine and set up a system DSN named MYSQL, server host_1.something.tld, DB TEST, user 'administrator', pwd 'something'. Whenever I restart the ColdFusion service, I can actually verify the MYSQL ODBC-source successfully and run queries on the tables therein. After some time (just a few minutes usually), verification fails completely however, and the very same query, which did return results before, now just returns an error message. Here's the error message of the query: Error Diagnostic Information ODBC Error Code = () Unknown connection error for the data source, 'MYSQL.' SQL = "SELECT ProduktID, Name, Beschreibung, LetztesUpdate, Bemerkungen FROM produkte" Data Source = "MYSQL" ColdFusion Admin returns on verification-attempt: The connection to the data source failed. Check the following to resolve this problem: Are the data source settings configured properly? Did you provide valid security information in the data source settings ? For some databases the ColdFusion Server may need to be logged in under a special NT account rather than the default System Account. Use the Windows NT Services Control Panel to change the account the ColdFusion Server service is using. When I run some other ODBC-access-client like StarOffice 5.2 on host_2.something.tld, I can get access to the MYSQL datasource, although something seems to be a bit messed up there, too, as the 'TDX mysql Driver default configuration' (the configuration dialogue of myodbc) keeps popping up on the first two or three connection-attempts and I have to re-enter the 'something' password, before getting a successful connection. This password is however still entered correctly in the main-configuration of myodbc... >From my point of view it looks like some kind of time-out problem, as it's working fine for the first few minutes after the first access to the database from a freshly started ColdFusion service but fails some time after that. Has anybody got this combination to run smoothly (sorry, only interested in Win32-environments!)? How did you manage to get it to run and which versions of MySQL and myodbc do you use? Did you change anything in ColdFusion like timeout-Settings or whether to maintain db-connections or not? One more thing I noticed: The MYSQL-driver doesn't appear in the dropdown-list for ODBC-drivers under the "ODBC Data Sources Available to ColdFusion"-section of ColdFusion Administrator. However, the datasource MYSQL with the 'MySQL'-driver is still listed there, it's only verification which fails. Please help - I'm now experimenting with this mess for more than two days already and can't exactly pin down the source of all evil ;) Greetings, Markus --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
