How to Access and Configure Microsoft Open Database Connectivity (ODBC) 32-bit on Windows 7 - 64 bit

Are you having trouble configuring ODBC DSN on a machine with Windows 7 64 Bit?

The default Windows 7 64 -bit ODBC 64Bit is , and does not work for programs that need a connection to the ODBC source 32Bit . See how to configure data source 32-bit Windows 7 64Btis

Solution

1. Click Start , Run ( or Windows + R key) and type: %windir%\SysWOW64\odbcad32.exe;

2 . Perform the necessary settings and test.

So when your application is using the connection with 32 -bit source , the connection is automatically loaded from the DSN configured in Odbcad32.exe located in the %systemdrive%\Windows\SysWoW64 folder.

The 64-bit version of Microsoft Windows 7 includes the following versions of the Administrator tool data source Microsoft Open Database Connectivity ( ODBC ) :

* The 32-bit version of Odbcad32.exe file that is located in the %systemdrive%\Windows\SysWoW64
* And the 64-bit version of Odbcad32.exe file located in the %systemdrive%\Windows\System32 folder.

Another time you may encounter this problem is when you try to add a data source and are not seeing the drivers for ODBC database connection. The following window is displayed:



If the source is not showing up - the problem is the same one mentioned above - it probably is Windows 7 64Bit and 32bit are installed fonts. 

Solution 

1. Click Start, Run and type: %windir%\SysWOW64\odbcad32.exe 

So the 32-bit version Odbcad32.exe file will be initialized in the %systemdrive%\Windows\SysWoW64 folder. 

Then you will see the following window:

Now just add the driver for which you want to configure the data source .

What is ODBC ?

ODBC is a technology that programs use to access a wide range of databases ( or data sources ) . For example , the ODBC can be used to import data from a MySQL database into a Microsoft Excel spreadsheet . For this, the computer needs the data source and the correct ODBC driver .

For custom programs , software developers use the Application Programming Interface ( API) to access ODBC data sources . ODBC is an implementation of the SO / IEC 9075-3 Information Technology - Database languages ​​- SQL -Part 3 : Call Level Interface ( SQL / CLI ) .

Where can I find a ODBC driver ?
Programs database generally include their own drivers , and many ODBC drivers are available in the list of drivers from the ODBC Data Source Administrator. You can also try to search the internet or can contact the manufacturer of the database you want to use the program.

Comentários

LEIA-ME

Criar ferramentas e scripts que facilitam seu trabalho no dia a dia, solucionar problemas, documentar tudo e criar o passo a passo de como resolver, é uma tarefa que requer tempo e disposição. Por esse motivo, precisamos de sua contribuição.




Apesar de não ser obrigatória, a sua doação é muito importante para continuarmos criando ferramentas, scripts e procedimentos!
Com sua contribuição manteremos o funcionamento e desenvolvimento dessas e outras soluções.