Error Missing or invalid Version SQL Library PSORA32

[Former Member]

Hi

I am using Crystal 2008 with oracle 11 and people tool 8.53

I am windows 7

Oracle 11 - 32 bit

When I enter user/pwd to connect to the DB to run the report I got error:

" Missing or invalid Version SQL Library PSORA32 (200,0)

Any ideas what can I do to solve this problem?

Any missing path that I need to set up.

I really need to solve this issue, Please help me

Thanks a lot in advance

Liz

[Former Member · Accepted solution]

We are having the same issue after an upgrade to PeopleTools 8.53. I see this has not been answered.

Have you found a solution?

I submitted a ticket to SAP.

[former_member183750 · Accepted solution]

Hi Susan

You may want to contact PeopleSoft Corporation and ask them if CR works with their PeopleTools(?).

Also, please see the following:

PeopleSoft ODBC Driver, DSN for Crystal Reports Development for PeopleSoft 9.1

Even though that is not the version of PeopleSoft you are using, this makes me think that contacting them may be the correct step to do(?).

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

Message was edited by: Ludek Uher

[Former Member · Accepted solution]

Thank you for your reply, Ludek. Users have always been able to create reports against PS Query using the PeopleTools driver.

[Former Member · Accepted solution]

Hi

We finally fix the error by copying the file PSORA32.dll in the crystal location

C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86

or the location you have the local crystal installation.

That fix the problem for us. Hopefully fix yours.

Thanks

Liz

[former_member183750 · Accepted solution]

Hi Liz

Many thanks for the answer

- Ludek

[Former Member · Accepted solution]

Liz, copying the PSORA32.dll file did work to eliminate the first error (thanks!), but now the user is getting:

Invalid access and password for sign-on. See your security administrator.

This is the 2-tier login.

Did you run into this?

[Former Member · Accepted solution]

We figured it out.... The PT password was changed prior to the PT upgrade and a config file had to be run by the users in Virtual Workspace.

[former_member183750 · Accepted solution]

Hi Susan

Many thanks for letting us know of the resolution. This is exactly how these forums are supposed to work

Happy reporting,

- Ludek