Adding ODBC Settings

To find the place where you set up ODBC settings, click on [START] » [Control Panel] » Administrative Tools » Data Sources (ODBC):

Administrative Tools

Click [ADD]

click add

Scroll down and choose "iSeries Access ODBC Driver"

Scroll down and choose iSeries Access ODBC Driver

click finish, and put in "MicroleaseGate" for the Data Source Name, and RENTAL.MICROLEASE.COM for the System value

put in the settings shown on this screenshot

Click on the [SERVER] tab, then put int MLDTALIB for the SQL default library

put in the settings shown on this screenshot

click on the [PACKAGES] tab and uncheck the box as seen below

put in the settings shown on this screenshot

Click in the [CATALOG] tab and choose "All libraries on the System" from the drop down box

put in the settings shown on this screenshot

Click on [OK] and you're

you have set up the MicroleaseGate ODBC setting

Repeat the steps above, to set up MicroleaseGate2, the only difference is the name Microlease2!!

Repeat for MicroleaseGate3, however, as you are doing it, click on the [SERVER] tab, and enter the value SYNDTALIB in the SQL default library as shown in screenshot below

use SYNDTALIB as shown in this screenshot

This is how the ODBC settings screen should look once all the Microlease Gates have been entered:

this is how the ODBC settings screen should look once all the MicroleaseGates have been entered

Derrick

ą
1.png
(64k)
Unknown user,
31 Aug 2010, 06:28
ą
10.png
(14k)
Unknown user,
31 Aug 2010, 06:29
ą
2.png
(13k)
Unknown user,
31 Aug 2010, 06:28
ą
3.png
(14k)
Unknown user,
31 Aug 2010, 06:28
ą
4.png
(12k)
Unknown user,
31 Aug 2010, 06:28
ą
5.png
(14k)
Unknown user,
31 Aug 2010, 06:29
ą
6.png
(15k)
Unknown user,
31 Aug 2010, 06:29
ą
7.png
(12k)
Unknown user,
31 Aug 2010, 06:29
ą
8.png
(13k)
Unknown user,
31 Aug 2010, 06:29
ą
9.png
(14k)
Unknown user,
31 Aug 2010, 06:29
Comments