Error While Importing External Data

[peterlaursen]

Is it a 64 bit or 32 bit win7?

[eddierosenthal]

'peterlaursen' wrote:

Is it a 64 bit or 32 bit win7?

its a 64 bit os. but the re install seemed to fix it…

e

[peterlaursen]

OK .. but let me explain anyway:

On a 32 bit system everything is 32 bit (the OS, the ODBC driver and SQLyog). No conflicts will arise.

On a 64 bit system the OS is 64 bit, SQLyog is 32 bit (we don't ahve 64 bit version yet). The ODBC driver may be 32 bit or 64 bit. To use a 64 bit driver in this environment the DSN must be a 'user DSN'. A 'system DSN' will not work here. Also to configure a DSN using a 64 bit driver you cannot do from Contol Panel .. Data Soruce as this will open the 64 bit version of the ODBC manager. Refer: http://support.microsoft.com/kb/942976

“The 64-bit ODBC Administrator tool can be invoked from Control Panel to manage user DSNs and system DSNs that are used by 64-bit processes. On a 64-bit operating system, the 32-bit ODBC Administrator tool is used for Windows on Windows 64 (WOW64) processes. You must directly invoke the 32-bit ODBC Administrator tool from the SysWoW64 folder. You can use the 32-bit ODBC Administrator tool to manage user DSNs and system DSNs that are used by WOW64 processes.

…

Registry redirection is enabled for this registry subkey. Therefore, system DSNs for 32-bit drivers and for 64-bit drivers are separated. The 64-bit ODBC Administrator tool does not display system DSNs that are created by the 32-bit ODBC Administrator tool. Similarly, the 32-bit ODBC Administrator tool does not display system DSNs that are created by the 64-bit ODBC Administrator tool. Also, the 64-bit ODBC Administrator tool does not display system DSNs that use 32-bit drivers. Similarly, the 32-bit ODBC Administrator tool does not display system DSNs that use 64-bit drivers.

[peterlaursen]

BTW: the command to open the 32 bit ODBC manager on 64 bit systems is

Code:

{system_drive}:WindowsSysWOW64>odbcad32

[Author]

Posts