Sqlcode error code Rollup and sqlstate=37000 solutions

Source: Internet
Author: User
Tags error code odbc sql server driver odbc connection odbc sql server driver

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


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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.