PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

TOOLS 8.54.09 and Crystal -- cannot connect

edited Apr 18, 2016 5:12PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 7 commentsAnswered

good morning!

I am having trouble getting a database connection using Crystal 2008. we recently upgraded to 9.2 and have not been able to work on Crystal reports since.

1. I deleted my ODBC PeopleSoft Peopletools data sources (in case they were old)

2. I ran the psodbccrinst.exe for both 32 and 64 bit (I have both installed on my computer)

3. I logged into Crystal, and went to database expert

4. I pressed 'create new connection', ODBC(RDO) > Peoplesoft Peopletools

5. Then I get error messages:

     login failed

     Database Connection Error: the server threw an exception from ISQLAllocConnect.

     Database Connector error: Microsoft ODBC Driver Manager SQLAllocHandle on SQL_HAND_DBC failed

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center