>I installed recent version of mySQL,myODBC,PHP on my W2000 machine
>yesterday
>I can not access to an access file via ODBC
>It gives me Warning: SQL error: [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., SQL state S1000 in SQLConnect
>in c:\inetpub\wwwroot\php\ietest.php on line 7
>
>Warning: Supplied argument is not a valid ODBC-Link resource in
>c:\inetpub\wwwroot\php\ietest.php on line 10
>
>Warning: Supplied argument is not a valid ODBC-Link resource in
>c:\inetpub\wwwroot\php\ietest.php on line 10
>
>Here is the code I tried
><html><head><title>PHP Test</title></head>
><body>
><?php
>
>//connect to database $connectionstring = odbc_connect("VIDEO","kimh","1234");
>//disconnect from database odbc_close($connectionstring);
>?> </body></html>
>
>VIDEO is an access file and it can be seen from system DSN on ODBC
>and I set username and password for it.
>
>I tried it without username and password and $connectionstring =
>odbc_connect("VIDEO","","");
>It does not work either
>
>And I delted the "video" file from system DSN and set it to User DSN
>and It gave me
>Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source
>name not found and no default driver specified, SQL state IM002 in
>SQLConnect in c:\inetpub\wwwroot\php\ietest.php on line 7
>
>Warning: Supplied argument is not a valid ODBC-Link resource in
>c:\inetpub\wwwroot\php\ietest.php on line 10
>
>Warning: Supplied argument is not a valid ODBC-Link resource in
>c:\inetpub\wwwroot\php\ietest.php on line 10
>
>What do I do?
Sir, I take it that the Access database consists of linked tables
connected to MySQL tables via ODBC. If so,
http://www.iserver.com/support/virtual/mysql/odbc/.
Make sure that all MySQL base tables (the tables the Access tables
are linked to) have primary keys. If you still get error messages,
try adding timestamp columns to the base tables.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
MySQL list magic words: sql query database
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
