Click to See Complete Forum and Search --> : SQL error with ODBC


annick
07-10-2001, 03:11 AM
I'm using PHP4, with Apache on NT.

ODBC links are OK

In my PHP
$connection=odbc_connect($base,$util,$mpas);

When I try to connect on Access base, I have this error :

Warning: SQL error: [Microsoft][Pilote ODBC Microsoft Access] Le moteur de la base de données Microsoft Jet ne peut pas ouvrir le fichier '(Inconnu)'. Il est déjà ouvert en mode exclusif par un autre utilisateur, ou vous devez avoir l'autorisation de visualiser ses données., SQL state S1000 in SQLConnect

When I try to connect on AS400 base, I have an other error :

Warning: SQL error: [IBM][Pilote ODBC de Client Access (32 bits)][SQL DB2/400]Echec de liaison. COMM RC=0x5, SQL state 08S01 in SQLConnect

On my own poste, I works with WIN98, and I use EasyPHP, Odbc links like than on the server NT, and all is OK !

Anon
07-11-2001, 06:54 AM
i do not understand french... but i do believe i am having a similar problem... and my odbc is setup correctly according to the tutorial about connecting to an access database on your page.

however i dont have the problem all the time, just when i wish to add information into a access database