Driver does not support this function (0) 1

[lory]

I am running a crystal report with a cross tab graph. It runs fine on my desktop, but errors on the server with this error "Crystal Reports Print Engine error text: Error detected by database DLL." After running an ODBC trace on the server I see this error "CRW_ELWCC060_17 77c-c0c EXIT SQLSetConnectAttr with return code -1 (SQL_ERROR)
SQLHDBC 01DF2BE0
SQLINTEGER 1041 <unknown>
SQLPOINTER [Unknown attribute 1041]
SQLINTEGER -3

DIAG [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function (0)&quot;

Does anyone have any ideas what this means? Doesn't make sense that it works on my desktop, but not on the server?!

 

[synapsevampire]

Are you using Crystal Enterprise, or the CR Print Engine? This is a Crystal Enterprise forum.

If you supply version numbers and some specifics about your environment someone may be able to shed more light on the problem.

Perhaps the connectivity isn't set up properly on the server, but there are a variety of reasons for this generic error.

Generally it means that connectivity is bad.

Wrong or nonexistent ODBC driver, can't find the database, bad stored procedure, timeout, etc.

-k

 

[lory]

Crystal Enterprise version 8. ODBC is set up correctly on the server to connect to the MS SQL 2000 database.