Versions Compared

Old Version 1

changes.mady.by.user SRP Support

Saved on

compared with

New Version Current

changes.mady.by.user Corby Nagel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

We will set up an ODBC connection to the SQL Server PUBS database, called PUBS.  This This is done through the ODBC Data Source Administrator, a program which is either launched from Control Panel or from Administrative Tools, depending on your Windows version.  We We will define the connection using the SQL Server driver.

From the User Data Source tab, click Add.  You You will be prompted to add a data source.  Scroll Scroll down to SQL Server and highlight it.  The The display will be similar to the one shown below:

Click Finish.  You You will then be prompted to enter the details for the SQL Server DSN configuration.  Enter Enter the following:

  • Name: Pubs

  • Description: Example PUBS Database

  • Server: (the name of your SQL Server instance)

  Enter the information as shown below:

.

Click Next>.  You You will be prompted for connection information, including authentication.  This This varies from one installation to another.  In In the configuration below, SQL Server authentication is used, with the System Administrator logon sa.  This This is the most generous authentication, allowing the user full access rights, and may not apply to you.  Consult Consult with your database administrator for the authentication parameters.

...

The next window allows you to change the default database.  Change Change it to pubs and then click OK.  The The window should display similar to the one below:

...