Reply to Re: [PHP] Access and PHP

Your name:

Reply:


Posted by tg-php on 08/03/05 17:47

Just looked into this recently and here's a brief rundown of what I've found:

1. If you run PHP on a non-Windows system, your only option seems to be making a connection to a remote ODBC data source (hosted on a Windows machine presumably). There was something..err.. ODBTP (?) that would work on linux to connect to remote ODBC connections

If you run PHP on a Windows server, then you have the following options:

2. ODBC connection via DSN
3. DSNLess connection (you can do this with a DB abstraction layer like ADODB)
4. COM connection (requires Access be installed on the server and, in my opinion, is the worst solution out of the group due to it's resource use)


There doesn't appear to be a good direct way to read Access files on a linux machine. I may have come across a commercial Access driver ($$$) for linux, but can't remember. If I did, I would have dismissed it fairly quickly as 'free' is more my budget right now :)

If you need links to the stuff above, let me know and I'll try to dig up some. I also have a script I wrote using WinBinder and ADODB on a Windows box to hit an Access database, pull data, scrub it, then insert it into a MySQL database via ODBC.


-TG

= = = Original message = = =

I am looking for some resources to use my Access Databases with PHP, anyone have a good link?

David


___________________________________________________________
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация