Reports 6i and Non-Oracle Data Source - Reports

Hi,
I have configured ODBC for DB2 and able to connect Oracle
Discoverer4.1 with DB2.
But Oralce Reports 6i doesnt connect to DB2 using the same ODBC
configuration.
Oracle Discoverer4.1 and Oralce Reports 6i are installed in the
same Oracle Home.( c:\orawin95)
I give the connect informationa as follows:
Username : bb2_user
Passowrod: *******
Database : ODBC:db2connect
I get the following error:
REP-0501-Unable to connect to the specified Database
ORA-03121-No Interface Driver Connected - Function not performed.
Any suggestions is appreacited.
Thanks
Thiru 

Thiruchendhuran,
This is a setup/configuration issue. There are many
dependencies on which versions of the various components are
being used.
You can use metalink to access note 66481.1 which may help you
get this up and running. If you need additional help, contact
Oracle Support Services.
Regards,
The Oracle Reports Team. 

Thanks Oracle Reports Team.
I will post message after I get Reports 6i working with DB2.
Thiru 

I had installed Open Client Adapter(OCA) for ODBC (as mentioned
in Metalink note 66481.1) and now SQl*Plus connects to DB2 with
this message:
-----------------------------------------------------------------
SQL*Plus: Release 8.0.6.0.0 - Production on Mon Dec 3 08:25:58
2001
(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/6000 07.02.0000
SQL>
-----------------------------------------------------------------
should I run the PUPBLD.SQL in DB2? Any suggestion is
appreciated.
Thanks

Related

ORA-00022 ODBC (OCA) Connection with [RB6i]

Hello Oracle World,
i4ve installed the oca and configured an odbc Datasource.
If i test the connection by using "user/password#odbc:datasource" in
sql plus i get this message
" 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: "
but it works.
If I try to connect this datasource in Oracle Reports i get the same "ORA-00022 Errormessage",
but Oracle Reports doesn't work.
Have i to install a special ODBC Driver (special supplier (intersolv, Microsoft ?) or Driveclass )
Or a setting which ignore the "ORA-00022 Messege", so that reports connect with the odbc datasource?
Thanks
Udo
Hi,
I am also getting same problem, if you find any solution please post the reply.
thanking you,
Srinivas

connecting a NON-Oracle Database with reports

Hello Oracle World,
i4ve installed the oca and configured an odbc Datasource.
If i test the connection by using "user/password#odbc:datasource" in
sql plus i get this message
" 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: "
but it works.
If I try to connect this datasource in Oracle Reports i get the same "ORA-00022 Errormessage",
but Oracle Reports doesn't work.
Have i to install a special ODBC Driver (special supplier (intersolv, Microsoft ?) or Driveclass )
Or a setting which ignore the "ORA-00022 Messege", so that reports connect with the odbc datasource?
Thanks
Udo

Connectiong to MS-SQL server 7.0

I'm trying to connect to SQL SERVER 7.0 thru OCA using ODBC.
I've created a database on the SQL server(name TestVisual) and created a DSN "TestVisual".The userid and password for the database is scott/tiger.
I'm trying to run the following SQL script
supplied by oracle
plus80.exe scott/tiger#odbc:TestVisual:TestVisual
#c:\orant\oca60\sql\sqlsrv\sqs60bld.sql
1)The script executes but no tables/Views are created.
2) when i invoke sqlplus thru the command line
plus80.exe scott/tiger#odbc:TestVisual:TestVisual
I get the follwing message:
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
Microsoft SQL Server 07.00.0623
can anyone help
Thanks in Advance 
While both the Oracle Open Client Adapter for ODBC and Oracle8 ODBC driver use the ODBC protocol, they're completely separate products, so I'm not sure how much OCA expertise there will be in this forum.
Oracle support will probably be better able to help you out.
Justin Cave
ODBC Development 
same problem please help

Configuring 8i lite & Forms 6i

Hi Friends,
I am installing Oracle 8i Lite in my Windows98 PC. I installed and tested through SQL. It succeeded. Then I went on to install Developer 6i. After the installation, I was unable to connect either from SQL or Forms. Then I installed the OCA from the developer CD.
After this, I was able to connect in SQL. But I got the error, USER_PROFILE not found. So I did run the script PUPBLD.SQL as user SYSTEM. Now I am able to connect in SQL, but with an error
ORA-00022: invalid session id; access denied,
Server not available or version too low for this feature
If I try to run select * from cat from SQL prompt I was blessed with the following message
SQL*Plus internal error state 2090, context 47:0:0
Unsafe to proceed
Because of this invalid session, I believe that not able to connect to forms as well.
Can anyone help me out from this?
Thanks,
With best regards,
Muthaiah (Muths)

connecting to db2 from report builder via odbc

Hi!
Some manuals said, it is possible to connect to DB2 from Oracle SQL*Plus (we 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, it just throws error.
---
If I set OCA_DEBUG=TRUE in registry, I have bonus messages:
oca-30053 unsupported network call (oracle code: 3115)
oca-30002 ubofssw function not supported (1010)
---
I tried to connect to MsAcces too, but I got same errors.
Have you any idea, how can I solve this?
Thanks

Categories

Resources