Store procedure error when using OLEDB

[kevstar]

I am trying to make crystal Reports connect to SQL server using OLEBD.

I have converted the database driver from ODBC to OLEDB, crystal tells me that it cannot find the stored procedures in SQL. This is because it suffixes all of the stored procedure names with ";1".

I am told that Crystal does this by default. If I delete this suffix in the "Set Location" page sometimes it works but the majority of times I get an error being produced in CRW32.exe It causes a fault and shuts down crystal.

Why does this happen and how do I remove the suffix on the stored procedure names?

Any help would be appreciated

Thanks again

Kev