Hello,
i am currently conducting a study comparing the effectiveness and efficiency of ASP and PHP at various levels of functionality.
Among other things, I wish to test database connectivity. while I am OK with connecting PHP to MySQL, ASP to mySQL and Access, as far as I know, the only way of connecting PHP to Access is via ODBC , which is not a prticularly efficient and speedy way of establishing connection.
Am I right or is it possible to use a different type of connection?
Thanks in advance for your help,

Philippe

__________________
Philippe

As far as speed is concren you are right but i think this the only solution till i writing but its too reliable as far as security is concren

no, odbc isn't the only way to connect to access.

you should try out ADOdb, a database class library.

http://www.databasejournal.com/featu...le.php/2222651

I have check the adodb lib but it also connects to ms-access via odbc_connect() and its also required data source name (DSN) it is actuly an odbc connection what is the diffrence just tell me?

I don't think there's a difference, then. Using the Adodb class probably just gives you a much more user friendly interface to the database than using the odbc functions. And yes, I do understand that "more user friendly" is a relative term.

Part of the problem is that Microsoft's databases are only accessible as COM objects or via the ODBC or OLE DB interfaces. PHP doesn't have an OLE DB extension, nor do I know of one being developed. I don't think that Access is a robust enough database to merit the writing of an Access-specific extension, either. Most people who use a MS database for any sort of website are probably going to use SQL Server.


I suggest writing your PHP test site using a database abstraction layer, such as the PEAR DB wrappers. That way, you write your script just once. The interface to the database is the same regardless of which database you're actually using. That is, you make function calls on a generic DB object, not to something specific like MySQL, SQL Server, ODBC, or Postgres. Behind the scenes, you set up which database the generic functions will forward the calls to.

This means that you only have to write the code once, and should your database change, you just swap out the implementation files without touching a single line of the actual program code.

I think this gives you the most flexible and efficient mechanism for testing multiple databases with the same code. At least, in PHP.


Take care,

Nik
http://www.bigaction.org/

hey iam learning php come you please help me
how do i connect ms access
do the database have to be in specail folder?
do have install apache could i not just test it through my website which support php?

please help