Php with ADOdb

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
kamal.ishdeep
Forum Newbie
Posts: 4
Joined: Mon Feb 22, 2010 9:38 am

Php with ADOdb

Post 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 .
User avatar
Salaria
Forum Commoner
Posts: 34
Joined: Fri Feb 13, 2009 2:50 am
Location: India
Contact:

Re: Php with ADOdb

Post 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.
kamal.ishdeep
Forum Newbie
Posts: 4
Joined: Mon Feb 22, 2010 9:38 am

Re: Php with ADOdb

Post 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:
User avatar
Salaria
Forum Commoner
Posts: 34
Joined: Fri Feb 13, 2009 2:50 am
Location: India
Contact:

Re: Php with ADOdb

Post 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.
kamal.ishdeep
Forum Newbie
Posts: 4
Joined: Mon Feb 22, 2010 9:38 am

Re: Php with ADOdb

Post 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 :?:
User avatar
Salaria
Forum Commoner
Posts: 34
Joined: Fri Feb 13, 2009 2:50 am
Location: India
Contact:

Re: Php with ADOdb

Post by Salaria »

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

Post 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.
Post Reply