Post reply

AS 400 Linked Server with SQL Server 2005 32-bit

  • January 2, 2008 at 5:02 am

    #184990

    My problem is happening while adding a AS 400 Linked Server. I use

    EXEC sp_addlinkedserver @server='TEST1',

    @srvproduct='IBM AS400 OLE DB Provider',

    @datasrc ='10.36.0.101',

    @provider='IBMDA400',

    @provstr='Initial Catalog=QGPL;CCSID=37;PCCodePage=1252'

    But, it is not effective with IBM AS400 OLE Provider, It gets always time-out score.

    Can Anyone Help Me

  • January 3, 2008 at 8:21 am

    #764380

    Thinky,

    Your Provider String looks to be lacking some information. Start here ...

    Creating a linked server to DB2 using Microsoft OLE DB provider for DB2

    http://support.microsoft.com/kb/222937

    Also note that if you will be pushing inserts to DB2, you will need to have Journaling enabled on the object(s) that will be inserted into via OPENQUERY.

    Hope this helps.

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • January 3, 2008 at 8:25 am

    #764383

    Thinky,

    More notes for reference later.

    Note that the @provstr line may have "wrapped" in the forum posting, it needs to be a single line when being created in T-SQL.

    http://msdn2.microsoft.com/en-us/library/aa259589(SQL.80).aspx

    Use the Microsoft OLE DB Provider for DB2

    This example creates a linked server named DB2 that uses the Microsoft OLE DB Provider for DB2.

    EXEC sp_addlinkedserver

    @server='DB2',

    @srvproduct='Microsoft OLE DB Provider for DB2',

    @catalog='DB2',

    @provider='DB2OLEDB',

    @provstr='Initial Catalog=PUBS;Data Source=DB2;HostCCSID=1252;Network Address=XYZ;Network Port=50000;Package Collection=admin;Default Schema=admin;'

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply