note 38471 added to function.odbc-connect

Connect to an MS-Access Database on the Network via ODBC Apache 2.0.47 with PHP 4.3.4 running on Windows XP Pro If you encounter the error "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect" you should make sure to have the following done: The ODBC-link must be a System-DNS and not a User-DNS. Configure your ODBC-link and then modify your configuration with regedt32. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC_INI and open your ODBC-link. The field DBQ contains the path to your database. This path must be without Drive-names (e. g. "M:") so change it to "\\Server\folder\database.mdb". This setting is changed each time you modify your ODBC-configuration using the Windows-tool, so make sure you do this afterwards. Then you go to the Services-Section in your Systemmanagement. Select the properties of your Apache module. In the login-section you have to make sure you login with a valid User-Account for your Network-Server. Please note that this way you still have no permission to access linked tables within the linked database Funny enough all this is not necessary on Win98. ---- Manual Page -- http://www.php.net/manual/en/function.odbc-connect.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+38471 Delete -- http://master.php.net/manage/user-notes.php?action=delete+38471&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+38471&report=yes Search -- http://master.php.net/manage/user-notes.php