topic Re: Access two different databases from the same process in Operating System - OpenVMS

Access two different databases from the same process

TonyJ — Tue, 09 Oct 2007 07:23:49 GMT

Hello!

If I have a process running on OpenVMS written in C is it then possible to be able to access the two databases Ingres and SQL Server from the same process. Both windows and OpenVMS are located on the same Ethernet LAN.

As long as there exist a ODBC driver for Ingres and SQL Server there should not be any problem is that correct?

Is it then possible to switch between the two databases from the program depending on which one to use.

//Tony

Re: Access two different databases from the same process

Hein van den Heuvel — Tue, 09 Oct 2007 10:28:14 GMT

Tony,
In your other question ( http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1167688 ) You ask which ODBC driver to use.
The answer to that question will influence this question!
Regardless, it feels complex and error prone to do this from a single process... if it works at all!
Please consider solutions using multiple processes / images!
fwiw, Hein.

Re: Access two different databases from the same process

Craig A Berry — Tue, 09 Oct 2007 11:34:47 GMT

Sure. That's why you have an ODBC driver manager to load the appropriate driver for each database. I don't know of any reason you couldn't have two or more connections going at once.

Another way to do this would be with Perl and the DBI extension, depending on whether the appropriate DBD modules are available.

How much trouble you're likely to get into depends in large part on how the Ingres data and the SQL Server data are going to be correlated, mapped, converted, aggregated, or whatever it is you plan to do with them.