Example of a linked server to AS400 ODBC
-
Can anyone provide an example of a linked server to an AS400 ODBC data source?
Looking for the syntax, ie. sp_addlinkedserver .....
Thanx for any help
-
Don't know if this will be of any help, but this is how we link in our Progress database which resides on a UNIX server.
EXEC dbo.sp_addlinkedserver
@server = 'SHARES_SERV' -- The name that shows up in the list
, @srvproduct = 'Progress' -- Database type name
, @provider = 'MSDASQL' -- OLE/DB for ODBC
, @datasrc = 'shares' -- ODBC DSN
, @location = NULL
, @provstr = NULL
, @catalog = NULLHope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
-
Since there isn't a search for the forums, I copied this posting from a previous topic for my own reference. The original poster was setting up the linked server from Enterprise Manager, so I hope you can translate this to a sp_addlinkedserver call.
--Begin Copy---------------------------------
I have successfully set up a linked server to an AS400. It was painful, because there is scant documentation for it.
What you need to do is add the following string to the Provider String text box in the Linked Server Dialog window:
DRIVER={Client Access ODBC Driver (32-bit)};UID=YourID;PW=YourPassword;SYSTEM=YourAS400;CMT=0;DBQ=RMSFILESDT;NAM=0;DFT=0;DSP=0;TFT=0;TSP=0;DEC=0;XDYNAMIC=1;RECBLOCK=1;BLOCKSIZE=8;SCROLLABLE=1;TRANSLATE=0;LAZYCLOSE=0;LIBVIEW=0;REMARKS=0;CONNTYPE=0;SORTTYPE=0;PREFETCH=0;DFTPKGLIB=QGPL;LANGUAGEID=ENU;SORTWEIGHT=0;MAXFIELDLEN=32;COMPRESSION=0;ALLOWUNSCHAR=0;SEARCHPATTERN=1;MGDSN=0;
Of course, those items in red will have to be changed for your system.
--End Copy----------------------------------
-
Cppwiz,
Thanx, this is what I was looking for. Will give it a whirl.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply