ID: 16812 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Bogus Bug Type: ODBC related Operating System: window 2000 advance server -PHP Version: 4.0CVS-2002-04-24 +PHP Version: 4.0CVS-2002-04-2 New Comment:
Please make sure your ODBC control panel has this DSN defined. From what it sounds, your data source isn't being defined which makes this not a bug for PHP. Previous Comments: ------------------------------------------------------------------------ [2002-04-24 22:32:07] [EMAIL PROTECTED] I use : Server:window 2000 advance server IIS 5.0 PHP version :php-4.0.6-Win32 set DSN in Data Source(ODBC).User DSN =test and point to Microsoft Access (*.mdb) when i use this code $db=odbc_connect("test'","",""); $rc =odbc_exec($db,"select * from pass"); while(odbc_fetch_row($rc)){ print(odbc_result($rc,1)."<br>"); } It has error : Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in F:\works\work\webpage\test\t.php on line 20 Warning: Supplied argument is not a valid ODBC-Link resource in F:\works\work\webpage\test\t.php on line 21 Warning: Supplied argument is not a valid ODBC result resource in F:\works\work\webpage\test\t.php on line 22 I try change add dsn in system dsn that not work and say same error messages. It try it in window98,window 2000 Professional,window me. It work. Please help ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=16812&edit=1