Re: Restricted data type attribute violation.

namrek1_at_hotmail.com (=?ISO-8859-1?Q?Eladio_Rinc=F3n?=) wrote in message news:<ab9b7e0a.0108170438.75237be6_at_posting.google.com>...
> Hi; we are working with VB6.0, RDO and Oracle 8i;
> we have update our Oracle ODBC Driver to the version 8.01.65.00, and
> we start having this error:
> Restricted data type attribute violation.
> The error arise when in the select clause when the sentence returns
> any null values (I've read that it happends with all the null values).
>
> I've read all the messages at the newsgroups with the topic:
> "Restricted data type attribute violation.", and majority of the
> messages suggest to set the Retry count of the ODBC Connection to 0 or
> 1.
>
> That error appear after updating the ODBC Driver from version 8.01.5
> to 8.01.65;
> Is there any official answer to the problem?

First, may I assume that you updated your Oracle client. The 8.1.5.x ODBC driver is designed to run on an 8.1.5 client system, while the 8.1.6.5 ODBC driver is designed to run on an 8.1.6 client system. If you did not update your client to 8.1.6 prior to installing this driver, you need to do so now.

Second, have you updated the version of the MDAC (Microsoft Data Access Components) installed on your machine? There have probably been a number of iterations between the release of the 8.1.5 and 8.1.6.5 drivers. The README that accompanies your ODBC driver will indicate which MDAC was used in testing. You can grab new versions of the MDAC from Microsoft at <http://www.microsoft.com/data>.

Justin Cave Received on Fri Aug 17 2001 - 22:36:12 CEST