MySQL ODBC Problem

2003-07-01 Thread Jim McAtee
Han anyone run into this? I've got a W2k server running MySQL. I set up a MySQL database with a couple of tables and a MySQL user with password and access to that database. On another server running CF5 I install MyODBC 3.51 and create a System DSN pointing at the MySQL database. I enter the

Re: MySQL ODBC Problem

2003-07-01 Thread Jim McAtee
Just reread this. Should read: From CF, though, I can't connect to the database unless I supply a username and password. - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 3:54 PM Subject: MySQL ODBC Problem Han

Re: MySQL ODBC Problem

2003-07-01 Thread Matt Robertson
check in the mySQL permissions tables on the mysql server and look for any weirdness in the user, db and table permissions tables? restart mysql for any changes to take effect. --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc.

Re: MySQL ODBC Problem

2003-07-01 Thread Jim McAtee
, 2003 4:01 PM Subject: Re: MySQL ODBC Problem check in the mySQL permissions tables on the mysql server and look for any weirdness in the user, db and table permissions tables? restart mysql for any changes to take effect. --- Matt Robertson

Re: MySQL ODBC Problem

2003-07-01 Thread William Bowen
ODBC Problem Han anyone run into this? I've got a W2k server running MySQL. I set up a MySQL database with a couple of tables and a MySQL user with password and access to that database. On another server running CF5 I install MyODBC 3.51 and create a System DSN pointing at the MySQL database

Re: MySQL ODBC Problem

2003-07-01 Thread Jim McAtee
- From: William Bowen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 4:32 PM Subject: Re: MySQL ODBC Problem Try using ODBC Socket in CFAdmin to create the datasource. I had a problem similar to this when I installed CFMX, but never in CF5... YMMV

Re: MySQL ODBC Problem

2003-07-01 Thread William Bowen
Glad to help :-) will - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 3:46 PM Subject: Re: MySQL ODBC Problem Thanks, that did it. I was somehow under that impression that the CFAdmin wouldn't even see