note 64027 deleted from function.odbc-connect by bjori
| From: | bjori@php.net | Date: | Thu, 06 Apr 2006 09:27:14 +0000 |
| Subject: | note 64027 deleted from function.odbc-connect by bjori | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-107431@lists.php.net to get a copy of this message | ||
Note Submitter: Ray Garcia
Reason: in docs
----
Just an extra note for those of you who are trying to connect to a Win2k System DSN and getting this
error:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid
path. Make sure that the path name is spelled correctly and that you are connected to the server on
which the file resides., SQL state S1009 in SQLConnect in d:\apache\cm\creaart.php on line 13
Trust it, it really is a permission issue. Go to the mdb file created and right-click on Properties
and go to the Securities Tab and add 'Everyone' to the permission file and give it
'Full Control'.
Voila! The program will now work.
Of course you must know how to add a System DSN. If you don't read below for the answer.