Windows

How to add an ODBC entry Windows 7

ODBC (Open Database Connectivity) is the mediator between a workstation and server that allows the establishing and “talking” to a database.  ODBC configuration utility in Windows 7 allows one to easily create a connection with a database server, test the user/pass combination and select database instances and connection configuration information to establish the connection.

Launching and Configuring ODBC

ODBC can easily be configured from an x86 workstation by opening a command prompt or a run emnu and typing ocbcad32.exe.

odbc1

odbc2

odbc3


odbc4
Aside from the above configuration, you can configure the ANSI connection information, the default DB and also test the configuration using the builtin test utility.  ODBC configuration is necessary with most DB connections from Windows workstations which need to “talk” to a DB.

64-bit Workstations

If you are configuring ODBC on a 64-bit workstation, you will need to launch the ODBC utility by executing c:\windows\syswow64\odbcad32.exe

Subscribe to VirtualizationHowto via Email 🔔

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Brandon Lee

Brandon Lee is the Senior Writer, Engineer and owner at Virtualizationhowto.com and has over two decades of experience in Information Technology. Having worked for numerous Fortune 500 companies as well as in various industries, Brandon has extensive experience in various IT segments and is a strong advocate for open source technologies. Brandon holds many industry certifications, loves the outdoors and spending time with family.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.