|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2007-08-21 07:38 UTC] jani@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Tue Oct 28 03:00:02 2025 UTC |
Description: ------------ I am trying to access an MS Access DB on the web, I have created a DSN name for it (through the server's control interface). The connection script works fine on my own personal computer and I can insert and delete records. Not so when I try on the web server. The DSN name I assigned is KeretlawDB, and it stores the path of the .mdb file on the server (..\db\keretlaw.mdb) Reproduce code: --------------- $link = odbc_connect ('KeretlawDB', '', ''); if (!$link) { echo "Connection to ODBC failed: ", odbc_errormsg(), "<br>"; } else { echo "Connection to ODBC successfull. NO PASSWORD REQUIRED <br>"; } Expected result: ---------------- There should be a connection established, and I should be able to retrieve / insert information. Should have echoed: Connection to ODBC successfull. NO PASSWORD REQUIRED Actual result: -------------- Connection to ODBC failed: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.