SqlDbx Forum

SqlDbx

You are not logged in.

#1 2012-01-24 12:05:03

bmahrouka
Member

ORA-00942 and ORA-24374 while connecting through SqlDbx

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

#2 2012-01-24 20:33:57

sqldbxhelp
Administrator

Re: ORA-00942 and ORA-24374 while connecting through SqlDbx

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

#3 2012-01-25 15:04:51

bmahrouka
Member

Re: ORA-00942 and ORA-24374 while connecting through SqlDbx

- 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

#4 2012-01-25 20:26:11

sqldbxhelp
Administrator

Re: ORA-00942 and ORA-24374 while connecting through SqlDbx

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

#5 2015-10-22 22:13:58

gnb
Member

Re: ORA-00942 and ORA-24374 while connecting through SqlDbx

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

#6 2015-10-22 22:33:11

gnb
Member

Re: ORA-00942 and ORA-24374 while connecting through SqlDbx

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

#7 2015-10-23 13:07:55

sqldbxhelp
Administrator

Re: ORA-00942 and ORA-24374 while connecting through SqlDbx

Go into Tools->Options->Servers->Oracle Server and uncheck "Use DBA_* views if available".

Offline

#8 2015-11-09 19:06:48

gnb
Member

Re: ORA-00942 and ORA-24374 while connecting through SqlDbx

Perfect, that's fixed it.  Thanks!

Offline

Board footer

Powered by FluxBB