Quickly obtain the mysql ado connection string

Login, rename it to mysql. udl; 2. Double-click the mysql. udl file, open the "Database Connection Properties" dialog box, and select "Micrsoft" on the "providers" page.

First you have installed the MYSQL database Driver (mysql-connector-odbc-5.1.6-win32.msi. create an empty text file mysql on the desktop. txt, renamed to mysql. udl; 2. double-click mysql. udl file, open the "Database Connection Properties" dialog box, and select "Micrsoft" on the "providers" Page

First, you have installedMYSQLDatabaseDriverProgram (Mysql-Connector-odbc-5.1.6-win32.msi)

1. Create an empty text file on the desktopMysql. Txt, renamedMysql. Udl;

2. Double-click thisMysql. Udl file, open "DatabaseConnectionIn the Properties dialog box, select "Micrsoft Ole DB Provider for ODBC Drivers" on the "providers" Page and click Next;

3.Connection"Page," specify data source "select" to useConnectionString ";

4. Click "compile", and "Select data source" will pop up. On the "file data source" page, click "new" to select a new data source.MYSQLOfDriverProgram"MySQLODBC 5.1 Driver ";

5. Click "Next", click "Browse", and write the file name in the "Save as" dialog box.Mysql", Click" Next ", and click" finish ".

6"MySQLConnnettor/ODBC Data Source Configuration "dialog box according to requirements (such );

7. Click "Test ".ConnectionSuccessful or not,ConnectionA "Connenction successful" prompt box is displayed. For more Details, click "Details" and click "OK". The setting is complete;

8. Return "DatabaseConnectionIn the Properties dialog box, click TestConnection", If it succeeds, it is what we want.ConnectionString.

Below is my local test of ADOConnectionString, server localhost, database meismon, user name root, password 123456

Provider = MSDASQL.1; Persist Security Info = True; Extended Properties = "Driver = MySQL ODBC 5.1 Driver; SERVER = localhost; UID = root; PWD = 123456; DATABASE = seismon; PORT = 3306; COLUMN_SIZE_S32 = 1"

Note: Disable "DatabaseConnectionDouble-clickMysql. Udl open this dialog box and click "test" due to password loss.ConnectionYesConnectionNo.ConnectionYou can complete the password on the Properties dialog box and open it in text.MysqlThe. udl file is complete.ConnectionString.