Connection to server working but I get an error message

[stefan]

Dynamic AI can't open the list COLUMN_PRIVILEGES:

While connecting to the Oracle database (cas) a problem arose. The issue reported from the database is:
3265 : Ein Objekt, das dem angeforderten Namen oder dem Ordinalverweis entspricht, kann nicht gefunden werden.
Please check that the Database server is running and that Dynamic AI have sufficient access rights to access it.

What can I do?

Best regards Stefan

[Carsten Sørensen]

Hi Stefan,

To me it sounds like a user rights issue.

Can you access the normal data-tables on Oracle?

Best regards,
Carsten

[stefan]

And thats the funny thing
I accessed one table with sqlplus from cmd and it worked.
Best regards Stefan

[Carsten Sørensen]

Hi Stefan,

From SQLPlus I assume that you are more "native Oracle".

We are running tons of stuff on Oracle and it is being used extensively by thousands of users daily (on Oracle) - so I think we are ok - maybe a special system related column type/name or something that will prevent you from browsing it in Dynamic AI.

Let me know if you really needs it - then we'll have someone looking into it!

Best regards
Carsten

[stefan]

I really need it, it is for my diploma thesis and
very import for the healthcare department I do it for.
May I have to update oracle client
I am working on 8.7
Best regards Stefan

[Carsten Sørensen]

For reproducing it - is it a specific system table object (something we can try debugging?)

You might also try it with the other Oracle connection in Dynamic AI (there are 2) one using the MS Oledb and one using Oracle's own oledb driver.

Oracle Database (in the Dynamic AI connection definition) is the MS
Oracle OraOleDB is the Oracle OLEDB driver.

best regards
Carsten

[stefan]

I tried both connection types and with both there is the same result
I see the tables on the left side and i get the error when I try to access them
The problem is with every table
Best regards Stefan

[Carsten Sørensen]

Sounds like a user rights issue! You might be able to browse the catalogue - but not access and browse the tables from a remote connection.

I don't think it is the client version - I'm rather sure we have been running fine on pre-9 versions as well.

best regards,
Carsten

[stefan]

It should work
The thing is last year worked on this task with the same permissions and I was able to access all the tables then we build a vm ware image but the windows key of the virtual machine was not activated and so i took a VHD image from the machine took the .dai files from the dat folder , downloaded the newest version of dynamic AI and copied the .dai files.
Maybe there was some version change
Best regards Stefan

[Carsten Sørensen]

Hi Stefan,

Just re-tried on Oracle from 6 4 15 and I see no problems.

Can you e.g. test:

A Dynamic AI SQL View on your Oracle connection:

select 123 from dual

click Execute

you should see column 123 with value 123

select * from HR.EMPLOYEES

or whatever table you have

click execute

What do you get?
best regards,
Carsten

[stefan]

I get this error message

While connecting to the Oracle database (cas) a problem arose. The issue reported from the database is:
[Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben
Please check that the Database server is running and that Dynamic AI have sufficient access rights to access it.
(200604) Establishing Connection to: cas

best regards,
Stefan

[stefan]

I don't know why but I updated a software component of the diagnostics software and now it is working
Thank you for your help
Best regards,
Stefan