I using PHP 4.2.3 on Apache server. I tried to use ODBC to connect Access97. While it only works when database is on local machine. When database is remote, it shows the error message like :
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 e:\program files\apache group\apache\htdocs\vtracker\billreport\odbchandler.php on line 8
I just use ODBC to create a system DSN, then coding like
$con=odbc_connect($DSN,$Username,$Password) ;
I don't know it is the problem of Access97 or PHP, do you have some idea?thank!
