ODBC Driver for MySQLIf you want to connect to a local database you can use a connection string like the following:strConnect = _T("Driver={MySQL ODBC 3.51 Driver};Server=localhost;" "Database=MyDatabase;User=MyUserName;Password=MyPassword;Option=4;"); If you want to connect with a remote database, You need to specify the Name of server or IP in the Server parameter. If the Port is distinct to 3306 (default port) you must to specify it. strConnect = _T("Driver={mySQL ODBC 3.51 Driver};Server=MyRemoteHost;" "Port=3306;Option=4;Database=MyDatabase;Uid=MyUsername;Pwd=MyPassword;"); The parameter Option can be one or more of the following values1 The client can't handle that MyODBC returns the real width of a column. 2 The client can't handle that MySQL returns the true value of affected rows. If this flag is set then MySQL returns 'found rows' instead. One must have MySQL 3.21.14 or newer to get this to work. 4 Make a debug log in c:\myodbc.log. This is the same as putting MYSQL_DEBUG=d:t:O,c::\myodbc.log in `AUTOEXEC.BAT' 8 Don't set any packet limit for results and parameters. 16 Don't prompt for questions even if driver would like to prompt 32 Enable or disable the dynamic cursor support. This is not allowed in MyODBC 2.50. 64 Ignore use of database name in 'database.table.column'. 128 Force use of ODBC manager cursors (experimental). 256 Disable the use of extended fetch (experimental). 512 Pad CHAR fields to full column length. 1024 SQLDescribeCol() will return fully qualified column names. 2048 Use the compressed server/client protocol 4096 Tell server to ignore space after function name and before '(' (needed by PowerBuilder). This will make all function names keywords! 8192 Connect with named pipes to a mysqld server running on NT. 16384 Change LONGLONG columns to INT columns (some applications can't handle LONGLONG). 32768 Return 'user' as Table_qualifier and Table_owner from SQLTables (experimental) 65536 Read parameters from the client and odbc groups from `my.cnf' 131072 Add some extra safety checks (should not bee needed but...) If you want to have many options, you should add the above flags! For example: 16 + 1024 = 1030 and use Option= 1030;
去那看看资料吧
"Database=MyDatabase;User=MyUserName;Password=MyPassword;Option=4;");
If you want to connect with a remote database, You need to specify the Name of server or IP in the Server parameter. If the Port is distinct to 3306 (default port) you must to specify it. strConnect = _T("Driver={mySQL ODBC 3.51 Driver};Server=MyRemoteHost;"
"Port=3306;Option=4;Database=MyDatabase;Uid=MyUsername;Pwd=MyPassword;");
The parameter Option can be one or more of the following values1 The client can't handle that MyODBC returns the real width of a column.
2 The client can't handle that MySQL returns the true value of affected rows. If this flag is set then MySQL returns 'found rows' instead. One must have MySQL 3.21.14 or newer to get this to work.
4 Make a debug log in c:\myodbc.log. This is the same as putting MYSQL_DEBUG=d:t:O,c::\myodbc.log in `AUTOEXEC.BAT'
8 Don't set any packet limit for results and parameters.
16 Don't prompt for questions even if driver would like to prompt
32 Enable or disable the dynamic cursor support. This is not allowed in MyODBC 2.50.
64 Ignore use of database name in 'database.table.column'.
128 Force use of ODBC manager cursors (experimental).
256 Disable the use of extended fetch (experimental).
512 Pad CHAR fields to full column length.
1024 SQLDescribeCol() will return fully qualified column names.
2048 Use the compressed server/client protocol
4096 Tell server to ignore space after function name and before '(' (needed by PowerBuilder). This will make all function names keywords!
8192 Connect with named pipes to a mysqld server running on NT.
16384 Change LONGLONG columns to INT columns (some applications can't handle LONGLONG).
32768 Return 'user' as Table_qualifier and Table_owner from SQLTables (experimental)
65536 Read parameters from the client and odbc groups from `my.cnf'
131072 Add some extra safety checks (should not bee needed but...)
If you want to have many options, you should add the above flags! For example: 16 + 1024 = 1030 and use Option= 1030;