Stored procedure issue

[deepsheep]

I have a stored procedure that takes several tables with the same format and returns a teporary table with the information I'm looking for. It runs perfectly in the Query analyzer. However, when I try to add it (or any other SP from that DB) it gives me an error of :
ODBC error:[Microsoft][ODBC SQL server driver] syntax error or access violation.

I can add SP from other DB on the same server and I can also add tables from that DB. It sounds like a driver issue, but I have been assured that those were fixed. I have also ben assured that all permissions are the same in the Datatbases.

We have Crystal Reports 8.5 and
Microsoft SQL server 2000 (I think)

Please help, we've been tearing our hair out long enough.
Thanks.

 

[synapsevampire]

Use the CR supplied ODBC driver for SQL Server, I think that you're using the MS driver.

BTW, I use OLE DB for SQL Server 2000, ODBC is a dying breed...

-k.

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[ashish1975]

Hi

Can u tell me how to execute a stored procedure in crystal reports. I need to call a stored procedure from Crystal Reports session just the same way as from afterparamform trigger in oracle reports.

Thanx

Ashish