Page 1 of 1

Php with ADOdb

Posted: Wed Feb 24, 2010 12:53 am
by kamal.ishdeep
Hello i am professional php developer. Now a days i m working on a web in which i m giving sync application. Sync process will import data from ms access database into my mysql database. I know this can be done by odbc. But the problem is Linux server on which my website is hosted and this server doesn't support odbc library for shared hosted websites (I dont have dedicated server and even cant purchase.

So can anyone suggest to how this issue can be solve and is it possible with ado db?
if Yes then please tell me.

Thanks in advance .

Re: Php with ADOdb

Posted: Wed Feb 24, 2010 11:27 am
by Salaria
Hi, Can you please elaborate how you sync data?

This can be possible by using XML, Export/Save XML MS ACCESS database and Import to MySQL if your case allow this.

Re: Php with ADOdb

Posted: Thu Feb 25, 2010 2:09 am
by kamal.ishdeep
Salaria wrote:Hi, Can you please elaborate how you sync data?

This can be possible by using XML, Export/Save XML MS ACCESS database and Import to MySQL if your case allow this.
First thanks for reply bro. I tell you the scenario.
Actually, i m conneting ms access database (.mdb file) using odbc in php, then retrieving
and importing these data into mysql server.

This appication is running properly at offline server, since offline server is windows based xampp server, so no problem at all. But online linux server, on which my web is hosted doesn't support odbc on shared hosting packages. So i m looking for any alternative like ado db. But it also not working.

As you suggest me XML, or any import export utility. Actually i m developing sync tool on my own web and can't use any third party tool to import data.

So Suggest me any alternative if you have.., Thanks for reply. :wink:

Re: Php with ADOdb

Posted: Thu Feb 25, 2010 8:08 am
by Salaria
Ah! ok.

So, there is limitation of your server as well. I don't think PDO library would work too. That's why for sync most of the application uses standard formats like XML, JSON these can be easily created and updated.

Well, I'll look on other alternatives and keep you updated if found any.

Re: Php with ADOdb

Posted: Thu Feb 25, 2010 10:12 am
by kamal.ishdeep
Salaria wrote:Ah! ok.

So, there is limitation of your server as well. I don't think PDO library would work too. That's why for sync most of the application uses standard formats like XML, JSON these can be easily created and updated.

Well, I'll look on other alternatives and keep you updated if found any.
Ok, but can you tell me how xml can be useful to sync data. B'coz even xml will be middle layer to keep data. So to import ms access to xml, we'll have to use odbc like utility, that will not work in my application. Am i right :?:

Re: Php with ADOdb

Posted: Thu Feb 25, 2010 10:25 am
by Salaria
Yes, But I suppose you are running your MS access on different machine and can export XML to it. Isn't it?

Re: Php with ADOdb

Posted: Thu Feb 25, 2010 11:27 am
by kamal.ishdeep
Salaria wrote:Yes, But I suppose you are running your MS access on different machine and can export XML to it. Isn't it?
Ya, Definitely MS access db is on defferent machine and i was using DNS to create connection from offline server.