CODEWITHSUNDEEP
oracle-databasereporting-servicesoracle10greporting
Georges Sabbagh
Georges Sabbagh

Reputation: 279

report builder 3.0 connection to Oracle Database

this is the first time i work with report builder 3.0 and oracle database. I want to create a report using Report builder 3.0 to an oracle database "TEST" i created the datasource using connection type "Oracle" and "OLE DB", the Connection Test succeeded. enter image description here

however if i create a dataset using any of the above datasources, i cannot find list of database tables and views in query designer. also if i try to write manually a query "select * from GCL_CLAIM_TRANSACTIONS", i receive an error "table does not exist ORA-00903: Invalid Table Name", knowing that if i run the same query from "Benthic Software: Golden", it works properly . enter image description here
enter image description here

Appreciate your assistance, thanks

Upvotes: 0

Views: 2214

Answers (1)

Aftab Ansari
Aftab Ansari

Reputation: 946

When you are doing connection type "Oracle", after giving user name and password, just check the “Save my password”. You should be good now after that.

Upvotes: 1

Related Questions