Database Connector Error when trying to add a stored procedure to my report

[Former Member]

I am trying to add a stored procedure to my report and come up with this error Database Connector Error: 'Cannot obtain error from server.'. This is in any of our environments, and with any stored procedure. I am able to connect to tables and views without error. I'm using Crystal Reports 2008. Any help would be appreciated. Thanks

[Former Member · Accepted solution]

The following SAP Note might help you

[http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_erq/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333233303331333633393335%7D.do]

regards,

Raghavendra.G

[Former Member · Accepted solution]

Thanks, I actually changed mine to an OLEDB and that seems to have worked.

[Former Member · Accepted solution]

Can someone explain why this worked - especially since we normally do nothing with OLEDB? I am afraid this will cause problems in the long run, so trying to understand why this would work but the ODBC would not.

Thanks