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)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment