• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1265
  • Last Modified:

Unable to connect to a data source within Toad v9 receive error Can't initalize OCI. Error 1

Have been sucessfully accessing my datasources via TOAD v9 on Win XP SP2 for some time. Today when opening Toad I receive the TOAD error message Can't initialize OCI. Error 1 Any ideas?
0
KarenEnglish
Asked:
KarenEnglish
  • 2
  • 2
1 Solution
 
sventhanCommented:
Make sure \bin folder is in PATH, and that some version of oraxy.dll, e.g., OraClient9.dll etc. exists in that folder or elsewhere in the PATH.


0
 
KarenEnglishAuthor Commented:
Sorry, that was Oracle v10 we have. The bin is in the path
0
 
sventhanCommented:
Is everyone at your place having the same issue? Or, just only you. What version of TOAD are you using?

Sometimes these errors (TOAD) is hard to debug. What I normally would do is just replace the toad.ini with the working version of it.

You could find the toad.ini from the following folder.
C:\Program Files\Quest Software\Toad for Oracle\User Files

0
 
KarenEnglishAuthor Commented:
I deleted the ORACLE_HOME environment variable from my user environment and Toad is now accessing my Datasources. Thank you for pointing me in the that direction!
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now