Re: BLOBS via ODBC - Access Violation Every Time

In article <8richd$cu5$1_at_nnrp1.deja.com>,   David Murphy <NetDirect_at_compuserve.com> wrote:
> Hi - we are trying to insert data into a BLOB column using Oracle's
> ODBC driver ODBC version 8.01.05.00 2/16/99. It crashes with an access
> violation every time.
>
> If we do the same code with a LONG RAW everything works just fine..
>
> The table has one column which is a BLOB. It crashes on the 2nd call
 to
> SQLParamData which should just return a status to say no more data is
> required. The amount of data is around 50K.
>
> The code (summarized) is..
>
> SQLPOINTER p;
> while (SQLParamData(hStatementHandle, &p) == SQL_NEED_DATA) {
> ..
> long nMaxChunk = 32000;
> long nDone=0;
>
> while (nDone < nSize) {
> long nToSend = nSize - nDone;
> if (nToSend > nMaxChunk)
> nToSend = nMaxChunk;
>
> int nStatusPut = SQLPutData(hStatementHandle, pData + nDone,
> nToSend);
> nDone += nToSend;
> }
> }
>
> BTW - how does one download the latest ODBC drivers for an Oracle
> release? I find their site particularly confusing and still cannot
 find
> any such download.

If you go to the OTN (Oracle Technology Network) at <http://otn.oracle.com> and choose "Software" from the left-hand menu, you'll go to the software download page. Select the ODBC driver from the "Drivers & Utilities" pull-down and you'll go to the ODBC driver download page.

If the 8.1.5.6 ODBC driver doesn't solve your problem, please try installing the latest 8.1.5 patchkit to your client machine (8.1.5.1.1 I believe). Oracle patchkits are available for download at ftp://oracle-ftp.oracle.com/server/patchsets/wgt_tech/server/windowsNT/

Let me know if these updates solve your problem. If they don't, I'll try to look into this further.

Justin Cave
Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of Oracle Corporation.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 05 2000 - 15:59:32 CDT