40002: 37000(Microsoft) ODBC SQL Server Driver (SQL Server) the Cursor was not Declared


Symptoms


"40002: 37000(Microsoft) ODBC SQL Server Driver (SQL Server) the Cursor was not Declared"

This error occurs after entering a user's database login credentials when setting a company as default.

Cause


The user does not have the appropriate rights to the SQL database.

Resolution


Check the rights for the user to the Company Database. In order for users to pass authentication to the database in FRx Designer, users must have at least DataReader rights to the database.

References