Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL for Oracle | Excel Discussion (Misc queries) | |||
SQL for Oracle | Excel Discussion (Misc queries) | |||
Connect to Oracle using Microsoft ODBC for Oracle | Excel Programming | |||
Home or Ctrl-Home | Excel Programming | |||
Shortcut keys: CNTRL+HOME vs. HOME | Excel Discussion (Misc queries) |