PowerDesigner [MICROSOFT][ODBC SQL Server Driver][sql Server] could not be pre-defined when the reverse database was encountered. SQLSTATE = 37 Error Resolution

In reverse engineering, the following errors sometimes occur

...

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

SQLSTATE = 37000

Solution:

1. Select the database-and change-current DBMS in the menu bar to select SQL Server2005 for the DBMS.

2. Reconfigure the ODBC connection, data source ODBC, administrative Tools, add-In User DSN tab options, click the Select box to create a new data source, drag the scroll bar to the bottom, select SQL Srever point completion, a new data source naming window appears, Name: BINODBC, in the Server drop-down box, select the local DB instance. Click Next, select SQL Server Authentication with user ID and password, enter SQL user name password, and do not select the "change default database to" checkbox. Complete directly Next

3. Select File---Reverse Engineer-a Database from PD

4, select the database, select the table, OK, the merit caused.

Roughly in accordance with the above method basically can solve, in fact, most of the time, as long as the first step can be solved, the reason can be located for the database type is not caused.

PowerDesigner [MICROSOFT][ODBC SQL Server Driver][sql Server] could not be pre-defined when the reverse database was encountered. SQLSTATE = 37 Error Resolution