Hi all,

I have an interesting project at hand.

We wish to allow our customers, and business partners to be able to update their own details on our database.

This database is written in pervasive (we're on the 2000 engine at the moment, i'm sure we'll upgrade to 8 shortly).

My intention, for security purposes is to write the front end in php sitting on a mysql database. Daily, I want our in-house pervasive database to refresh with the externally facing mysql (live) one.

Is this possible?
Is it easier to cut mysql out altogether? (if so how).
Can anyone recommend a platform and webserver? (I intend to write the coding in PHP).

As you can tell this is at a very initial stage and i'm way open to suggestions and ideas.

Thanks!

Rob

With PHP, you can use ODBC to access the data on the Pervasive engine. If you're using Pervasive V8.5, you can even use Linux as the PHP/Web server and have Linux as the Pervasive client.

Hi!

Many thanks for the reply!

Do you know if the Pervasive Engine has to be on the same box as the Web Server or if the requests can be passed remotely?

Many thanks again!

Rob

In most cases, the Web server can pass requests to a remote database server. The Web Server will basically be seen as a client to the database server.

Many thanks again

Rob