Skip to Content
avatar image
Former Member

Sybase SQL Anywhere 7.0 Error through PCO 2.3

Hello Experts,

We have connected Sybase SQL Anywhere 7.0 through PCO 2.3.We are able to connect to the DB through pco connector but when we try to execute the any pco query in MII its through below error.Could you please help us in solving this issue?

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>

- <Rowsets CachedTime="" DateCreated="2014-01-22T11:27:25" EndDate="2014-01-22T11:27:25" StartDate="2014-01-22T10:27:25" Version="14.0.2 Build(82)">

<FatalError>Query execution failed due to following: Unable to cast COM object of type 'System.__ComObject' to interface type 'IRowset'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{0C733A7C-2A1C-11CE-ADE5-00AA0044773D}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).</FatalError>

</Rowsets>



   Regards,

  Shanmugam




Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 22, 2014 at 02:13 PM


    Hi Shanmugam,

    Some details needed:

    1. PCo Version (from help - about)
    2. Which Source Agent (OLEDB or ODBC)?
    3. PCoConnector in MII pointing to correct PCo Agent Instance? (confirm Query Port)
    4. Which MII Query Template used: PCoQuery or SQLQuery?

    Regards,

    Steve

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Steve Stubbs

      Hi Steve,

      Thanks for your reply.Even i am able to execute the MSSQL OleDB Agent Instance PCoQuery  without any issue.When i try to  read the data from Sybase SQLAnywhere am facing issue.We are using MII 14.2 and PCO 2.3.

      Regards,

      Shanmugam K