note 37236 added to function.odbc-connect

If you encounter the error: "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect" Windows with PHP, running under IIS/PWS, PHP runs under the anonymous user, INET_USR_"server" (were "server" is your servername). This user has no read access in the ODBC System DSN tree in the registry. With regedt32 open HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC_INI and give read access to every ODBC entry you want to use with PHP. Beware: With every change to a ODBC system DSN, the rights on that ODBC system DSN are gone again, and you have to change the rights again manualy. Under Apache, PHP runs under the System account and you wont have this problem. ---- Manual Page -- http://www.php.net/manual/en/function.odbc-connect.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+37236 Delete -- http://master.php.net/manage/user-notes.php?action=delete+37236&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+37236&report=yes Search -- http://master.php.net/manage/user-notes.php