note 37236 deleted from function.odbc-connect by cmb
| From: | cmb@php.net | Date: | Sun, 25 Aug 2019 07:54:51 +0000 |
| Subject: | note 37236 deleted from function.odbc-connect by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-211978@lists.php.net to get a copy of this message | ||
Note Submitter: TheFrenZ
----
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.