topic Re: DBD choice in Operating System - OpenVMS

DBD choice

Cfabio — Tue, 25 May 2010 14:46:44 GMT

Hi

I need an advice.
I've a Alpha Operating System, Version V8.3 and a software (OSC Radiator) that I have to connect to a database using perl. So I need to choose a database and the relative DBD to talk with the DBI.

Which free database can I use? what is the more simple choice?

Regards

Re: DBD choice

Craig A Berry — Tue, 25 May 2010 19:12:53 GMT

Your query does not make clear whether the database will be running on VMS or not.

Probably the simplest would be DBD::SQLite since the whole database is embedded in the driver. I've never tried to build DBD::SQLite but I have heard of SQLite working on VMS.

Re: DBD choice

Cfabio — Wed, 26 May 2010 11:34:30 GMT

Yes, you're right; the database will be running on VMS.

Ok for DBD::SQLite; I'll try to build it.

Bye

Re: DBD choice

labadie_1 — Wed, 26 May 2010 12:45:19 GMT

Sqlite for VMS is included in Python for VMS, see
http://www.openvms.org/stories.php?story=08/10/03/7632750
and

http://www.vmspython.org/DownloadAndInstallationPython

Re: DBD choice

Cfabio — Thu, 27 May 2010 14:07:20 GMT

Hi

Thanks but I can't use python..I have to work with perl.

Now I'm trying to install the perl module DBI-1.611 but I have problems during the test of the module.

I'll start a new thread for this.

Bye

Re: DBD choice

Bob Blunt — Fri, 28 May 2010 02:52:43 GMT

Cfabio, check the freeware pages at OpenVMS.org. Most of the public domain database solutions that have been ported to VMS should be listed there. There's also a set of associated pages for DBAs at their site that might be a good source to find opinions about those public solutions.

bob