Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQLOLEDB reporting error when use multiple ISequentialStream

25 views
Skip to first unread message

vijay singh

unread,
May 7, 2009, 9:24:23 AM5/7/09
to
Database : SQL Server 2005

provider - SQLOLEDB

os- windows 2003

Hi,

I have a table a [Test] which has four columns as given detail

Column name Data type

---------- ------------------

id int

LOGDATA varbinary(max)

SEGDATA varbinary(max)

NONFAERRORLOG varbinary(max)

I am using ISequentialStream to access varbinary data. For single
ISequentialStream program is working fine. For example

BEGIN_COLUMN_MAP(CtestAccessor)
COLUMN_ENTRY_LENGTH_STATUS(1, m_id, m_dwidLength, m_dwidStatus)
BLOB_ENTRY_LENGTH_STATUS(2, IID_ISequentialStream, STGM_READ, m_LOGDATA,
m_dwLOGDATALength, m_dwLOGDATAStatus)
END_COLUMN_MAP()

For multiple ISequentialStream program is returning error for example

BEGIN_COLUMN_MAP(CtestAccessor)
COLUMN_ENTRY_LENGTH_STATUS(1, m_id, m_dwidLength, m_dwidStatus)
BLOB_ENTRY_LENGTH_STATUS(2, IID_ISequentialStream, STGM_READ, m_LOGDATA,
m_dwLOGDATALength, m_dwLOGDATAStatus)
BLOB_ENTRY_LENGTH_STATUS(3, IID_ISequentialStream, STGM_READ, m_SEGLOG,
m_dwSEGLOGLength, m_dwSEGLOGStatus)
BLOB_ENTRY_LENGTH_STATUS(4, IID_ISequentialStream, STGM_READ,
m_NONFAERRORLOG, m_dwNONFAERRORLOGLength, m_dwNONFAERRORLOGStatus)
END_COLUMN_MAP()

Following sql has been used to fetch data

DEFINE_COMMAND_EX(CtestAccessor, L" \
SELECT \
id, \
LOGDATA, \
SEGLOG, \
NONFAERRORLOG \
FROM dbo.test")

Program is also giving error when used multiple assessors

BEGIN_ACCESSOR_MAP(CtestAccessor, 3)

BEGIN_ACCESSOR(0, true)
COLUMN_ENTRY_LENGTH_STATUS(1, m_id, m_dwidLength, m_dwidStatus)
BLOB_ENTRY_LENGTH_STATUS(2, IID_ISequentialStream, STGM_READ,
m_LOGDATA, m_dwLOGDATALength, m_dwLOGDATAStatus)
END_ACCESSOR()

BEGIN_ACCESSOR(1, true)
BLOB_ENTRY_LENGTH_STATUS(3, IID_ISequentialStream, STGM_READ,
m_SEGLOG, m_dwSEGLOGLength, m_dwSEGLOGStatus)
END_ACCESSOR()

BEGIN_ACCESSOR(2, true)
BLOB_ENTRY_LENGTH_STATUS(4, IID_ISequentialStream, STGM_READ,
m_NONFAERRORLOG, m_dwNONFAERRORLOGLength, m_dwNONFAERRORLOGStatus)
END_ACCESSOR()

END_ACCESSOR_MAP()

Please suggest me to fix issue.

Thanks.

Vijay


Erland Sommarskog

unread,
May 8, 2009, 6:11:48 PM5/8/09
to
vijay singh (vijay...@abosoftware.com) writes:
> For multiple ISequentialStream program is returning error for example
>...
> Program is also giving error when used multiple assessors

Not that I believe that I have the knowledge to help you, but you should
really include the error messages you are getting.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

vijay singh

unread,
May 9, 2009, 12:34:22 AM5/9/09
to
I am getting error message "No such interface supported" when i am using
multiple ISequentialStream in an accessor.

Thanks,

Vijay

"Erland Sommarskog" <esq...@sommarskog.se> wrote in message
news:Xns9C062054...@127.0.0.1...

Erland Sommarskog

unread,
May 9, 2009, 5:06:54 AM5/9/09
to
vijay singh (vijay...@abosoftware.com) writes:
> I am getting error message "No such interface supported" when i am using
> multiple ISequentialStream in an accessor.

Well, that error messages looks clear enough. Looks you will have to find
another approach for what you want to do. Unfortunately, I've never worked
with ISequentialStream, so I cannot give any advice.
0 new messages