SqlDbx Forum

SqlDbx

You are not logged in.

#1 2010-01-05 20:42:07

granit
Guest

windows 7, oracle 11.1

I just installed oracle 11.1 on windows 7 ultimate. My oracle home is "C:appM1330product11.1.0db_1BIN".
When I try to register an oracle server I get "Unable to load oracle client library".
I can see in sqldbx that current oracle home "OraDb11g_home1" is set to "C:appM1330product11.1.0db_1BIN"
which should be correct! I can connect with no problem with sql plus. Any idea how to solve this?

#2 2010-01-06 07:49:25

sqldbxhelp
Administrator

Re: windows 7, oracle 11.1

For some reason SqlDbx unable to locate oci.dll
Start SqlDbx with -l command switch.
Try to register server or list them.
Exit SqlDbx and take a look at SqlDbx.exe.log
file located in a same directory where SqlDbx.exe

Offline

#3 2010-01-06 08:45:15

granit
Guest

Re: windows 7, oracle 11.1

Thanks for the help. Here is output in log.

=::=::
=C:=C:UsersM1330Desktopsqldbx
ALLUSERSPROFILE=C:ProgramData
APPDATA=C:UsersM1330AppDataRoaming
CommonProgramFiles=C:Program Files (x86)Common Files
CommonProgramFiles(x86)=C:Program Files (x86)Common Files
CommonProgramW6432=C:Program FilesCommon Files
COMPUTERNAME=M1330-PC
ComSpec=C:Windowssystem32cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=UsersM1330
LOCALAPPDATA=C:UsersM1330AppDataLocal
LOGONSERVER=\M1330-PC
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:appM1330product11.1.0db_1in;C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:WindowsSystem32WindowsPowerShellv1.0;c:Program Files (x86)Microsoft SQL Server90Toolsinn
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_ARCHITEW6432=AMD64
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 23 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=1706
ProgramData=C:ProgramData
ProgramFiles=C:Program Files (x86)
ProgramFiles(x86)=C:Program Files (x86)
ProgramW6432=C:Program Files
PROMPT=$P$G
PSModulePath=C:Windowssystem32WindowsPowerShellv1.0Modules
PUBLIC=C:UsersPublic
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:Windows
TEMP=C:UsersM1330AppDataLocalTemp
TMP=C:UsersM1330AppDataLocalTemp
USERDOMAIN=M1330-PC
USERNAME=M1330
USERPROFILE=C:UsersM1330
VS90COMNTOOLS=c:Program Files (x86)Microsoft Visual Studio 9.0Common7Tools
windir=C:Windows

#4 2010-01-07 07:55:28

sqldbxhelp
Administrator

Re: windows 7, oracle 11.1

As far as I can see you have Windows 7 64 bit.
Did you install Oracle 32 or 64 bit client?
If you have 32 bit client can you try to copy SqlDbx.exe
to directory where oci.dll located and try to run it.

Offline

#5 2010-01-07 14:02:49

granit
Guest

Re: windows 7, oracle 11.1

Yes, I have the 64bit version. I uninstalled this, installed 32bit, placed sqldbx.exe in bin folder and now its working again.

Thanks!!!

#6 2014-02-06 18:27:14

rangerover
Member

Re: windows 7, oracle 11.1

I am having the same issue. I tried to follow the steps mentioned but I am getting nowhere. I am just using the sqldbx Personal version 3.64

I have an Oracle 64 bit but the oci.dll is found here: C:Oracleproduct11.2.0client_1BIN

I cannot install 32bit Oracle since this version is having issues with vbscript.

I also noticed that when I press Tools > ODBC Administrator, it opens the ODBC Data Source Admin on the system32 instead of the Syswow. The DNS is set under SYSWOW.

Please advice thank you!!!

Last edited by rangerover (2014-02-06 18:44:46)

Offline

#7 2014-02-06 19:49:38

sqldbxhelp
Administrator

Re: windows 7, oracle 11.1

Personal Edition is 32 bit application. It will work with x64 bit Oracle client.

Offline

#8 2014-02-07 10:57:22

rangerover
Member

Re: windows 7, oracle 11.1

It will work? or will not work?

Sorry I just want to clarify. I have seen other applications that are 32 bit that will not work with 64 bit OS.

Thank you

Offline

#9 2014-02-07 13:11:04

sqldbxhelp
Administrator

Re: windows 7, oracle 11.1

Sorry. Personal Edition will not work with x64 Oracle client.
Pro x64 Edition does work.

Offline

Board footer

Powered by FluxBB