note 64027 added to function.odbc-connect

From: 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

« previous php.notes (#107405) next »