How to connect to access data base from php 5.3.4 without using odbc connection?
-
Before going down this road, you should seriously why you think Jet/ACE is a suitable back end for a web app -- it is not, in my opinion, as it was not designed for that purpose (there are threading issues and other things that make it problematic for anything other than the simplest applications).David-W-Fenton– David-W-Fenton2011-04-03 16:16:40 +00:00Commented Apr 3, 2011 at 16:16
Add a comment
|
1 Answer
The literal answer to your question, connecting to Access using something other than ODBC is to use OLEDB. See PHP-OLEDB.
If your problem is that you're running PHP on a platform that doesn't have JET ODBC drivers (i.e., not Windows) then you should probably consider using SQLite or more Linux-friendly embedded databases.
If you're dead-set on accessing a JET database from Linux, then take a look at mdbtools.
2 Comments
Mario
I don't have choice about the db type because the company have other application using this access common db and about the machine it's a windows machine but the problem is with the X64 ODBC drivers
ta.speot.is
@Mario There are now 64-bit ODBC drivers microsoft.com/downloads/en/… if that doesn't solve your problem try something like information-management-enabled.blogspot.com/2005/11/… but perhaps in reverse.
