Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    176

    Unanswered: AS400 driver issue

    I am connecting to an AS400 from SQL Server using the iSeries Client Access. I am getting the following error when attempting to select from 1 table:

    Server: Msg 7317, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' returned an
    invalid schema definition.

    The select looks something like: SELECT * FROM <instance>..<owner>.<tablename>

    Selecting a subset of the fields (instead of all) does not make a difference.

    All other table selects work fine - this is only a problem for one table

    Any ideas? Your insight would be greatly appreciated. Thanks!

  2. #2
    Join Date
    Mar 2003
    Location
    Indiana, USA
    Posts
    100
    I would guess one of the columns is of a type not understood by SQL Server.

    You might have to create a view on the problem table that casts the columns to VARCHAR Types and see if it works that way.

    Tim S

  3. #3
    Join Date
    Sep 2003
    Posts
    176
    We have 2 Windows 2003 servers, one running Standard Edition and the other Enterprise. Both connect to the AS400 via iseries ODBC. What is interesting is the server running standard can see the table via QA while the Enterprise cannot. However both can see the table using DTS. Strange isn't it?

    Let me know your insights.

Posting Permissions

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