Re: Paradox Database

[Yohimbe]

Three directions occur: DBD::ODBC,
Perl driving OLE interaction, or
(ugliest) Dumping to CSV and DBD::CSV

--
Jay "Yohimbe" Thorne, alpha geek for UserFriendly

[coolmichael]

Hmmm... I don't know anything about ODBC, or OLE. The database is used every day and gets updated every day. I was hoping to upload the database to the webserver everyday, and have cgi scripts that interact with it.

I wish I had some sort of database training, then it would probably be a lot easier. I'm just a university dropout who manages a bookstore. Our database is in Pardox. I want to let people search it from the web. Can't afford a web guru...

[kschwab]

If you go the ODBC route, via either Win32::ODBC or some other module:

Corel has info here on doing the generic setup of ODBC drivers for Paradox.

Beyond that, you'll need someone that knows a bit of perl, a bit of sql, and a bit of web authoring.

If this is all too much, you may want to upgrade to Paradox Version 9, which has some simplistic database publishing to the web built-in to the product.

[sierrathedog04]

ODBC when you are not using Perl really isn't that bad. If you are running Windows then go to Control Panel/ODBC Data Sources and see if you have any Paradox ODBC drivers installed. If not then go to Microsoft's web site and download the Jet engine which should install the Paradox ODBC drivers.

Once the Paradox ODBC drivers are installed then you can point and click to set up your Paradox file as an ODBC data source. This second part should be self-explanatory once you are within the Control Panel/ODBC Data Sources screen.

Then you will need to begin to work with Perl's ODBC modules, which I have never used.

I would say that even if you are a newbie to ODBC you should be able to install the ODBC drivers for Paradox and the Paradox data source. It might take you an afternoon if there are unexpected problems.

Microsoft's Jet engine will probably install properly on your computer without you modifying any defaults. "All of life is a narrow bridge. The important part is not to be afraid." -- R. Nachman