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