We often use the reverse engineering of PowerDesigner to export the table structure of the database, like exporting the table structure of the Oracle database, we use the client connection method. And we are using the client connection method to export the table structure of SQLServer 2008. When connecting to the database, the connection is successful, and the result is that the export table structure fails.
The result is the above 42000 error.
Finally, I checked some information, and finally realized that the table structure can be successfully exported by ODBC connection.
So create an ODBC data source in the ODBC data source manager. See below.
When configuring ODBC, do not change it The default database (that is, you click the check box of “Change the default database” and select the database you need to reverse engineer from the database list) there will be an “Unable to list Tables”, SqlState=3700 error.
、
Excerpt from jianyi7659’s column