Crystal Report and Openquery function in stored procedure

[jazzting]

Hi,
We are using Crystal Report 8 and MS SQL Server 2000. We are trying to report off a stored procedure that uses Openquery function to access another stored procedure that resides in another server (via linked server). This works fine when we connect via ODBC but when we try to connect via native SQL Server driver P2ssql.dll, we encountered error message - "General SQL Server error - Check message from server".

Wonder if this is a limitation in using native connection in Crystal Report? Does anyone encounter such problem before?

Thanks in advance.

 

[synapsevampire]

I seem to recall having problems linking stored procedures with SL Server, and since that's a fairly old version of Crystal connecting to a newer version of SQL Server, it doesn't surprise me.

Looks like it's ODBC...

-k