php-developer-list | 2000111

[PHP-DEV] PHP 4.0 Bug #7819 Updated: Trouble Finding Datasource From: arnoldg <email protected>
Date: 11/15/00

ID: 7819
User Update by: arnoldg <email protected>
Old-Status: Open
Status: Closed
Bug Type: ODBC related
Description: Trouble Finding Datasource

I figured out the problem.

Previous Comments:
---------------------------------------------------------------------------

[2000-11-14 16:32:15] arnoldg <email protected>
I am using PHP 4.0.3pl1 in conjunction with Apache 1.3.12 (Win32) under MS Windows 98 Second Edition. When trying to connect to a Sybase Adaptive Server Anywhere 7.0 datasource running on Win98 I receive the error:

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in functions.odbc.php on line 46
ODBC connection failed.

I successfully used the same code when running PHP 4.0.1 compiled with OpenLink ODBC support in conjunction with Apache 1.3.9 under Linux when connecting to a Sybase Adaptive Server Anywhere 7.0 datasource running on WinNT.

The database server is named "dbweb" and the datasource name is "webservices". I can successfully connect to the database using the "Test Connection" button in the ODBC Control Panel. The DSN is setup as a "System DSN". Also, I can connect to the database using the Interactive SQL Monitor provided by Sybase.

Any suggestions would be greatly appreciated.

---------------------------------------------------------------------------

Full Bug description available at: http://bugs.php.net/?id=7819 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>