ODBC Data sources and stored procedures

[moniB]

I am trying to display a report which consists of data returned from a stored procedure but it only seems to work if I create the ODBC Data Source with NT authentication. When I try and run the report providing a connection string it wont display the report but err.number is 0 in VB. Has anyone else had any similar problems or is it possible to run a stored procedure without NT authentication? Any help would be much appreciated.

Thanks,
Monica.

 

[JCooL]

Try...

In Crystal Report
Go File - Options Tab Database and check if Store Procedure are Cheked

 

[synapsevampire]

This might help:

http://support.crystaldecisions.com/library/kbase/articles/c2007175.asp

http://www.informeddatadecisions.com

kai@informeddatadecisions.com