Open main menu

Changes

MyODBC connector

1,135 bytes added, 15:05, 26 August 2009
added registry settings for DSN for 3.51 and 5.1
== Setting up an ODBC DSN ==
 
=== Version 5.1 ===
 
HKCU\Software\ODBC\ODBC.INI\ODBC Data Sources\<connection name> REG_SZ MySQL ODBC 5.1 Driver
 
HKCU\Software\ODBC\ODBC.INI\<connection name>\DATABASE <database> REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\Driver C:\Program Files\MySQL\Connector ODBC 5.1\myodbc5.dll REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\PORT 3306 REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\PWD <password> REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\SERVER <server> REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\UID <username> REG_SZ
dummy.reg is HKLM\SOFTWARE\ODBC\ODBC.ini\dummy exported via regedit on a machine with the appropriate DSN defined.
</package>
</source>
 
=== Version 3.51 ===
 
HKCU\Software\ODBC\ODBC.INI\ODBC Data Sources\<connection name> REG_SZ MySQL ODBC 3.51 Driver
 
HKCU\Software\ODBC\ODBC.INI\<connection name>\DATABASE <database> REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\Driver %WINDIR%\system32\myodbc3.dll REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\PORT 3306 REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\PWD <password> REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\SERVER <server> REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\UID <username> REG_SZ
 
=== Reg.exe for Windows 2000 ===
Pete
577
edits