Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Unanswered: Passing Pervasive to MySQL and vice-versa

    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

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Feb 2004
    Posts
    3
    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

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  5. #5
    Join Date
    Feb 2004
    Posts
    3
    Many thanks again

    Rob

    Originally posted by mirtheil
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •