IT Nota

  • Home
  • How To
  • .NET
  • WordPress
  • Contact
You are here: Home / How To / How to Setup ODBC Connection

How to Setup ODBC Connection

Launch Microsoft ODBC Data Administrator

On a 64-bit Microsoft OS, there will be two versions of Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe) in two different locations:

  • %systemdrive%\Windows\SysWoW64 folder (32-bit)
  • %systemdrive%\Windows\System32 folder (64-bit)

The Odbcad32.exe file displays the following types of data source names (DSNs):

  • System DSNs (Visible to all users on the machine, including NT services)
  • User DSNs (Only visible to current user and can only be used on the current machine)

In this tutorial, we’re going to create a System DSN to an SQL Server Database.
ODBC Data Source Administrator

Click on Add button and select the latest SQL Server Native Client if possible (otherwise SQL Server will work just fine), click Finish. You can download the latest SQL Server Native Client (sqlncli.msi) from Microsoft® SQL Server® 2012 Feature Pack link.

Microsoft SQL Server Native Client 11.0 is installed when you install SQL Server 2016 (13.x).

ODBC Create New Data Source

This will bring up a new screen to setup SQL Server data source. Type in all the pertinent information for the SQL Server and click Next.

ODBC Create New Data Source to SQL Server

Enter the SQL Server user id and password to access the database.

ODBC SQL Server Data Source Authentication

Click Next two times and Finish and you should see the entry on the System DSN tab.

ODBC Data Source Administrator System DSN

Download

Microsoft® SQL Server® 2012 Feature Pack

Further Reading

ODBC Administrator tool displays both the 32-bit and the 64-bit user DSNs in a 64-bit version of Windows
SQL Server Native Client
Installing SQL Server Native Client

May 29, 2013 Filed Under: How To Tagged With: Microsoft, Microsoft SQL Server, SQL Server, Windows

Leave a Reply Cancel reply

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

Buy me a coffee Support this site
Buy Me a Coffee?

Categories

  • .NET
  • Coding
  • Cybersecurity
  • Database
  • How To
  • Internet
  • Multimedia
  • Photography
  • Programming
  • Resources
  • Review
  • Tips and Tricks
  • Use Case
  • WordPress
  • Writing

Recent Posts

  • How to Check Installed .NET Framework Version
  • How to Remove .NET Runtime and SDK on Mac
  • How to Solve Intermittent 403 Error in IIS
  • How to Show Hidden Folders and Files in Mac Finder
  • How to Solve MS Office VBA Compile Error UserAuthentication

Recent Posts

  • How to Check Installed .NET Framework Version
  • How to Remove .NET Runtime and SDK on Mac
  • How to Solve Intermittent 403 Error in IIS
  • How to Show Hidden Folders and Files in Mac Finder
  • How to Solve MS Office VBA Compile Error UserAuthentication
  • RSS

Tags

.NET Access AdSense ASP.NET Cdonts Dll Classic ASP Code Editor ETL FSharp Genesis Framework Git Google HP Asset Manager HTML HTML5 Hugo IIS Information Security Internet Internet Information Services iOS JAMStack Linux macOS Microsoft Microsoft SQL Server MVC PHP Python Simple Mail Transfer Protocol Smtp Server Social Media SQL SQL Server SSIS SSMS SSRS Sublime Text Visual Studio Visual Studio Code VPN Windows Windows 8 Windows 10 Windows Server

Copyright © 2011-2022 IT Nota. All rights reserved. Terms of Use | Privacy Policy | Disclosure