Video Screencast Help
Security Community Blog

ODBC Connection on 64-Bit Operating System

Created: 18 Sep 2009 • Updated: 18 Sep 2009 • 4 comments
Mudit Kumar's picture
+3 3 Votes
Login to vote

It’s important to know which kind of DSN you are suppose to check when you are Troubleshooting ODBC Connection.

If you want to check ODBC Connection on x64 system, you can check or create an ODBC Connection(DSN) for 32 Bit application and also use it for 64 Bit application.

32-bit applications will only look for ODBC connections created in the 32-bit, and 64-bits applications will look for ODBC connections from the 64-bit. 

So if you want to configure DSN for 32-bit application on 64-Bit OS you will have to use:

1. C:\Windows\SysWOW64\odbcad32.exe(Used to check ODBC for Symantec Endpoint Protection Manager)

You want to do the same on 64-bit application on 64-Bit OS you can use:

2. C:\Windows\System32\odbcad32.exe

Note: In case of Symantec Endpoint Protection Manager installed on 64 Bit Operating System we get confused about where to locate ODBC Connection.

So it will be found under "C:\Windows\SysWOW64\odbcad32.exe"

Comments 4 CommentsJump to latest comment

Aniket Amdekar's picture

This proves to be crucial as the ODBC DSN is not usually shown in a 64 bit machine. So everybody starts wondering if there is something wrong with the ODBC Connection.

But its just the fact that the ODBC DSN is not shown in 64 bit servers unless you use the methods mentioned aove.

Nice info Mudit.

Cheers,
Aniket

+2
Login to vote
Symanticus's picture

yes, that is true and thanks for sharing.

in case for other application, I use Oracle Client 10g 32 bit inside the Windows Server 2003 x64

/* Infrastructure Support Engineer */

+2
Login to vote
blackvirus009's picture

its a bit basic question but can u tell me what is ODBC?

-3
Login to vote
Ashish-Sharma's picture
ODBC stands for Open Data Base Connectivity. It is a connection that is created to define a connection between a computer and a database stored on another system. The ODBC connection contains information needed to allow a computer user to access the information stored in a database that is not local to that computer.

 

Thanks In Advance

Ashish Sharma

 

 

+2
Login to vote