Share » Forums » Developer » how to connect msaccess database

how to connect msaccess database

how to connect msaccess database

Wednesday 02 July 2003 1:46:01 am - 3 replies

Author Message

Paul Borgermans

Wednesday 02 July 2003 2:48:29 am

imho, msaccess is not fit for driving an entire content management system. MsAccess is an personal-or-single-user dbms, too often abused for applications where a real RDBMS should be used.

On the otehr hand, you could try to write a driver in ezpublish for msaccess.

--paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Srinivas Rao

Wednesday 02 July 2003 6:38:55 am

Dear Paul Borgermans,

Thanx for the input.. I completely feel the same way about MS-Access. Whil our real objective is to use SQL Server 7.0 / 2000 as the RDBMS, we wanted to try out ezPublish's capability and scalability on working with MS products. Hence we are testing the same using MS-Access. The Ultimate objective is to try and use MS-SQL Server 7.0 / 2000 as the RDBMS, Can U throw some insight as to how i can achieve the same..?? either on MS-Access or on MS-SQL Server..??

Your suggestions and help are valued..

Thanx in advance.

--Srinivas.

Frode Marton Meling

Tuesday 08 July 2003 7:21:09 am

If I have understood the eZ kernel correct, one sollution is to write a eZodbcDB class as an extension. You have to write it the same way as eZMySQLDB is written.

You probably also need to do some changes to eZDb to be able to support it (this I'm not sure, it depends on how good the code is).

I'm not sure thow if the odbc support in PHP is sufficient to run eZ over odbc.

I'm solving a similar problem now, but I'm going to use the MySQL database for all eZmodules, but I'll make modules to access data from i.e MS SQL.

Frode Marton Meling

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu