Changes

MyODBC connector

64 bytes added, 15:08, 26 August 2009

→‎Setting up an ODBC DSN

</source>

== Setting up an ODBC User DSN ==

=== Version 5.1 ===

HKCU\Software\ODBC\ODBC.INI\<connection name>\SERVER <server> REG_SZ

HKCU\Software\ODBC\ODBC.INI\<connection name>\UID <username> REG_SZ

=== 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

== Setting up an ODBC System DSN ==

=== Version 5.1 ===

dummy.reg is HKLM\SOFTWARE\ODBC\ODBC.ini\dummy exported via regedit on a machine with the appropriate DSN defined.

</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 ===

577

edits