Re: Oracle & Informix connectivity/coexisting issues question

Will Rosales wrote:
>
> Currently, I am running Informix Online DSA v7.21 on HPUX10.10 and
 soon
> migrating to v7.22
> HPUX10.20. Our applications are developed in PowerBuilder v5 and
> MicroFocus Cobol v10.
> I am looking into installing Oracle for the first time on the same HP
> server or maybe a separate server.
> 1. When Oracle and Informix rdbms are both online, what is the
> technique/configuration/software
> and additional hardware if any needed to connect to both from the same
> applications running on NT and Unix?

Hi,

You will need a 3-tier ODBC architecture to access multiple data sources from your clients.

In this architecture, you have a ODBC server in the middle tier. On one end it connects to your clients which has a universal ODBC driver manager installed on it. On the other end the ODBC server communicates with different data sources. The database-specific ODBC drivers and the client communication libraries for the databases will be installed on the ODBC server in order to make the connections. Once connected, your client applications can access different data sources at the same time. SimbaExpress uses the 3-ter architecture for database connectivity, allowing connections between NT clients with NT or UNIX database servers.

Vance

Vance Pan                     Email: g2l1_at_ugrad.cs.ubc.ca

Free version of SimbaExpress! Download it at... http://www.simbatech.com/express

Need to build ODBC drivers? Check out... http://www.simbatech.com/sdk

For other information, you can contact info_at_simbatech.com

--