I need to install the ODBC driver (only) for Oracle 9i client on users' PC. I do NOT want to install the full client. Please tell me which component in the custom install to select. I have already installed basic Network Utilities and they have connectivity from MSAccess db to Oracle, but the Microsoft for Oracle driver gives Invalid Argument when trying to connect to Oracle Views. If I use the Oracle92 driver I can connect. (I have Full client on my PC but do not want to install that much on users' PC). thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Install Oracle ODBC driver 1
- Thread starter mdlaugh1
- Start date
Hi,
The Oracle ODBC driver requires that the Oracle client software be installed ( you need SqlNet, for instance)...
ODBC is just an overlay that uses the client stuff to connect...
There are 'thin' ODBC drivers available ( from DataDirect - that do not need any Oracle software installed..They use a Java-like connection string
server
ort:instance to connect directly..
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
To Paraphrase:"The Help you get is proportional to the Help you give.."
The Oracle ODBC driver requires that the Oracle client software be installed ( you need SqlNet, for instance)...
ODBC is just an overlay that uses the client stuff to connect...
There are 'thin' ODBC drivers available ( from DataDirect - that do not need any Oracle software installed..They use a Java-like connection string
server
ort:instance to connect directly..To Paraphrase:"The Help you get is proportional to the Help you give.."
- Thread starter
- #3
thanks, Turkbear, for your help...
I need to clarify... right now the user has installed oracle network utilities to get SQLnet.ora and TNSNames.ora... and using the "Microsoft for oracle" provided ODBC driver, can connect from MSAccess to the oracle tables. However, there are some Oracle Views that this MS driver will not connect to. for some reason getting the error: "application defined or object-defined error"
On my own PC I have installed a FULL install of 9i client, and using the Oracle for Ora92 driver I CAN connect to these views...so it looks like I'm forced to use the Oracle for Ora92 driver, not the Microsoft for Oracle driver
but I want to do a Custom install on users PC. I don't want to give them a FULL install with all the pgms.
can you please point me to the component inside custom install that will install the ODBC drivers, without installing a lot of other oracle tools that they will not need (or we don't want them to have). thanks!!
I need to clarify... right now the user has installed oracle network utilities to get SQLnet.ora and TNSNames.ora... and using the "Microsoft for oracle" provided ODBC driver, can connect from MSAccess to the oracle tables. However, there are some Oracle Views that this MS driver will not connect to. for some reason getting the error: "application defined or object-defined error"
On my own PC I have installed a FULL install of 9i client, and using the Oracle for Ora92 driver I CAN connect to these views...so it looks like I'm forced to use the Oracle for Ora92 driver, not the Microsoft for Oracle driver
but I want to do a Custom install on users PC. I don't want to give them a FULL install with all the pgms.
can you please point me to the component inside custom install that will install the ODBC drivers, without installing a lot of other oracle tools that they will not need (or we don't want them to have). thanks!!
-
1
- #4
- Thread starter
- #5
- Status
Similar threads
- Question
