Thread: Which Oracle home does VBA use?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
  
Posts: 1,049
Default Which Oracle home does VBA use?
check the connection string -- it will have "database:=" or "Initial
Catalog:="

"ptruitt" wrote in message
...
I've got an Excel spreadsheet that uses VBA macros. The macros are
attempting to read from an Oracle database. How can I figure out which
Oracle home (this computer has 2) the macro is using? Does it use the
default Oracle home?

Reply With QuoteReply With Quote