MySQL database field export-dbexportdoc v1 + MySQL ODBC configuration

MySQL database field export-dbexportdoc v1 + MySQL ODBC configuration

Important: 1,dbexportdoc v1 software (embedded macro Word file), self-search download it, (Blog Park reference article, its introduction a bit of a problem, misled me for a long time)

2,MYSQL,ODBC installation files

Data source-Add, select, or other MySQL ODBC--complete, then

Start configuration: The first two items are arbitrary, and the Data Source Name is used later. TCP/IP server entry, local localhost and remote fill in the server IP. The database login user name password is followed. The test OK will do.

Dbexportdoc is simple, open his Word document, pop up the Connect database option, click New, OLE DB provider option instead of MSDataShape,

Next, choose the data source with the ODBC data source name, not set the password in the data source configuration can not enter additional information, test connection-OK:

Alternatively, you can get the connection string directly: refer to this

1. Create a new empty text file on the desktop mysql.txt, rename it to Mysql.udl;

2. Double-click the Mysql.udl file to open the Database Connection Properties dialog box, select Micrsoft Ole DB Provider for ODBC Drivers on the Providers page, and click Next.

Then the Control Panel-management tool-the configuration of the data source, the resulting mysql.udl file in the connection string to be copied directly to the Dbexportdoc popup input box, point connection;

MySQL database field export-dbexportdoc v1 + MySQL ODBC configuration