Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    Unanswered: linked server to as400

    hi everybody,

    I am new to this forum and also new to sql server. Please help me.

    I want to linked sql server to as400.
    Client Access Express 4.5 with latest service pack
    Sql server 2000 with SP3.

    I have created system DSN from client access odbc driver. I added linked server whith system dsn. I could see linked tables and views on linked server. but when i start query I get error:

    OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned 0x80004005: ]B

    and the same time i get one record set only.

    Please help me to slove it.

    Thank you in advance.

  2. #2
    Join Date
    Sep 2003
    From what I gather, you are trying to tie a DB2 database to an SQL Database? Or are you actually using the IBM Client Data Access pack to retrieve data from the Sql Server? Please elaborate.

  3. #3
    Join Date
    Oct 2003

    linked server

    Thank you beyond cool,

    What i want to do is,
    I have some master tables(Files) in as400 and others tables in sql server. I want to join both tables to make view. So, I linked as400 server into sqlserver throught client access odbc driver.
    Then i run "Select * from openquery(LinkedServer, 'Select * from Schema.table').
    From this query i get only one recordset and an error which i mentioned.

    Please advice me the right way to do it.

    Thank you,

Posting Permissions

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