TOOLS 8.54.09 and Crystal -- cannot connect
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