Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×