Connect Problems: plus80 to MS SQL Server

From: Ralf Hoffmann <rhoffmann_at_creon.de>
Date: Thu, 26 Apr 2001 13:18:04 +0200
Message-ID: <3AE803EC.AB458FED_at_creon.de>

Hello,

I try to connect to MS SQL Server (7.0) using the ODBC connection with the Reports 6i.

I created a DSN entry.
Using centuras SqlTalk I can connect to the database without problems.

I installed OCA 6.0.5.29.0.

After not being able to connect directly using the report builder I tried plus80w and found some interesting problems:

I create the connect using username and password and odbc:DSN-Name.

That results in:
>>>>>>>>>>>>>

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
SQL>

<<<<<<<<<<<<<<<<

If I install the odbc for oracle and connet to oracle I get
>>>>>>>>>>>>>>>>>>>

ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied

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 Oracle

<<<<<<<<<<<<<<<<<<<<<<

If I try to do a select I get the error (the same error for SQl Server and Oracle 8.0)
>>>>>>>>>>>>>>>>>>

SQL> select * from USERS;
SQL*Plus internal error state 2090, context 0:0:0 Unsafe to proceed

<<<<<<<<<<<<<<<<<<

After doing the comamnd
>>>>>>>>>>>>>>>>>

SQL> desc USERS;

<<<<<<<<<<<<<<<<<

(I found that somewhere on the net yesterday while trying to find a solution for the problem)

I get a list of the columns of the USERS table and after that all the selects work.

I already created the table PRODUCT_USER_PROFILE on the sql server database. But the message I've displayed above still appears.

What is going on here???

I would appreciate any hints what I'm doing wrong or even the comment that somebody has encountered the same problem.

Ralf

P.S.: I already tried to get a newer Version of OCA by downloading the Release 2 of Reports 6i. But it contained the same OCA Version Received on Thu Apr 26 2001 - 13:18:04 CEST