[SQL] Use LinkServer connect to IBM AS400

2013-09-24

 

Install IBM iSeries Navigator, make sure “iSeries Access for Windows .NET provider” option is checked

SNAGHTML3c5763

If you don’t have the CD-Row, please go to here to order

go to ODBC setting

clip_image002

Add a new Data Source: Client Access ODBC Driver (32-bits)

clip_image002[4]

It will direct you to the Setting ( you can set more detail after this)

Name your Data Source name: xxxSourceName

clip_image002[6]

AS/400 System: you need to add in IBM iSeries Navigator first or you can set it up manually

After this, you will see the pic below in your “ODBC Data Source Administrator” setting

SNAGHTML9fae99

SNAGHTML9ffefa

 

The Linked Server can now be created

Microsoft SQL Server Management Studio –> Server Objects -> Linked Servers –> right click and "New Linked Server "

Linked Server: doesn’t matter what name you are naming (xxxxx)

Server Type: Other Data Source

Provider: Microsoft OLE DB Provider for ODBC Drivers

Product Name : ODBC Data Source

Data Source: enter the name which you named in ODBC in your computer, they should be matched

 

Then go to the “Security” tab on the left

Choose “Be made using this security context” option

Enter your IBM AS/400 account/password

 

SNAGHTMLa87fcc

 

Done!!

Technorati Tags: ,
Newer Older