Friday, March 9, 2012

Linked server AS400/DB2 trouble again

Hi !
I'm trying to create Linked Server to AS400 DB2 on SQL Server 2000.
Using IBMDA400 (IBM AS400 OLEDB Provider installed from Client Access).

Got an error 7399: OLEDB Provider returned UNKNOWN error.

exec SP_AddLinkedServer
@.Server=AS_SERVER,
@.SrvProduct='IBM AS400 OLEDB Provider',
@.Catalog='QGPL',
@.Location='AS_SERVER',
@.Provider=IBMDA400,
@.Datasrc=AS_SERVER,
@.Provstr='Provider=IBMDA400.1;Password="";User ID=AS_USER;Data Source=AS_SERVER;Transport Product=Client Access;SSL=DEFAULT;Libraries=QGPL;Connect Timeout=90;Host Code Page=037'

Attempted different combinations of theese params...

After that created remote login on AS400.

Please help or correct my LinkedServerProperties...

Regards,
PVHave you looked at this old posting:

dbForums - BD2OLEDB (http://dbforums.com/t477702.html)

No comments:

Post a Comment