9i drivers dissappear after 10g install 1

[tekkerguy]

I have a server running windows 2003 64bit and sqlserver 2005 64bit.

For some reason, when I install 10g client, all of the odbc drivers dissappear with the exception of the sql native driver, and the oracle 10g driver which is installed.

I need the microsoft ole db driver for oracle, and it takes it off automatically. Does anyone know why this is?

Also when 10g is uninstalled, the directory remains. Is it safe to remove this?

Finally any odbc sources created with 10g cannot be removed after uninstalling 10g. I thought that they would be removed automatically. How do I go about removing them?

 

[Thargy]

tekkerguy,

If you do a full client install from the DVD, oracle will do exactly that.

If you just want OLE DB drivers (presumably so that a microsoft application can connect to the db) then at the screen which allows you to either install administration, full, instant or custom, click on custom.

That will open up some different choices, one of which will be the OLE DB drivers. You may have to drill down a bit to get to the option, but it's definitely there. Install just the drivers, and away you go. You don't need a full client install if you're just going to use an application, and not sql plus etc.

If you attempt to remove the directory, you'll probably get a message warning that OCI.DLL is in use by somebody or other, and can't be deleted. That's normal. Ask again if you want to do a full de-install of oracle before adding 10g client drivers.

Obviously don't delete Oracle on any of your servers!

Regards

Tharg

Grinding away at things Oracular

 

[tekkerguy]

I still don't understand why it uninstalled the "Microsoft OLE DB for Oracle" driver.

The 10g driver is there, but the other one dissappeared

 

[Thargy]

hmmmmmm,

I don't know either tekkerguy. But what I can say is that it is usually not the best idea in the world to have drivers for 9i and 10g on the same client at the same time.
I recently had a driver problem and had to do a full clear out of oracle (down to the registry keys) and a reinstall. If you can, I recommend that you "Keep It Simple Stupid" and choose a version, and then stick to only that version.

Regards

Tharg

Grinding away at things Oracular

 

[tekkerguy]

Will do. one last thing, when creating a connection string, say for oracle etl, how do I find the provider name for the oragle 10g client?

 

[Thargy]

tekkerguy,

I'm not sure I understand. The connection string lets a client connect to a database, which is usually on a server. You don't connect to the client, rather the client connects to, and then queries the database.

If you want the name of the database, use the SID that you chose when the db was created.

Regards

Tharg

Grinding away at things Oracular

 

[tekkerguy]

For example:

Data Source=datasourcename;User ID=vxqrtabs;Provider='OraOLEDB.Oracle.1';Persist Security Info=True;

That's the provider name that is used for the oracle 10g 32 bit drivers. where does it get that OraOLEDB.Oracle.1 name from?

 

[Thargy]

tekkerguy,

I've checked with one of our users and we're using a connections string of

Provider=OraOleDB.Oracle;Data Source=Dev_5.abcde.local;User ID=XXXXXX;Password=XXXXXX;PLSQLRSet=1;

We obviously have the same "OraOleDB.Oracle" bit, but the .1 on the end of your string confuses me. Do you have more than one oracle installation, or some hangers on from previous installations perhaps?

Regards

Tharg

Grinding away at things Oracular

 

[tekkerguy]

I've had many Oracle installations and deinstallations on the machine There's only one now, and before I installed the latest one, I uninstalled and removed the directories for the other ones. Do you know if oracle always increases the .1 count to .2 .3, etc each time you do an installation, regardless if you uninstalled the first?