Sybase SQL Anywhere 7.0 Error through PCO 2.3

[Former Member]

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

[former_member196557]

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

[Former Member]

Hi Steve,

Thanks for your reply.Please find the details below

1. PCo Version (from help - about)

          2.3

     2.Which Source Agent (OLEDB or ODBC)?

          OLEDB

3.PCoConnector in MII pointing to correct PCo Agent Instance? (confirm Query Port)

     Yes.We are able to see the available table in MII

4.Which MII Query Template used: PCoQuery or SQLQuery?

PCOQuery.we have connected through PCO connector

Regards,

Shanmugam K

[former_member196557]

Hi Shanmugam,

I can successfully execute and OleDB Agent Instance PCoQuery (using SQLServer OLEDB connector, don't have Sybase) with PCo 2.303.1811.1341 and MII 14.0 SP4 Patch 1.  Are you at the same PCo and MII version levels?

Regards, Steve

[Former Member]

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