471,350 Members | 1,828 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,350 software developers and data experts.

Oracle DataAccess with Multiple Oracle Homes

On my machine, I have two Oracle clients installed, Oracle8 and Oracle92. I
installed Oracle92 last, so all my applications are using the drivers in the
bin directory of the Oracle92 client (Datasource DS01 points to Oracle92).

DataSource="User Id=xxx;Password=xx;Data Source=DS01";

My question is how do I specify for each application which Oracle home to
use?

(My problem is as such. In production I only have the Oracle8 client
installed and 10 applications are currently using it. I have a need to
install the Oracle92 client onto this same box, and repoint one of the ten
apps to use Oracle92 and the remaining 9 to continue to use the
Oracle8.....Is this possible? Can I change something in the Connection
String that will allow me to explicitly use a certain Oracle Home?)
Dec 1 '05 #1
0 1177

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Greg Neef | last post: by
1 post views Thread by noor | last post: by
8 posts views Thread by =?Utf-8?B?RGF2aWQrKw==?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.