SqlDbx
You are not logged in.
I got those errors while connecting to my oracle database through SqlDbx.
But the thing is that when I connect using the same username and password on one of my team members computer it works perfectly and I can see all the tables.
I don't know actually what is going on?
Last edited by bmahrouka (2012-01-25 15:06:44)
Offline
Does SQL*PLUS connects without any issues?
Do you have multiple oracle client installations on your computer?
Are you running Personal or Pro version?
Offline
- SQL*PLUS connected without any issues.
- I have only one Oracle client installed on my computer.
- I'm running the professional versoin of SqlDbx.
as I said I tried to use the same username and password on my teammate's computer and used his SqlDbx and it worked.
and I also tried to use another SQL client (Toad) and it worked.
The issue am having is only with SqlDbx.
When I connect:
1- Error message box appears with the error (ORA-00942: table or view does not exist).
2- When I click OK on the message box. another message box appears with two errors (ORA-00942: table or view does not exist and ORA-24374: define not done before fetch or execute and fetch).
3- Then I click OK. it connects to the oracle DB that I have and I can perform operations on it but only read-only operation obviously because my username credentials is only read-only. BUT I can't see the tables that I can see in TOAD or in my teammate's computer.
Last edited by bmahrouka (2012-01-26 10:36:10)
Offline
The strange part is that it runs on one computer but not other with the same credentials.
Can you Start SqlDbx with command line switch -l (SqlDbx.exe -l)
Try to connect to database. After connection completes exit.
Email file SqlDbx.exe.log generated in a same directory where SqlDbx.exe located to support at sqldbx.com
Offline
I'm seeing the same issues. 2 popups as described below, then when the window opens, there are no schemas/tables/views &c shown.
I have 64bit and 32bit oracle installed, and am using
2015-10-23 12:54:10.712000: SqlDbx x64 Version 4.5 (Professional Edition) 41945
I've also created ODBC DSNs for this DB (32 and 64 bit), and I can access the DB using the same credentials as a plain ODBC connection in sqlDbx. I can connect via sqlplus.
I ran with -l and the last 2 lines are:
2015-10-23 12:54:19.605000: Loaded driver dll: C:\Oracle\product\12.1.0\x64\oci.dll
2015-10-23 12:54:19.871000: DB Info: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
Oddity: I _can_ use the OCI driver to the same 11g server on another older PC/SqlDbx version (32bit SqlDbx and 32bit Oracle OCI installed):
SqlDbx Version 3.24 (Professional Edition)
oci.dll loaded from : C:\oracle\product\12.1.0\win32\oci.dll
Any clues?
Offline
FYI - once the connection is up, it does actually work, it's just the extraction of the schema / table / object data (i.e. everything you want to use SqlDbx for!) that is failing.
Offline
Go into Tools->Options->Servers->Oracle Server and uncheck "Use DBA_* views if available".
Offline
Perfect, that's fixed it. Thanks!
Offline