odbc_connect() failure
| From: | Andy Estes | Date: | Wed, 17 Dec 2003 04:32:02 +0000 |
| Subject: | odbc_connect() failure | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32095@lists.php.net to get a copy of this message | ||
I'm running the MySQL-supplied MyODBC driver (3.51) on top of iodbc on OS X 10.3.1. I am running Apache 2.0.48, MySQL 4.0.15, and PHP 4.3.4. I am making the following call:
$odbc_id = odbc_connect("myodbc3", "root", "xxxxx");
I get the following result:
Warning: odbc_connect(): SQL error: [MySQL][ODBC 3.51 Driver]Unknown MySQL Server Host 'test2.php' (1), SQL state S1000 in SQLConnect in/Library/Apache2/htdocs/test2.php on line 3
It is attempting to use the filename as the host (test2.php), and obviously failing to resolve it. I have verified that my DSN is correctly configured, as I can make ODBC connections through the CLI odbctest utility and successfully run queries. This also suggests to me that the problem does not lie with the MyODBC driver itself. Furthermore, I have attempted to use mysql_connect(...), which works fine, so I am also ruling out a MySQL configuration issue (such as localhost not being in the grant tables). Does anyone know what else I should be looking for here? I will paste the contents of my odbc.ini file as well if this would help anyone.
Thanks,
Andy
;
; odbc.ini configuration for MyODBC and MyODBC 3.51 Drivers
;
[ODBC Data Sources]
myodbc3 = MySQL ODBC 3.51 Driver DSN[myodbc3]
Driver = /Library/MyODBC/lib/libmyodbc3.bundleDescription = MySQL ODBC 3.51 Driver DSN
SERVER = localhost USER = root Password = xxxxx Database = test[Default]
Driver = /Library/MyODBC/lib/libmyodbc3.bundleDescription = MySQL ODBC 3.51 Driver DSN
SERVER = localhost USER = root Password = xxxxx Database = test