SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Unable to connect to any database

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Unable to connect to any database
Author Message
samirsaad



Joined: 26 Oct 2014
Posts: 2
Country: Australia

Post Unable to connect to any database Reply with quote
I have just downloaded your free trial, installed it, and attempted to connect to a database.
It failed always: Oracle Library ODC.DLL could not be loaded.
Thanks for your help. Samir
Sun Oct 26, 2014 5:55 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Reply with quote
Do you have 32-bit Oracle client installed? Is it in the system search path?
Sun Oct 26, 2014 6:51 pm View user's profile Send private message
samirsaad



Joined: 26 Oct 2014
Posts: 2
Country: Australia

Post Reply with quote
Yes of course, Oracle Client is installed and works for all other apps that I use.
Even your software found tnsnames.ora and copied to folder "reports" !
Still login screen under "database" the list is empty.
Sun Oct 26, 2014 6:54 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Reply with quote
DB Audit does not copy tnsnames.ora nor it creates any "report"s folders. Indeed it can read names from tnsnames.ora file if it can positively identify the default oracle home.

The error message says "Oracle Library ODC.DLL could not be loaded. " this is typically reported when Oracle client isn't installed. But in your case you say it's installed.
Let's check 2 things
1. If you have multiple Oracle homes and/or multiple Oracle clients - need to verify the default home is specified in the registry or environment variables so that DB Audit can locate it. You can use Oracle Home Selector to set the default home.
Please see http://docs.oracle.com/cd/B10501_01/em.920/a96697/moh.htm depending on your system type either "Home Selector (Available on Win32 Platforms)" section or "Oracle Home Directory Structure for Windows Platform"
2. If you don't have multiple Oracle homes, please verify Oracle's OCI.DLL is located in the system search path, in other words if the Oracle's client BIN directory is listed in the system PATH environment variable.
3. Very important: Make sure the Oracle client path references in the PATH environment variable points to 32-bit version not 64-bit version.


Just in case, the web-based DB Audit Management Console doesn't need Oracle client or other middle-ware to connect to Oracle servers, it connects directly to the server. If you haven't already installed it, you can install it using the same installation program you used to install the graphical version of the Management Console.
Tue Oct 28, 2014 11:41 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.