No Open Server on SQL Server 2000

[dzman1]

A company I just started on contract with has a problem with a CR8 report that worked against a SQL Server 7 stored procedure, but fails with a 'Server not open' error against the same SP on SQL Server 2000.

Any ideas? It would sure help me seal the deal on my employment here for the indefinite future if one of the mighty brains on this messageboard had the answer to this issue.

Thanks.

 

[synapsevampire]

It's probably using ODBC or native connectivity, switch the connectivity in the report to OLE DB, that should resolve it.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com