The SQL state = 37000 error occurred in the Power Designer reverse database. solution!

When I used the Power Designer reverse database today, I encountered a problem:

Unable to list the users.

[Microsoft] [odbc SQL Server Driver] [SQL Server] cannot predefine statements

Sqlstate = 37000

Solution:

Step 1: select database-> change current DBMS in the menu bar and select SQL server2005 for the DBMS.

Step 2: reconfigure the ODBC connection. Choose "Management Tools"> "Data Source ODBC"> "add in the user DSN tab"> the "select" box for creating a new data source appears. Drag the scroll bar to the bottom, select SQL srever. The new data source naming window is displayed. The name is binodbc. In the server drop-down box, select a local database instance. Click Next-> select SQL Server verification using the user ID and password-> enter the SQL user name and password->Do not select the "change default database to" option.Go to the next step and click Finish.

Step 3: Select File> reverse engineer> database from PD

Step 4: select a database, select a table, and click OK.