ExcelBanter - Which Oracle home does VBA use?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Which Oracle home does VBA use? (https://www.excelbanter.com/excel-programming/428758-oracle-home-does-vba-use.html)

ptruitt

Which Oracle home does VBA use?

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?

Patrick Molloy

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?

All times are GMT +1. The time now is 05:39 PM.