Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

connect to ibm db2 from ora report builder via odbc

Status
Not open for further replies.

brioska

Programmer
Oct 27, 2003
2
HU
Hi!

We have a software:
Oracle DB, Java GUI, Oracle Reports. We must to migrate the database to DB2.
Some manuals said, it is possible to connect to DB2 from Oracle SQL*Plus (I have version 8.0.6.0.0) and from Oracle Report Builder.(6.0.8.11.3) (User must install OCA (Oracle Open Client Adapter for ODBC (6.0.5.29.0))) and make ODBC entry.
I did it.

run with: plus80 db2user/db2pass@odbc:db2test

SQL*Plus made the connection, but with errors:

---
SQL*Plus: Release 8.0.6.0.0 - Production on Fri Oct 17 16:12:56 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Server not available or version too low for this feature
ORA-00022: invalid session id; access denied
Connected to:
Oracle Open Client Adapter for ODBC 6.0.5.29.0
DB2/NT 08.01.0000
SQL>
---

The error refers PUPBLD.SQL, but I think it is Oracle specific, don't help.

Worse, that it can't connect from Report Builder, just throws error.

Have you any idea, how can I solve this?

Thanks
Brioska
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top