ID: 16812
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [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