access to mysql odbc connection

[venkatesun]

Hi! I am trying to convert my access database to mysql available in x10hosting. I tried to give the host name as mysql.x10hosting.com but could not connect to the host. may i know where i could be wrong. Can i do so that my access tables or converted to mysql tables using ODBC driver. Thank you.

 

[galaxyAbstractor]

you need to use localhost as host

 

[venkatesun]

No. It is not helping. Because, I am trying to convert MS-ACCESS file from windows environment to mysql database available on x10hosting.com Localhost is not working. is there any other solution is the name given mysql.x10hosting.com ok?

you need to use localhost as host

 

[galaxyAbstractor]

No. It is not helping. Because, I am trying to convert MS-ACCESS file from windows environment to mysql database available on x10hosting.com Localhost is not working. is there any other solution is the name given mysql.x10hosting.com ok?

are you trying remote access? Because that is blocked, so you have to do it on the server.

 

[venkatesun]

yes. i am trying remote access. If it is blocked then what is the other alternate easiest way to accomplish the task of exporting the MS-Access table to mysql table remotely?

Actually i am doing the project on php and mysql and javascript.

I wanted to do the work offline and later transfer the data online by a temporary connection to internet. So that any transction takes place can be updated on a interval basis on to the web-site using ACCESS to mysql transfter utility and ODBC. and there is no need of consistant net connection. I thought this can be achieved by working on ms-access and later transfer it to mysql. Any how thank you for your support.

are you trying remote access? Because that is blocked, so you have to do it on the server.