Operating System - OpenVMS
1748216 Members
3501 Online
108759 Solutions
New Discussion юеВ

Access two different databases from the same process

 
TonyJ
Occasional Contributor

Access two different databases from the same process

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
2 REPLIES 2
Hein van den Heuvel
Honored Contributor

Re: Access two different databases from the same process

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.
Craig A Berry
Honored Contributor

Re: Access two different databases from the same process

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.