Create or Modify 32bit ODBC connection on 64bit Operating System

2
Jan 2011

Create or Modify 32bit ODBC connection on 64bit Operating System

comment icon11 comment(s) |

I recently ran into a problem with a new 64bit Windows 7 machine where needed a 32bit based ODBC connection modified for a 3rd party application. When I went to the typical location to modify the new ODBC connection in Control Panel\Admin Tools, the ODBC that was automatically created with the 3rd application installation was not listed. Here is a handy trick that enables you to view, edit or create a 32bit ODBC connection on a 64bit Operating System.

To bring up the 32bit ODBC settings page, browse to the following location and create or modify the connection as needed.

C:\Windows\SysWOW64 and open up odbccad32.exe

Comments

September 22, 2011

Vivek

Thanks bro...

Thanks bro...

March 30, 2012

A Schunka

File name

In my Windows 7 (x64) installation the file name is odbcad32.exe (single 'c'). I don't know if other versions have the file name odbccad.exe (double 'c') or if this was a typo.

June 29, 2012

Preeti

thanks.. it really helped

thanks.. it really helped me...

June 20, 2012

Greg

Thank you so much ... saved me hours of stuffing around

Thank you so much ... saved me hours of stuffing around

February 23, 2013

Raj Patel

Appreciation

Nice help Darien. *****

April 9, 2013

josh G

32bit ODBC on a 64bit OS

Super work !! You saved me lots of time troubleshooting.

May 6, 2013

Anonymous

Thanks for the tip

Thanks for the tip

May 23, 2013

mohit parmar

information

Thanks Alot dude. It was ereally helping hand for me.

August 15, 2013

Ramana peram

Thank you so much sir I am

Thank you so much sir I am very happy for your help

February 19, 2014

Sebastien

Thx bro. It saves me lots of

Thx bro.
It saves me lots of pain.

August 6, 2014

Anonymous

Hi Mr Darien Smith when I try

Hi Mr Darien Smith

when I try to open Data on server this way it doesn't work. I got this massage

pervasive Odbc client interface LNA pervasive odbc engine interface data record manager the specified file name invalid

thank you

Search