odbc_connect() failure

From: 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.bundle
Description = MySQL ODBC 3.51 Driver DSN
SERVER       = localhost
USER         = root
Password     = xxxxx
Database     = test
[Default]
Driver       = /Library/MyODBC/lib/libmyodbc3.bundle
Description = MySQL ODBC 3.51 Driver DSN
SERVER       = localhost
USER         = root
Password     = xxxxx
Database     = test


« previous php.db (#32095) next »