c_r_senthil
asked on
Installing ODBC driver without installing oracle client
Hi,
I want to connect orcle using ODBC without installing oracle client. I don't know how to install ODBC without installing oracle clients.But i have ODBC setup exe(ora8.1.7.exe).In all the seaches they have told how to install ODBC with the help of oracle client.
Can anyone help me how to install ODBC without installing oracle client.
I want to connect orcle using ODBC without installing oracle client. I don't know how to install ODBC without installing oracle clients.But i have ODBC setup exe(ora8.1.7.exe).In all the seaches they have told how to install ODBC with the help of oracle client.
Can anyone help me how to install ODBC without installing oracle client.
ASKER
Thank u for ur reply.
My OS is WinNt.WinNT,2k,ME will have "Microsoft ODBC for oarcle".But it won't have "Orcale ODBC Driver".
My question is ,can ODBC work without oracle client installed in the sysytem.
The Oracle client is required. If the OS already shows an Oracle ODBC driver is present, that does not mean it will work by itself. You need to install the client.
Also, the Oracle driver you buy from Oracle or Versant or other 3rd party is more feature rich than the driver installed by MS.
Also, the Oracle driver you buy from Oracle or Versant or other 3rd party is more feature rich than the driver installed by MS.
ASKER
Can u say the difference between Microsoft ODBC and Oracle ODBC
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In our experience, you better use the Oracle ODBC driver which has better performance than the Microsoft one. My guess is that Ms is working harder on SQL Server than on Oracle, it makes sense, doesn't it?
As other readers have stated, you NEED install the Oracle client, but you are free to an ODBC from another manufacter if you wish to do so.
As other readers have stated, you NEED install the Oracle client, but you are free to an ODBC from another manufacter if you wish to do so.
The Oracle ODBC driver will not do anything without having installed the Oracle Client because the client has the network libraries (DLLs) necessary to connect to the Oracle DBMS.
Hierarchically it looks like this:
Windows OS
ODBC Subsytem (MDAC)
ODBC Driver for Oracle
Oracle Client
.
.
.
Oracle Server with complimentary network libraries installed
Of course, if you already know all this, what you ask is possible. ODBC drivers are setup using the Oracle ODBC driver dll(s) and a bunch of registry settings. Is this what you really want though?