Dear All,
I am trying to connect to an MSAccess database using the odbc functions. I managed to connect to the database and run queries using odbc_exec(). However, I have two remaining questions:
Passwords: I tried securing my database with the Access .mdw system. I set the .mdw as the default group file, and inserted the name/password both in my ODBC default login and in the odbc_connect arguments. Both resulted in a "Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] You do not have the necessary permissions to use the '(unknown)' object. Have your system administrator or the person who created this object establish the appropriate permissions for you., SQL state 42000 in SQLConnect in " error. How should I pass my authorization info to msaccess? Is it possible to use db-side security with php/odbc/msaccess?
Qualifier/Owner: If I want to use some of the other features, such as odbc_tableprivileges or odbc_primarykeys, there are arguments name 'qualifier' and 'owner'. What are they and What should I do with them? I I leave them out I get a 'wrong parameter count' (contrary to the specs for the privileges as given on <!-- m --><a class="postlink" href="http://www.phpbuilder.com/manual/function.odbc-tableprivileges.php">http://www.phpbuilder.com/manual/functi ... ileges.php</a><!-- m -->), and when I fill in "" or "%" I get "Warning: SQL error: , SQL state 00000 in SQLPrimaryKeys in c:\www\confidential\dBfunc.php on line 11" errors.
Can anyone Help me?
Thanks in advance,
Wouter van Atteveldt
-------------
SPEC's
Using PHP Version 4.0.5
OS: Win2000 (recognised as Windows NT 5.0 build 2195)
Webserver: Apache/1.3.20 on my own machine
I am trying to connect to an MSAccess database using the odbc functions. I managed to connect to the database and run queries using odbc_exec(). However, I have two remaining questions:
Passwords: I tried securing my database with the Access .mdw system. I set the .mdw as the default group file, and inserted the name/password both in my ODBC default login and in the odbc_connect arguments. Both resulted in a "Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] You do not have the necessary permissions to use the '(unknown)' object. Have your system administrator or the person who created this object establish the appropriate permissions for you., SQL state 42000 in SQLConnect in " error. How should I pass my authorization info to msaccess? Is it possible to use db-side security with php/odbc/msaccess?
Qualifier/Owner: If I want to use some of the other features, such as odbc_tableprivileges or odbc_primarykeys, there are arguments name 'qualifier' and 'owner'. What are they and What should I do with them? I I leave them out I get a 'wrong parameter count' (contrary to the specs for the privileges as given on <!-- m --><a class="postlink" href="http://www.phpbuilder.com/manual/function.odbc-tableprivileges.php">http://www.phpbuilder.com/manual/functi ... ileges.php</a><!-- m -->), and when I fill in "" or "%" I get "Warning: SQL error: , SQL state 00000 in SQLPrimaryKeys in c:\www\confidential\dBfunc.php on line 11" errors.
Can anyone Help me?
Thanks in advance,
Wouter van Atteveldt
-------------
SPEC's
Using PHP Version 4.0.5
OS: Win2000 (recognised as Windows NT 5.0 build 2195)
Webserver: Apache/1.3.20 on my own machine