Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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.