Hi everyone I really needd some help!

Here is the situation... I've got a intranet server with my Access DB on it and I've declared it as an System DB source (in the config tools) as said all over hundreds pages...

When i try to connect myself with the instruction $idconnexion=odbc_pconnect("BDAbn","","")

BDAbn = alias of my DB int he ODBC DataSource of the server.

it tells me : "Warning: SQL error: , SQL state 00000 in SQLConnect in c:\inetpub\awwroot\newinfra\Query Files\QueryElecFrame.php "

I think the server finds my DataBase 'cause when i try somethg else as DSN name, it tells me that no database has been found...So i think the server finds it but there's somthg wrong with the connection between my computer and the server...

Does someone can help me?? Is there a way to do the connection without declaring the Db as a DataSource on the server??

Thx

Bidi 🙁

    Here is a link to a page that explains how to connect to a Access Database through ODBC and DSN.
    http://php.weblogs.com/odbc

    Here is a link to a page that explains how to connect to a Access Database NOT using DSN.
    http://php.weblogs.com/COM_php

    Just in case you ever want to move your Access Database to MySQL here is a link to MyODBC. I have used it to make databases I have designed truly multi user. You can also keep your Access forms and link them to the MySQL database so your users never know.😉

    I hope this helps.

    K0ma

      Try a different user name for the access database. The default username for a connection to an MS Access database is "Admin" and a password of "" (that is without the whole workgroup thing set up, in which case the password probably won't be ""). You can't even connect to an MS Access database using VB6 with a blank user name.

        Write a Reply...