Using Crystal Reports with Primavera

[Former Member]

In order to use Crystal reports with primavera, you have to update a field in the Projects table to deconstruct a blob. When I update the table using an sql command, it runs the update statement, but then I get the following error message:

database connector error: 'IM001:[Microsoft][ODBC Driver Manager] Driver does not support this function' .

If I click cancel, the data from the blob shows up in the report. How can I get rid of this error message so the sql command will run without the error message?

Edited by: Kelli Vosler on Mar 1, 2011 5:19 PM

[former_member11696 · Accepted solution]

Hello,

What version of CR are you using? Any CR patches installed?

Possibly find another ODBC driver, it would appear MS is telling you it doesn't support some variable. Crystal is just passing the error to you.

Test your SQL statement in a third party ODBC test tool to see if it generates the same error.

Check with Primavera to see what that error may mean to the DB.

Thank you

Don

[Former Member]

Yes, primavera has their own odbc driver. It works fine in MS Access, but gives an error in Crystal. I don't know if it's odbc 2 or 3 compliant.

[former_member11696]

It's irrelevant if it works in Access, what ever that means.

I suggest you contact Primavera and ask them if their ODBC driver supports Crystal Report 2008.

They can download a trial version for testing. Let them know we are ANSII 92 compliant, this error suggests they are doing something that isn't. Odd that it throws the error but still works...

Thank you

Don

[Former Member]

I am using Crystal Reports 2008 version 12.1.0.892 with sp3.

The query works with third party odbc test tool. It works in Crystal, too, as it deconstructs the blob. I get the error after the update statement has already run. If the update statement doesn't work, no data would be returned. You can do the same thing in Access, and it works fine. We would just like our users to be able to create reports using Crystal.

[former_member11696]

If you are using SP 3 then the version of CR Designer would be 12.3.x.x. and not 12.1.x.x.

Does Primavera have their own ODBC driver? If not who's ODBC driver for Primavera are you using?

Is it ODBC 2 or ODBC 3 compliant?

Don