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 .
Php with ADOdb
Moderator: General Moderators
Re: Php with ADOdb
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.
This can be possible by using XML, Export/Save XML MS ACCESS database and Import to MySQL if your case allow this.
-
kamal.ishdeep
- Forum Newbie
- Posts: 4
- Joined: Mon Feb 22, 2010 9:38 am
Re: Php with ADOdb
First thanks for reply bro. I tell you the scenario.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.
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.
Re: Php with ADOdb
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.
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.
-
kamal.ishdeep
- Forum Newbie
- Posts: 4
- Joined: Mon Feb 22, 2010 9:38 am
Re: Php with ADOdb
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 rightSalaria 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.
Re: Php with ADOdb
Yes, But I suppose you are running your MS access on different machine and can export XML to it. Isn't it?
-
kamal.ishdeep
- Forum Newbie
- Posts: 4
- Joined: Mon Feb 22, 2010 9:38 am
Re: Php with ADOdb
Ya, Definitely MS access db is on defferent machine and i was using DNS to create connection from offline server.Salaria wrote:Yes, But I suppose you are running your MS access on different machine and can export XML to it. Isn't it?