Linked Server to SQL Server

[arst06d]

Hi
I want to link our AS400 to SQL Server as a "linked server" using the IBMDA400 OLEDB driver installed with Client Access.

I've gone through the motions in SQL Server Enterprise Manager but keep getting "Error 7303: Could not initialise Datasource object of OLEDB Provide IBMDA400" when I try to browse the tables.

I've obviously loused this up, but I cannot find any decent reference to help with the set up.

In Enterprise Manager - what details do I put in what boxes when I'm setting up the linked server?

 

[Shihab71]

Hi arst06d,

Had a lot of trouble in doing the same, but finally got thru.
Here's what I did.

In enterprise manager,
security
linked servers
new linked server

The dialog box will open up.
In the column Product Name, type in :
Microsoft OLE DB Providor For DB2

Type in a DSN Name (just to be on the safe side, create the same DSN in ODBC)

In the column Provider String type in
InitCat=(catalog name);NetLib=TCPIP;NetAddr=(ip address of the AS400);NetPort=446;PkgCol=QGPL;DefSch=(the DSN Name)

the catalog name should be provided to you by your DB Administrator. In my case, the logical name of the AS/400 on our network was the same as the catalog name.

In the column catalog type in the same catalog name as above entered

Now click on the security tab,
I have used ,Be made using this security context
type in the username & password.
I have used this connection method as this application links 3 different databases and used the AS/400 as a view only permission

Once all above done, click on the tables and see if you can see the available tables.

good luck
Shihab Mohd

 

[Shihab71]

OH!!!!
forgot to add the pre-requisite

You will have to install Microsoft Host Integration software.
This has the Microsoft OLE DB Providor For DB2 drivers.


Shihab Mohd