Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008

    Unanswered: MSSql Server2005 linked server as400

    Hi everyone,
    i created a linked server to as400 with mssql2005 using odbc driver.

    Quering the as400 using openquery function i have quick answer (1").

    Making the same query using 4 part name costructor i have slow answer (1'30")

    Moreover when i build a view in sql2005 vs as400 tables i have slow response, and is not possible to build an index on a view because of the table is on linked server.

    There's somebody who has a suggestion or i have to use 4 part name costructor?
    Do you think that a stored procedure is better?

    thank's in advance for your answer

  2. #2
    Join Date
    Jun 2004
    Long Island
    Why not use OpenQuery ?

  3. #3
    Join Date
    Jan 2009

    Unhappy my linked server does not work

    hey I created a linked server to the as400 and i am getting an error.

    AN EXCEPTION occurred while executing a transact-sql statement or batch.

    cannot initialize the data source object of OLE DB provider "IBMDA400" for linked server.

    would you have a thought as to why this is happening?

    i am able to create the linked server using Microsoft OLE DB provider for indexing service, but i am not able access the tables.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts