Use of MySql ODBC driver

1. Use the api function library provided by mysql.
Many well-known mysql client tools are implemented in this way, as is the well-known winmysql tool. This can be implemented in most development tools. For example, vc, bcb, delphi, and vb can be implemented by calling third-party APIs. But it is not easy for everyone to have high requirements on programmers and be familiar with a set of mysql api functions. This method cannot be used in asp or other programs because it does not support com objects.

2. The second is to use the myodbc driver.
You can go to www.mysql.com to download the myodbc driver and follow the steps below to download the full installation package. This package is large, but only myodbc is useful for us. it is not appropriate to download such a large file. Of course, if you have a good dish, I suggest you choose this method. This is easier, but it does not conform to the cfans style, right.
The second method is to directly download the myodbc. dll file, which is only several hundred kb but not easy to use. after a long time of exploration, I found a method to use it. First, unbind the package and put the myodbc. dll file in the windowssystem or winntsystem32 directory. It depends on whether your system is win9x or winnt (win2k). You should know.
Open a text editor, such as editplus and notpad, and save the following content as a file with the extension. reg, you see. This is the Registry file. Do not make a mistake (excluding the following long string equals sign)
If you are using win2k, replace the first line
Windows Registry Editor Version 5.00

========================================================== ========================== Start from the downstream

Windows Registry Editor Version 4.00

[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INImyodbc driver]
"UsageCount" = dword: 00000002
"Driver" = "C: WINNTSystem32myodbc. dll"
"Setup" = "C: WINNTSystem32myodbc. dll"
"SQLLevel" = "1"
"FileUsage" = "0"
"DriverODBCVer" = "02.50"
"ConnectFunctions" = "YYY"
"APILevel" = "1"
"CpTimeout" = "120"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers]
"Myodbc driver" = "installed"