Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

get ODBC Driver for oracle 9i DB

Fauziah Mahdan
Super Advisor

get ODBC Driver for oracle 9i DB

Sorry if I am posting to wrong forum, but I am try to find my password to go in Metalink forum.
Where can I get the ODBC Driver for oracle 9iDB?
Is it can freely download from oracle? Or need to purchanse the license?

Thanks
Fauziah
7 REPLIES
Oviwan
Honored Contributor

Re: get ODBC Driver for oracle 9i DB

Hey

an ODBC driver for what?

for the windows side:
http://www.oracle.com/technology/software/tech/windows/odbc/index.html

I had a similar question from the hpux side:
http://forums.itrc.hp.com/service/forums/questionanswer.do?threadId=1127245

Regards
Andrew Young_2
Honored Contributor

Re: get ODBC Driver for oracle 9i DB

Hi Fauziah

The Oracle 9i ODBC driver is on the Oracle 9i Client CD, but can be downloaded seperately from www.oracle.com . However if you don't have the Oracle 9i client installed you will need the whole CD in anycase.

Regards

Andrew Y
Si hoc legere scis, nimis eruditionis habes
Fauziah Mahdan
Super Advisor

Re: get ODBC Driver for oracle 9i DB

The purpose is I have Application install on Windows pc/server connect to DB oracle 9i.

Do I need to use Ms ODBC Driver or can I use from oracle 9i client cd?
What is the diff between this oracle 9i ODBC driver and MS ODBC driver?

Thanks
Andrew Young_2
Honored Contributor

Re: get ODBC Driver for oracle 9i DB

Hi Fauziah

The Microsoft ODBC driver for Oracle 9i also needs the Oracle client installation on the local machine.

There are some differences between the two that were introduced when Microsoft made changes to MDAC resulting in some data formatting differences, most of the time it will work without a problem.

Regards

Andrew Y

Si hoc legere scis, nimis eruditionis habes
Fauziah Mahdan
Super Advisor

Re: get ODBC Driver for oracle 9i DB

So can I just isntall the ODBC driver from oracle 9i client cd instead of MS ODBC driver to the win pc/server? Will the Application work?
Andrew Young_2
Honored Contributor

Re: get ODBC Driver for oracle 9i DB

Hi.

You will need to make sure your TNSNAMES.ora file is correctly setup and then configure the DSN (ODBC Data Source) in the Control Panel. Make sure the your %ORACLE_HOME%\bin is in the system PATH.

If you need help with setting that up rather post another question in the correct forum, which would be Microsoft General.

Regards

Andrew Y
Si hoc legere scis, nimis eruditionis habes
Jov
Honored Contributor

Re: get ODBC Driver for oracle 9i DB

Hi,

When you install the Oracle clients (e.g. SQLPlus) the ODBC drivers are also installed. Start up the install process and have a look at the options.


Jov