CODEWITHSUNDEEP
oracle-databaseado.netodbc
Saobi
Saobi

Reputation: 17011

Do I Still Need To Install Oracle Client if Using Microsoft ODBC for Oracle to connect to an Oracle Database?

Using ActiveX Data Objects 2.8 Library as a Reference from Excel VBA, and the connection string is:

"Driver={Microsoft ODBC for Oracle}......."

And I also have the "Microsoft ODBC for Oracle" (MSORCL32.dll) entry in the Drivers tab of Windows XP's ODBC Manager.

Now, will I be able to connect to an oracle databse, without any oracle client/products installed on my machine?

Upvotes: 2

Views: 10840

Answers (3)

user159310
user159310

Reputation:

there are other ODBC drivers out there that don't use the Oracle client software. DataDirect supply one https://www.progress.com/odbc/oracle-database

TLMC

Upvotes: 0

Steve Broberg
Steve Broberg

Reputation: 4394

I'm pretty sure you need to install Oracle client; what's more, I believe it has to be Oracle 8 Client (MS hasn't updated that driver in years, as far as I know).

But have you tried using Oracle Instant Client? It's pretty painless to install, way, WAY smaller than the standard Oracle client and doesn't interfere with other installations. All you need to do is copy the files to a target directory, set your PATH to include that directory (which can be done inside your app - no need to actually set global PATH if you don't want to), and insert the appropriate registry entry into HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI. We use it for all our ADO clients.

It also has the added bonus of not requiring the maintenance of a TNSNAMES.ORA file; your connect string can simply be user/password@server:port/SID.

Upvotes: 7

Sathyajith Bhat
Sathyajith Bhat

Reputation: 21851

You will need the Oracle client. I had tried this out yesterday, on trying to connect ODBC driver yells back at me, "Oracle client is not installed".

Upvotes: 0

Related Questions