ORACLE native driver name ?

raju_chvr · Post by **raju_chvr** » Mon Feb 16, 2004 2:41 pm

Can someone give me the Oracle native driver name?

I have Oracle 8 client installed and I want to make Oracle native driver DSN to use on my machine.

thanks

chulett · Post by **chulett** » Tue Feb 17, 2004 7:32 am

Did you get this sorted out?

If you haven't, you may want to post back with more details on what you need to do as there really isn't such a thing as an "Oracle native driver name", per se. Are you trying to get things configured so you can connect to an Oracle database from your machine? Where is the DataStage server and the Oracle database in relationship to this machine... somewhere else? Is this even a DataStage question or just a more generic 'I need help with Oracle' question?

raju_chvr · Post by **raju_chvr** » Tue Feb 17, 2004 9:22 am

I was just asking what is the driver name would be used to connect from DS machine to Oracle.

my versions are: Oracle 8i and DS 7.0, OS: Win 2000 Server.

I am cofiguring new machine and creating DSN's(which I am doing for the first time on Windows).

Is the actual file is named: 'SQORA32.dll' ?

Sorry, for not being clear in my question.

crouse · Post by **crouse** » Tue Feb 17, 2004 9:41 am

In DataStage, will you be wanting to connect to Oracle via the ODBC stage or the OCI8 stage?

If via OCI, you shouldn't need to configure anything past installing the Oracle client and stopping and starting the DataStage server.

chulett · Post by **chulett** » Tue Feb 17, 2004 9:44 am

Are you trying to setup ODBC connectivity? You really should be using the OCI stages instead, IMHO. If everything is setup properly, Oracle client-wise, then I believe it should just work for you in a Windows environment. For UNIX you have to do some extra steps but I don't think that applies in your case.

raju_chvr · Post by **raju_chvr** » Wed Feb 18, 2004 9:38 am

Craig,

Let me rephrase my question, since I got a better idea what I am looking for this morning.

What is the name of actual driver file to make a connection to Oracle using OCI stage? Is it named as : 'SQORA32.dll' ?

Did I make my-self clear this time atleast?

thanks for ur patience.

kcbland · Post by **kcbland** » Wed Feb 18, 2004 9:55 am

There is no driver. You must install the Oracle client software on your DataStage server. Once that is done, your administrators need to make sure that the tnsnames.ora file is current and has the appropriate connections defined. The DataStage server will use this file for connections, as well as the client software once installed.

raju_chvr · Post by **raju_chvr** » Wed Feb 18, 2004 10:56 am

Gotcha ! .. now I know it !!

didn't do it in Win before

thanks everyone ...