Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Question Unanswered: Sql Server 7 to AS400

    I am trying to get my SQL Server to query an AS400 database. I have the linked server set up and can see tables/views but get this error "Server: Msg 7313, Level 16, State 1, Line 1
    Invalid schema or catalog specified for provider 'MSDASQL'." when querying through SQL query analyzer.

    Any ideas?

    Thanks.

  2. #2
    Join Date
    Sep 2003
    Posts
    17

    Re: Sql Server 7 to AS400

    I presume you're using ODBC. Sounds like yr driver. Also remember the Date range clash in DB2 and Sql.

Posting Permissions

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