Guides you through the process of cataloging the OESQLDemo connection as an ODBC data source.
Start the ODBC Data Sources (32-bit) app
This is a Windows operating system app. It's location on the
Start menu varies from one version of Windows to another. We suggest that you find and launch the ODBC Data Sources (32-bit) app
using the search box provided by the
Start menu. Search for
ODBC to find and start the app.
Catalog the OESQLDemo connection
- From the
ODBC Data Source Administrator (32-bit) window, select the
System DSN tab, then click
Add.
- From the list of drivers, select the most recently installed version of
SQL Server Native Client; then click
Finish.
- In the
Name field, type
OESQLDemo. This is the name of the ODBC connection.
- From the drop-down list, select a SQL Server, or type the name of a server such as
(local) or
(localdb\v11.0), depending on what SQL Server product you have installed, and then click
Next.
- On the resulting dialog box, click
Next to use Windows authentication.
- Change the default database to
OESQLDemo, then click
Next.
- Click
Finish to save your changes.
- Click
Test Data Source to ensure that the connection works properly.
- Click
OK to clear the message.
- Click
OK twice to exit the ODBC Data Source Administrator (32-bit) app.