Skip to Content
0
Former Member
Dec 04, 2009 at 05:34 AM

ODBC Error connecting to a stored procedure SQL Server 2008 - Crystal 8.5

70 Views

I am running a local copy of SQL server 2008 and get an ODBC error when connecting to any stored procedure with or without parameter. The database are running in SQL Server 2000 compatibility mode on the local server.

Do not get the error when connecting to one or more databse tables or when connecting to a stored procedure on a remote database.

The error reported is "ODBC error:[Microsoft][ODBC SQL Server driver] Syntax error or access violation"

I am running Vista OS.

Any help would be appreciated..