This topic is locked

Problem with MS Access db

6/8/2008 8:26:29 AM
PHPRunner General questions
R
ragou author

Hello everybody.

I create a new project using application wizard and MS Access database type. Everything is fine when I test it on my computer, but when I upload it to the server I recieve an error message "Fatal error: Call to undefined function: odbc_connect() in /home/imaloedn/public_html/main/Stoyan/include/dbconnection.php on line 7". I don't understand where should I upload db1.mdb because the application obviousely is looking for it in a wrong place. I put it in the root, in the same directory but no result. Tried to find where is defined the path to the database, but alas. Can anybody explain to me?

P.S. Sorry for my bad English.

Regards:Zarko

J
Jane 6/9/2008

Hi,
please make sure that your server is Windows-based.

Support of the Access database is on the Windows-based hosting.

R
ragou author 6/9/2008

Unfortunately it's Apache. Thank you anyway.

R
ragou author 6/9/2008

Is it possible to import MS Access db into MySQL?

S
swanside 6/9/2008

Hi mate
Yep it is, and its dead easy and free.
http://dev.mysql.com/downloads/mysql/5.0.html

This will download you MySQL server
http://dev.mysql.com/downloads/gui-tools/5.0.html

You can use MySQL Migration tool to import an access db into your MySQL DB