This page (revision-4) was last changed on 26-Nov-2021 10:22 by JMyers

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 1 KB JMyers to previous
3 26-Nov-2021 10:22 1 KB JEscott to previous | to last
2 26-Nov-2021 10:22 1 KB JEscott to previous | to last
1 26-Nov-2021 10:22 1 KB JEscott to last

Page References

Incoming links Outgoing links
HOW TO SET UP ODBC
HOW TO SET UP ODBC

Version management

Difference between version and

At line 7 changed 13 lines
#On the first screen, select the File DSN tab at the top of the screen (NOT User DSN or System DSN).
#Once in the File DSN screen, click the Add button in order to add a new data source.
**Upon clicking ADD you will be prompted to select the driver you want to setup as the data source.
# For our purposes, select Oracle ODBC Driver.
# Click on the Finish button.
# You will be then be prompted to select a name for the Access data source. In our example, we provided the name of the database from which we will access data.
# Click the Next button. You are then presented with a summary of your choices.
#Click the Finish button. You are then prompted to connect to the source database with the driver.
**For our purposes here the fields should be completed as follows:
***Service Name = Database Alias
***User Name = Username used to access the database from the mail merge.
***Password = User’s password from P2K
#Click the OK button and the following screen will appear.
1. On the first screen, select the File DSN tab at the top of the screen (NOT User DSN or System DSN).
2. Once in the File DSN screen, click the Add button in order to add a new data source.
*Upon clicking ADD you will be prompted to select the driver you want to setup as the data source.
[{Image src='ODBC FILE DSN.JPG' width='400'}]
3. For our purposes, select Oracle ODBC Driver.
[{Image src='ODBC NEW DATA SOURCE.JPG' width='400'}]
4. Click on the Finish button.
5. You will be then be prompted to select a name for the Access data source. In our example, we provided erosp as the name of the database from which we will access data.
6. Click the Next button. You are then presented with a summary of your choices.
[{Image src='ODBC SUMMARY.JPG' width='400'}]
7. Click the Finish button. You are then prompted to connect to the source database with the driver.
*For our purposes here the fields should be completed as follows:
**Service Name = Database Alias
**User Name = Username used to access the database from the mail merge.
**Password = User’s password from P2K
[{Image src='ODBC DRIVER CONNECT.JPG' width='400'}]
8. Click the OK button and the following screen will appear.
[{Image src='ODBC DRIVER SETUP.JPG' width='400'}]
This page (revision-4) was last changed on 26-Nov-2021 10:22 by JMyersTop