"Unknown database connector error" in crystal report 2008

[Former Member]

Hi Experts.

An upgradation is done at one of our client site from SAP 2007 PL 15 to SAP 8.8 PL 19.

Also OS changed from Windows Server 2003 to Windows Server 2008.

Before upgradation the reports were created in Crystal report 2008 are not working in the current scenario.

They are giving error "Unknown Query Engine Error" in SAP 8.8 PL 19.

And if i only runs the report file it gives error "Unknown database connector error" in crystal report 2008.

I'm using OLE DB connectivity in the report to the database.

Also the case is that these reports which are not working now,

works on client machines.

They are giving error in their server only

Please provide solution to this.

Thanks & Regards,

Bhushan

[Former Member]

Hi,

install SQL native client + upgrade to PL20

Regards

D

[Former Member]

Hi Daniel.

Thanks for replying.

But if it is patch level issue then reports should show error on client machines also.

Kindly justify this.

Thanks & Regards,

Bhushan

[Former Member]

Thats not necessarily true.

for example there is a bug in PL 19, where if you create a new report, SAP wont remember the .rpt-s connection logon no matter what you do, they work fine on the server some times but allways fail on the clients.

+ the old reports work perfectly.

Also try the following:

Open Crystal Reports.

Open the report displaying the error message.

Click Database --> Verify Database.

Crystal will detect any problems with file linking, file names, formulas, etc.

Once prompted with "The database is now up to date," click OK.

Save the report and try running it again in SAP.

+ you can always try to change the way the report connects to the data

try these combinations (depends on your SQL server settings)

- use SAP B1 Connector

- use OLEDB with windows auth. (trusted connection).