SQL Stored Procedure + Linked Server

[Christine0701]

I am trying to create a Crystal Report that uses a sql server stored procedure. The stored procedure connects to some data thru a linked server to MSAccess data. When I try to create the report, it lets me add the stored procedure but then it gives me a general SQL Server error. I checked the error file and it tells me that Ansi_Nulls and Ansi_Warnings are not on. The problem is that they are on. I can create an ASP page that access the same stored procedure with no problems. Is there a setting within Crystal Reports that turns on Ansi_Null and Ansi_Warnings.

Please help!
New User to Crystal Reports 8.0