Re: Retrieving NULL values from Ingres using SQLPLUS 3.3.2

Hi,

Could you try putting "CommandLine=+jetfix" in the [generic_ingres6] section of the rulebook, oplrqb.ini, and let us know if that helps at all?

Best regards,

Tim Haynes
Support Consultant
OpenLink Software Web: <http://www.openlinksw.co.uk/> Universal Database Connectivity Technology Providers

In article <70216f$ne6$1_at_nnrp1.dejanews.com>,   tthemis_at_my-dejanews.com wrote:
> Hello. I am trying to read data from a Ingres 6.4 database, using Oracle
> SQLPlus 3.3.2, through OpenLink 3.0. Due to the fact that Ingres uses NULL
> and the '' empty string as distinct values, when I quest data from Ingres
> that contains the '' empty string only I get an
>
> OCA-30011: ODBC to Oracle datatype conversion error
>
> I suppose it is like that because Oracle use NULL and '' in a rather similar
> way, both as NULL.
>
> Has anyboby any idea how I can overcome this problem and get those data, from
> SQLPlus ????
>
> Thanks in advance
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 16 1998 - 17:15:33 CEST