Re: Error using adBSTR with MDAC 2.7

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 4 Apr 2003 05:37:14 -0800
Message-ID: <a20d28ee.0304040537.e919d48@posting.google.com>

rainer.hirthammer_at_software-objects.com (Rainer Hirthammer) wrote in message news:<3e8d3eac.1784966_at_news.btx.dtag.de>...
> (Maybe this is off topic, but we didn't got help in other groups like
> Visual Basic, databases etc.)
>
> Oracle 8.1.7, MS Data Access Components (MDAC) 2.7, VB6 SP5
>
> Any usage of adBSTR (null terminated string) when execute a Stored
> Procedure Call with MDAC 2.7 throws the error -2147217887 "SQL
> datatype out of range". The error doesn't occur with MDAC 2.6. Using
> adVarChar and parameter.size = n works, but it would be too costly to
> rework the whole app.
>
> Anyone an idea?
>
> Thanks a lot
> Rainer

Yeah sure. Obviously this is a MicroSux problem, and not an Oracle problem. Please bark at the correct door and have Microsux resolve their own bugs.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Apr 04 2003 - 07:37:14 CST