|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2002-04-24 22:32 UTC] sunisachai at yahoo dot 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
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Dec 03 15:00:01 2025 UTC |
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