Access and PHP

[casty]

I have developed an app for a client where customers will post listings online for later publishing in a print directory. The client wants the info stored in an Access database that he can download and export to a plain text file which he will work upon for publishing.

My difficulty is this: I wrote the app in PHP and it works fine on my local machine with a local Access db. However, the app does not work on the web server with the uploaded version of the db. I have placed the web host's assigned DSN at the appropriate place in odbc_connect; but the app hangs where the insert function is called. I don't even get error messages to let me know what is going wrong. When I run the same app locally again, it works fine; the database is populated with data, no errors.

I need help because this app is already a couple of days past the date when it should have been working. Anybody have any ideas?

[bastien]

can you show code for the connection? try and put an error check in there to see if the connection fails or if the problem lies elsewhere in the db

// Program to test connecting to a Microsoft Access ODBC Data Source
    if (!$connection = odbc_connect("postcard", "", "")){
        echo "eror connecting";
    }