Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Instant Client with Embarcadero DBArtisan

user572781May 3 2007 — edited Apr 8 2011
How can you make DBArtisan work with Oracle Instant Client? I set my Path to point to the instant client files location, had TNS_ADMIN set, NLS_LANG set, but DBArtisan is not working with it. When trying to connect to an Oracle database this is the error message:
Can not load OCI, please verify that oci.dll or ociw32.dll exist in your path...
My sqlplus connetion and ODBC connection works fine from the instant client.

Thanks.

Comments

prajithparan
make DBArtisan's LIB path points $ORACLE_HOME/lib
user572781
Thank you for your reply. I checked and DBArtisan has no environment variables set and there is nothing set in the registry for it. So what parameter do you suggest to change?
prajithparan
Include in the Windows settings is not DBArtisan
853350
I had the same problem after I install and uninstall client several times.

I did the following environment variables changes and my DBArtisan is working again:

1) Add ORACLE_HOME to User variable. eg: C:\app\product\11.2.0\client_1
2) Add C:\app\product\11.2.0\client_1\BIN to PATH variable
3) Set up TNS_ADMIN as C:\app\product\11.2.0\client_1\Network\Admin
4) Add C:\app\product\11.2.0\client_1\LIB to lib system variable

I put my path here as example, please find your corresponding paths.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 6 2011
Added on May 3 2007
#oracle-call-interface-oci
4 comments
7,000 views