note 64027 added to function.odbc-connect
| From: | RayGarcia at osu1 dot php dot net | Date: | Thu, 06 Apr 2006 02:14:19 +0000 |
| Subject: | note 64027 added to function.odbc-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-107405@lists.php.net to get a copy of this message | ||
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.
----
Server IP: 64.71.164.2
Probable Submitter: 208.29.200.169
----
X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER
autolearn=no version=2.64
----
Manual Page -- http://www.php.net/manual/en/function.odbc-connect.php
Edit -- http://master.php.net/note/edit/64027
Del: integrated -- http://master.php.net/note/delete/64027/integrated
Del: useless -- http://master.php.net/note/delete/64027/useless
Del: bad code -- http://master.php.net/note/delete/64027/bad+code
Del: spam -- http://master.php.net/note/delete/64027/spam
Del: non-english -- http://master.php.net/note/delete/64027/non-english
Del: in docs -- http://master.php.net/note/delete/64027/in+docs
Del: other reasons-- http://master.php.net/note/delete/64027
Reject -- http://master.php.net/note/reject/64027
Search -- http://master.php.net/manage/user-notes.php