PHP Access Conection
I have spent the last coupl eof days trying to get php to talk to MS Access through dreamweaver MX, after searching acros the length and breadth of the internet I eventually found a bit of code that helped me get started.
I would love to see an extention to create the connection to MS Access
To enable me to use the record set functions
Good Luck
Comments
Try PHaKT
What you need is PHaKT - a free extension, which creates a whole new Server Model (PHP_ADODB) in your copy of Dreamweaver MX.
It's available from interaktonline
It will enable you to connect to a huge variety of databases with PHP, including MS Access, but also MS SQL Server, Firebird, PostgreSQL, Oracle and several others - though not SQLite as yet. Once the connection is made with the PHP_ADODB server model, rather than the built in PHP_MySQL server model, you will be able to use all the normal PHP server behaviors. The PHaKT model places two folders of pre-written php files into your site, which you will need to upload along with the rest of your files. It's really easy to use. I've even got it to work with PHP5, though a slight alteration is needed to get Firebird to work with PHP5 in this model. Access 2000, 2002 and 2003 all work perfectly with the extension. I have not tried it with Access 97.
Paul Taylor
You must me logged in to write a comment.