Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!sjc72.webusenet.com!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: postbus@sybrandb.demon.nl (Sybrand Bakker)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Error using adBSTR with MDAC 2.7
Date: 4 Apr 2003 05:37:14 -0800
Organization: http://groups.google.com/
Lines: 24
Message-ID: <a20d28ee.0304040537.e919d48@posting.google.com>
References: <3e8d3eac.1784966@news.btx.dtag.de>
NNTP-Posting-Host: 145.13.42.4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1049463434 1923 127.0.0.1 (4 Apr 2003 13:37:14 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 4 Apr 2003 13:37:14 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:95807
X-Received-Date: Fri, 04 Apr 2003 06:36:57 MST (news.easynews.com)

rainer.hirthammer@software-objects.com (Rainer Hirthammer) wrote in message news:<3e8d3eac.1784966@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