This content has been marked as final. Show 5 replies
Why do you want to add "ODBC driver" when you are using OraOLEDB?
How do you plan to solve other requirements such as "Visual Basic For Applications"?
Perhaps you could ship Instant Client with your Excel application?
Then use Windows included interface libraries "for Oracle", or Instant Client ODBC, or include Xcopy deployment of data provider for OLE DB (OraOLEDB) from ODAC (builds on Instant Client).
976638 wrote:OraOLEDB is Oracle's OLE DB database provider. It's kind of like the ODBC driver except for OLE DB, which is a different interface. I don't know the details of how many files it is, but it's included in the Oracle driver for Windows.
Tridus - thanks for your reply. I was concerned that Oracle Client would have to be downloaded to each machine that wants to run this macro.
What is OraOLEDB? Is it a single file? Is it a library of calls? What exactly is it?