Sqlcode error code Rollup and sqlstate=37000 solutions

Today, the small series in the power designer the second reverse database, encountered a problem, as follows:

Unable to list the users.

[Microsoft] [ODBC SQL Server Driver] [SQL Server] cannot predefined statements

SQLSTATE = 37000

After a long time, the following way to be resolved. In the final analysis, I made a mistake in the second step as follows

Solution:

Step one: Locate the DBMS for PD and modify its DBMS configuration, select the database-> change current DBMS in the menu bar, and select SQL Server2005 for the DBMS.

As shown in figure:

Step Two: Modify the ODBC connection method, and remember that you must not choose Default database when you use the wizard to generate System DSNs.

Reconfigure ODBC connection, admin tool-> Data source ODBC-> add-> to the midpoint of the User DSN tab option A selection box port to create a new data source, drag the scroll bar to the bottom, select the SQL Srever point complete, and a new data source naming window appears. Name: BINODBC, in the Server Drop-down box, select the local database instance. Click Next-> Select SQL Server Authentication with user ID and password-> enter SQL username password-> do not select the "change default database as" marquee. Direct Next-> complete

Step three: Select File-> Reverse Engineer-> Database from PD