I am running on troubles with a report I am working on.

The report is Crystal 8 uses a Stored Procedure on MSSQL 2000. I made it work smoothly on my computer but gives me error when running on the server.

let me give you all the context

1. The MSSQL server is installed on my computer
2. The version is developer edition, no SP
3. Accesing the Data through ODBC
4. There is a .rpt file
5. There is a SP on the MSSQL server database
6. The .rpt uses the SP as datasource


I modified the report, the sp and ran the report with out a problem.

now here is the deal: when I change the ODBC connection to point to other MSSQL server it give me an error, something like "database detected DLL"

I put the ODBC back to my (local) SQL server and it is fine. I even put all the system back to original. it works on my computer, but not when i point to the other sql server.

now, i really don't have a clue why is this happening, i do think that there is a problem with the SQL server becauIse, the system is a commercial app working in several companies, and the original report should work. but none of the installed clients here work.

i went to several computers that have the original installation and it doesn't work. but when using my (local) server as data source it works like a charm.


there are several differences between the local server and the real one, but i don't really think most of them matter. anyway these are some diferences

1. version local is developers no SP, real one is enterprise SP4
2. hardware diference
3. server collation (i think this might be) local is Modern_Spanish, the real one is SQL_Latin1_General.

what is collation for anyway?