Bug #16812 Updated: odbc_connect not work! Please help urgently

ID: 16812 Updated by: sunisachai@yahoo.com Reported By: sunisachai@yahoo.com Status: Bogus Bug Type: ODBC related Operating System: window 2000 advance server PHP Version: 4.0CVS-2002-04-2 New Comment: I set odbc right,but it dose not work . In this afternoon i read some webpages and they suggest me to set something like this: odbc_connect("test","","",SQL_CUR_USE_ODBC); That work! Thanks Previous Comments: ------------------------------------------------------------------------ [2002-04-25 00:08:39] kalowsky@php.net 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. ------------------------------------------------------------------------ [2002-04-24 22:32:07] sunisachai@yahoo.com 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