Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL for Oracle David Excel Discussion (Misc queries) 4 September 26th 06 06:22 PM
SQL for Oracle David Excel Discussion (Misc queries) 2 September 26th 06 04:28 PM
Connect to Oracle using Microsoft ODBC for Oracle Kent Excel Programming 2 January 18th 06 03:53 AM
Home or Ctrl-Home noyb Excel Programming 7 December 6th 05 07:42 PM
Shortcut keys: CNTRL+HOME vs. HOME Paul Ofthewild Excel Discussion (Misc queries) 1 November 24th 05 09:29 PM


All times are GMT +1. The time now is 06:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"