!!!HOW TO SET UP ODBC

The first step is to configure the ODBC Administrator.

The ODBC Administrator may be accessed through the Start menu, using the following path Start/Programs/Oracle 8I7/Network Administrator/MS ODBC Administrator

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'}]


[{If var='loginstatus' contains 'authenticated'

----
![Discussion|Edit:Internal.HOW+TO+SET+UP+ODBC] 	
[{InsertPage page='Internal.HOW+TO+SET+UP+ODBC' default='Click to create a new discussion page'}] 	

}]