SQLcode error code summary and sqlstate = 37000 Solutions

SQLcode error code summary and sqlstate = 37000 Solutions

Today, when I used Power Designer to reverse the database for the second time, I encountered a problem:

Unable to list the users.

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

SQLSTATE = 37000

After searching for half a day, we can solve the problem as follows. In the final analysis, an error occurs in the second step.

Solution:

Step 1: Find the DBMS of the PD, modify its DBMS configuration, select Database-> Change Current DBMS in the menu bar, and select SQL Server2005 for the DBMS.

Step 2: Modify the ODBC connection mode. Remember not to select the default database when using the Wizard to generate the System DSN.

Reconfigure ODBC connection, Administrative Tools-> data source ODBC-> Add in user DSN Tab option-> the selection box that appears to create a new data source, 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 with user ID and password> enter SQL user name and password> do not select the "change default database to" check box. Go to the next step and click Finish.

Step 3: Select File> Reverse Engineer> Database from PD