Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

OLEDB sample

7 posts in General Discussion Last posting was on 2004-01-13 21:05:22.0Z
Arno Posted on 2004-01-13 10:48:24.0Z
From: "Arno" <seitinger@4u2.com>
Newsgroups: ianywhere.public.general
Subject: OLEDB sample
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 81.223.57.50
X-Original-NNTP-Posting-Host: 81.223.57.50
Message-ID: <4003ccf8$1@forums-1-dub>
Date: 13 Jan 2004 02:48:24 -0800
X-Trace: forums-1-dub 1073990904 81.223.57.50 (13 Jan 2004 02:48:24 -0800)
X-Original-Trace: 13 Jan 2004 02:48:24 -0800, 81.223.57.50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2278
Article PK: 4482

Hi!

I search a sample for OLEDB in C++.
Write and Read Blobs.

Thanks
Arno


Chris Keating (iAnywhere Solutions) Posted on 2004-01-13 14:03:08.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <4003ccf8$1@forums-1-dub>
Subject: Re: OLEDB sample
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: keating-xp.sybase.com
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <4003fa9c$1@forums-1-dub>
Date: 13 Jan 2004 06:03:08 -0800
X-Trace: forums-1-dub 1074002588 172.31.141.1 (13 Jan 2004 06:03:08 -0800)
X-Original-Trace: 13 Jan 2004 06:03:08 -0800, keating-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2280
Article PK: 4484

Have you looked on MSDN? Would the following help?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdaexamples_vc04_2.asp

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Arno" <seitinger@4u2.com> wrote in message news:4003ccf8$1@forums-1-dub...
> Hi!
>
> I search a sample for OLEDB in C++.
> Write and Read Blobs.
>
> Thanks
> Arno
>
>


Arno Posted on 2004-01-13 14:54:16.0Z
From: "Arno" <seitinger@4u2.com>
Newsgroups: ianywhere.public.general
References: <4003ccf8$1@forums-1-dub> <4003fa9c$1@forums-1-dub>
Subject: Re: OLEDB sample
Lines: 63
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 81.223.57.50
X-Original-NNTP-Posting-Host: 81.223.57.50
Message-ID: <40040698$1@forums-1-dub>
Date: 13 Jan 2004 06:54:16 -0800
X-Trace: forums-1-dub 1074005656 81.223.57.50 (13 Jan 2004 06:54:16 -0800)
X-Original-Trace: 13 Jan 2004 06:54:16 -0800, 81.223.57.50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2281
Article PK: 4485

Thank you,
Chris,

but the sample use the employee table.
I need a sample for binary data (blob).
I have a sample with accessors, but only for MS and Oracle, Sybase returns
errors .

Thanks
Arno

"Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>

wrote in message news:4003fa9c$1@forums-1-dub...
> Have you looked on MSDN? Would the following help?
>
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdaexamples_vc04_2.asp
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
>
****************************************************************************
> *
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
>
****************************************************************************
> *
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
>
****************************************************************************
> *
>
> "Arno" <seitinger@4u2.com> wrote in message
news:4003ccf8$1@forums-1-dub...
> > Hi!
> >
> > I search a sample for OLEDB in C++.
> > Write and Read Blobs.
> >
> > Thanks
> > Arno
> >
> >
>
>


Chris Keating (iAnywhere Solutions) Posted on 2004-01-13 15:20:04.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <4003ccf8$1@forums-1-dub> <4003fa9c$1@forums-1-dub> <40040698$1@forums-1-dub>
Subject: Re: OLEDB sample
Lines: 106
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: keating-xp.sybase.com
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <40040ca4$1@forums-1-dub>
Date: 13 Jan 2004 07:20:04 -0800
X-Trace: forums-1-dub 1074007204 172.31.141.1 (13 Jan 2004 07:20:04 -0800)
X-Original-Trace: 13 Jan 2004 07:20:04 -0800, keating-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2282
Article PK: 4486

Sorry about that. This is the link that I had intended to post

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdaexamples_vc04_2.asp

That said, what error(s) are you seeing? Can you provide some code
snipet(s).

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Arno" <seitinger@4u2.com> wrote in message news:40040698$1@forums-1-dub...
> Thank you,
> Chris,
>
> but the sample use the employee table.
> I need a sample for binary data (blob).
> I have a sample with accessors, but only for MS and Oracle, Sybase returns
> errors .
>
> Thanks
> Arno
>
> "Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>
> wrote in message news:4003fa9c$1@forums-1-dub...
> > Have you looked on MSDN? Would the following help?
> >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdaexamples_vc04_2.asp
> >
> > --
> >
> > Chris Keating
> > Sybase Adaptive Server Anywhere Professional Version 8
> >
> >
>
****************************************************************************
> > *
> > Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition
> > and try out the market-leading database for mobile, embedded and small
to
> > medium sized business environments for free!
> >
> > http://www.ianywhere.com/promos/deved/index.html
> >
> >
>
****************************************************************************
> > *
> >
> > iAnywhere Solutions http://www.iAnywhere.com
> >
> > ** Please only post to the newsgroup
> >
> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> >
> >
>
****************************************************************************
> > *
> >
> > "Arno" <seitinger@4u2.com> wrote in message
> news:4003ccf8$1@forums-1-dub...
> > > Hi!
> > >
> > > I search a sample for OLEDB in C++.
> > > Write and Read Blobs.
> > >
> > > Thanks
> > > Arno
> > >
> > >
> >
> >
>
>


Arno Posted on 2004-01-13 15:40:07.0Z
From: "Arno" <seitinger@4u2.com>
Newsgroups: ianywhere.public.general
References: <4003ccf8$1@forums-1-dub> <4003fa9c$1@forums-1-dub> <40040698$1@forums-1-dub> <40040ca4$1@forums-1-dub>
Subject: Re: OLEDB sample
Lines: 573
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 81.223.57.50
X-Original-NNTP-Posting-Host: 81.223.57.50
Message-ID: <40041157@forums-1-dub>
Date: 13 Jan 2004 07:40:07 -0800
X-Trace: forums-1-dub 1074008407 81.223.57.50 (13 Jan 2004 07:40:07 -0800)
X-Original-Trace: 13 Jan 2004 07:40:07 -0800, 81.223.57.50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2283
Article PK: 4487

Thanks Chris!

my test sample:

// SybaseOle.cpp : Defines the entry point for the console application.

#include "stdafx.h"

#include "SyOleBLOB.h"

#include "atldbcli.h"

#include "ISSHelper.h"

#ifdef _DEBUG

#define new DEBUG_NEW

#endif



// The one and only application object

CWinApp theApp;

struct InitOle {

InitOle () { ::CoInitialize(NULL); }

~InitOle () { ::CoUninitialize(); }

} _init_InitOle_;

using namespace std;

class AI003Accessor

{

public:

// ISequentialStream* m_Berechnungsschema;

IStream* m_Berechnungsschema;

ULONG m_Berechnungsschema_LENGTH;

ULONG m_Berechnungsschema_STATUS;

BEGIN_COLUMN_MAP(AI003Accessor)

BLOB_ENTRY_LENGTH_STATUS(1, IID_IStream, STGM_READ, m_Berechnungsschema,
m_Berechnungsschema_LENGTH, m_Berechnungsschema_STATUS)

END_COLUMN_MAP()

void ClearRecord()

{

memset(this, 0, sizeof(*this));

}

};

CSession m_session;

BOOL m_bind;

long m_DBtype;

CString m_Prefix;

long exec(CString sqlstr)

{

CCommand<CNoAccessor,CNoRowset> cx;

HRESULT hr=cx.Open(m_session,sqlstr,NULL,NULL,DBGUID_DEFAULT,false);

if(FAILED(hr))

{

CString Errormsg;

Errormsg.Format(_T("OLEDB error %d "),hr);

cout << Errormsg <<endl;

}

return hr;

}



class AStruRecord : public CCommand<CAccessor<AI003Accessor> >

{

public:

HRESULT OpenRW(int id,int kid1,int kid2,int kid3,int kid4)

{

CString s;

// Set properties for open

s.Format( _T("SELECT BerSchema FROM %s_I003 where Id=%d "),m_Prefix,id);


CDBPropSet propset(DBPROPSET_ROWSET);

propset.AddProperty(DBPROP_IRowsetChange, true);

propset.AddProperty(DBPROP_IRowsetScroll, true);

propset.AddProperty(DBPROP_CANFETCHBACKWARDS, true);

propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE |
DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE);

HRESULT hr;

hr= CCommand<CAccessor<AI003Accessor> >::Open(m_session,s, &propset);

return hr;

}

};

BOOL InsertRow1()

{

CString sqlstr;

sqlstr.Format(_T("INSERT INTO %s_I003 (Id,q1Id,q2Id,q3Id,q4Id)
VALUES(1,0,0,0,0)"),m_Prefix);

if(FAILED(exec(sqlstr)))

return 0;

return 1;

}

BOOL InsertBLOB()

{

AStruRecord *x=new AStruRecord();

HRESULT hr;

BOOL ret=true;

CString smaldata="gfmlkgjoipdjsogmsg";

CISSHelper *ISSBerechnungsschema=new CISSHelper();

x->ClearRecord();

if(FAILED(hr=x->OpenRW(1,0,0,0,0)))

{

delete x;

return ret;

}

if((hr=x->MoveNext())!=S_OK)

{

x->Close();

delete x;

if(hr==DB_S_ENDOFROWSET)

{

if (InsertRow1())

return InsertBLOB();

}

return 0;

}

hr = ISSBerechnungsschema->Write(smaldata.GetBuffer(),smaldata.GetLength(),
NULL );

ISSBerechnungsschema->AddRef();

if ( DBSTATUS_S_OK == x->m_Berechnungsschema_STATUS )

x->m_Berechnungsschema->Release();

x->m_Berechnungsschema = (IStream*) ISSBerechnungsschema;

x->m_Berechnungsschema_LENGTH = ISSBerechnungsschema->m_ulLength;

x->m_Berechnungsschema_STATUS = DBSTATUS_S_OK;

if(FAILED(hr = x->SetData()))

return 0;

return 1;

}

BOOL ReadStruBlob()

{

void *bx=0;

AStruRecord *x=new AStruRecord();

HRESULT hr;

x->ClearRecord();

if(FAILED(hr=x->OpenRW(1,0,0,0,0)))

{

delete x;

return false;

}

if(FAILED(hr=x->MoveNext()))

{

x->Close();

return false;

}

if (x->m_Berechnungsschema && ( DBSTATUS_S_OK ==
x->m_Berechnungsschema_STATUS ))

{

ULONG cb;

bx=(void*)malloc(128000);

x->m_Berechnungsschema->Read(bx,128000,&cb);

}

x->Close();

delete x;

return true;

}

long Connect(CString Connectstring, CDataSource* db, CSession* session)

{

HRESULT hr;

CString User;

CString PW;

CString Server;

CString Database;

CString Provider;

CString Location;

CDBPropSet dbinit(DBPROPSET_DBINIT);

if(m_DBtype==2)

{

m_Prefix="MSDE";

Server="Aibo\\MSDE";

User="";

PW="";

Database="msde123";

Provider="SQLOLEDB.1";

dbinit.AddProperty(DBPROP_INIT_CATALOG, Database);

dbinit.AddProperty(DBPROP_INIT_DATASOURCE, Server);

dbinit.AddProperty(DBPROP_AUTH_INTEGRATED,_T("SSPI"));

}

else

{

m_Prefix="A";

User="dba";

PW="sql";

Location="d:\\PP\\Data\\any8.db";

Database="any8";

Provider="ASAProv.80";

dbinit.AddProperty(DBPROP_INIT_DATASOURCE, Database);

dbinit.AddProperty(DBPROP_AUTH_PASSWORD, PW);

dbinit.AddProperty(DBPROP_AUTH_USERID, User);

dbinit.AddProperty(DBPROP_INIT_LOCATION, Location);

dbinit.AddProperty(DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO,true);

}

dbinit.AddProperty(DBPROP_INIT_LCID, (long)1033);

dbinit.AddProperty(DBPROP_INIT_PROMPT,
(short)DBPROMPT_NOPROMPT);//DBPROMPT_PROMPT

if(FAILED(hr=db->Open(Provider, &dbinit)))

return hr;

if(FAILED(hr=session->Open(*db)))

return hr;

return hr;

}

BOOL InsertDirectBlob()

{


CString s;

/* s.Format(_T("insert into %s_I003 (BerSchema) values() where Id=%d
"),m_Prefix,1);

exec(s);

*/

s="LOAD TABLE A_I003 (BerSchema) FROM 'd:\\blob.dat' where Id=1";

long ret=exec(s);

return true;

}

void CreateTable()

{

CString sqlstr;

sqlstr.Format("drop table %s_I003",m_Prefix);

exec(sqlstr);

sqlstr.Format(_T("CREATE TABLE %s_I003 (Id int null, q1Id int null, q2Id int
null, q3Id int null, q4Id int null, BerSchema image null)"),m_Prefix);

exec(sqlstr);

}

int _tmain(int argc, TCHAR* argv[], TCHAR* envp[])

{

int nRetCode = 0;

if (!AfxWinInit(::GetModuleHandle(NULL), NULL, ::GetCommandLine(), 0))

{

_tprintf(_T("Fatal Error: MFC initialization failed\n"));

nRetCode = 1;

}

else

{

CDataSource db;

CString DBtype;

cout << "DBtype: ";

cin >> m_DBtype;

if(FAILED(Connect("",&db,&m_session)))

return 0;

CreateTable();

InsertBLOB();

ReadStruBlob();

}

return nRetCode;

}


"Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>

wrote in message news:40040ca4$1@forums-1-dub...
> Sorry about that. This is the link that I had intended to post
>
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdaexamples_vc04_2.asp
>
> That said, what error(s) are you seeing? Can you provide some code
> snipet(s).
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
>
****************************************************************************
> *
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
>
****************************************************************************
> *
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
>
****************************************************************************
> *
>
> "Arno" <seitinger@4u2.com> wrote in message
news:40040698$1@forums-1-dub...
> > Thank you,
> > Chris,
> >
> > but the sample use the employee table.
> > I need a sample for binary data (blob).
> > I have a sample with accessors, but only for MS and Oracle, Sybase
returns
> > errors .
> >
> > Thanks
> > Arno
> >
> > "Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>
> > wrote in message news:4003fa9c$1@forums-1-dub...
> > > Have you looked on MSDN? Would the following help?
> > >
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdaexamples_vc04_2.asp
> > >
> > > --
> > >
> > > Chris Keating
> > > Sybase Adaptive Server Anywhere Professional Version 8
> > >
> > >
> >
>
****************************************************************************
> > > *
> > > Sign up today for your copy of the SQL Anywhere Studio 9 Developer
> Edition
> > > and try out the market-leading database for mobile, embedded and small
> to
> > > medium sized business environments for free!
> > >
> > > http://www.ianywhere.com/promos/deved/index.html
> > >
> > >
> >
>
****************************************************************************
> > > *
> > >
> > > iAnywhere Solutions http://www.iAnywhere.com
> > >
> > > ** Please only post to the newsgroup
> > >
> > > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> > >
> > >
> >
>
****************************************************************************
> > > *
> > >
> > > "Arno" <seitinger@4u2.com> wrote in message
> > news:4003ccf8$1@forums-1-dub...
> > > > Hi!
> > > >
> > > > I search a sample for OLEDB in C++.
> > > > Write and Read Blobs.
> > > >
> > > > Thanks
> > > > Arno
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Arno Posted on 2004-01-13 15:48:33.0Z
From: "Arno" <seitinger@4u2.com>
Newsgroups: ianywhere.public.general
References: <4003ccf8$1@forums-1-dub> <4003fa9c$1@forums-1-dub> <40040698$1@forums-1-dub> <40040ca4$1@forums-1-dub> <40041157@forums-1-dub>
Subject: Re: OLEDB sample
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 81.223.57.50
X-Original-NNTP-Posting-Host: 81.223.57.50
Message-ID: <40041351$1@forums-1-dub>
Date: 13 Jan 2004 07:48:33 -0800
X-Trace: forums-1-dub 1074008913 81.223.57.50 (13 Jan 2004 07:48:33 -0800)
X-Original-Trace: 13 Jan 2004 07:48:33 -0800, 81.223.57.50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2284
Article PK: 4489

the error is in

BOOL InsertBLOB()

if(FAILED(hr = x->SetData())) // <==== return hr=DB_E_ERRORSOCCURRED

return 0;



Thanks

Arno


Chris Keating (iAnywhere Solutions) Posted on 2004-01-13 21:05:22.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <4003ccf8$1@forums-1-dub> <4003fa9c$1@forums-1-dub> <40040698$1@forums-1-dub> <40040ca4$1@forums-1-dub> <40041157@forums-1-dub> <40041351$1@forums-1-dub>
Subject: Re: OLEDB sample
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: keating-xp.sybase.com
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <40045d92$1@forums-1-dub>
Date: 13 Jan 2004 13:05:22 -0800
X-Trace: forums-1-dub 1074027922 172.31.141.1 (13 Jan 2004 13:05:22 -0800)
X-Original-Trace: 13 Jan 2004 13:05:22 -0800, keating-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2286
Article PK: 4491

I don't see any reference to GetChunk/WriteChunk which are the typical
methods for reading and writing blob data types via OLEDB.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Arno" <seitinger@4u2.com> wrote in message news:40041351$1@forums-1-dub...
> the error is in
>
> BOOL InsertBLOB()
>
> if(FAILED(hr = x->SetData())) // <==== return
hr=DB_E_ERRORSOCCURRED
>
> return 0;
>
>
>
> Thanks
>
> Arno
>
>