473,573 Members | 3,211 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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="Use r 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 1233

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
14302
by: Bill | last post by:
Does anybody know if it is possible to run two different instances (and potentially different releases) of Oracle client on one Windows 2000 PC? I'd like to do this so that I can have one that I know is stable, and a second to apply patches and test. I imagine if I install into 2 different directories the install will work, but are there...
3
4072
by: Greg Neef | last post by:
I need to develop a Tab Form where selecting a particular key from an unbound combo listbox will resulting in the display one or many records from several tables, where each tab has the matching rows for the selected key. There does not appear to be a similar example in the Northwind database. The objective is to show related records from...
0
1565
by: sam | last post by:
Hi: I am not sure if this is the right place to post this question. Please let me know if it is not and I appreciate if someone could point me in the right direction. I am getting this error after converting to .NET 2.0. Unable to cast object of type 'Oracle.DataAccess.Client.OracleCommand' to type 'System.Data.Common.DbCommand'
1
1810
by: noor | last post by:
Hi, I'm trying to connect to my Oracle 10g Database i m facing the problem of connection string, following code is that i use, please tell me how to use the connection string for accessing the oracle database from a remote location and from local machine, at both places i m getting the problem. tell me how to set the server name, data sourse...
1
1321
by: noor | last post by:
Hi, I'm trying to connect to my Oracle 10g Database i m facing the problem of connection string, following code is that i use, please tell me how to use the connection string for accessing the oracle database from a remote location and from local machine, at both places i m getting the problem. tell me how to set the server name, data sourse...
8
14299
by: =?Utf-8?B?RGF2aWQrKw==?= | last post by:
Hi, I have been developing Web Services in VS2005. Usually I use the built in server in VS2005 to test and develop the Web Service. However I now want to make this Web Service available to other computers (and applications) in our local company network. When the service runs it accesses an Oracle database and pulls some data out. It...
0
2086
by: Suzyque54 | last post by:
I have two Oracle Homes (9iR2 & 10g R2) installed on Windows Server 2003. I have jobs running on my 9i database for backup and they are now failing because the default home is now10g as that was installed last. I need a command which will switch my Oracle Home to 9i so I can run these jobs. I can use the Universal Installer to change homes, but I...
4
5014
by: Peter Kanurer | last post by:
Assume I add in VisualCSharp 2005 References to Oracle.DataAccess AND System.Data.OracleClient to an application. Does this cause problems or can they co-exist in one application ?
0
2586
by: | last post by:
Hi All, I have a client connection problem with Oracle. The exe which i did with C# (vs.net 2005) and Oracle XE , works well on my developer machine but i am getting a connection string error on the client side. The error comes from System.Exception class not from OracleException. The properties of the Oracle.DataAccess reference are ;...
0
7741
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7661
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8165
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7730
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6347
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5550
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3692
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3686
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
984
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.