Useful not on Crystal and Informix ODBC

Posted in 2001

Miles Roper — Tue, 13 Feb 2001 15:06:35 +1300 — source: Informix-list mailing list archive (1991-1998)

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> Hi, Just thought I'd post another useful article on Crystal.  If anyone uses Crystal with Informix ODBC then they may have run across the problem with outer joins.  There is an undocumented feature in the new p2sodbc.dll (included with at least the latest CInfo 7 release) which you need to import into the registry for it to work properly. The full link with all the instructions is below. <A HREF="http://support.seagatesoftware.com/communityCS/FilesAndUpdates/odbcregs.zip.asp">http://support.seagatesoftware.com/communityCS/FilesAndUpdates/odbcregs.zip.asp</A>; All you need to do is add in the driver name, found in the odbc tab, into the reg file.  The one "iclit09b" is one I just added in for Informix ODBC 3.32. Hope someone finds this useful. Cheers Miles REGEDIT4 [HKEY_CURRENT_USER\\Software\\Seagate Software\\Crystal Reports\\DatabaseOptions\\OuterJoin] "Informix"="QEINF506, QEINF507,  qeinf509, qeinf709, crinf506, crinf507, crinf509, crinf709, crinf11, crinf12, ivinf506, ivinf507, ivinf509, ivinf709, ixinf709, generic_inf7, ivinf11, ivinf12, sginf12, iclit09b" "StarEqual"="sqlsrv32, sqlsrvr, qess03, qedbf03, qetxt03, qexls03, crss03, crdbf03, crtxt03, crxls03, qepdx03, QMDBF03, crtxt04, crxls04, crss04, QEIDP06, QEBTR06, crsyb04, crsyb07, crsyb08, crsyb09, crsyb11, crsyb12, SYIQNT, syiqnt, ivtxt12, ivsyb12,crdbm07, crdb207, crdb209, crdb211, crdb212, crxls507, crxls07, crss07, crtxt07, codrv16, _odrv16, codrv32, sysyb, sysybw3, sysyb95, sysybnt, qesyb06, qess07, qess04, qesyb04, qesyb07, gppdx06, qess06, qebtr09, qmdbf06, ivdb212" "Sql2OuterJoin"="wsqlodbc, simba, odbcjt16, odbcjt32, oddp, odtss, osiris, wod40w, wod40t, wod50w, wod50t, vfpodbc, sqrdb, sqrdb32, dmbbx, crwbw, n32odbc, qbodbc, qbodbc32, Blint04, IVOING09, enhodbc3, cwbodbc, db2cli, TDATA32" "PlusEqual"="crora07,cror707,cror709,cror711, cror712, crxql07,  vsorac32, Relativity, crgup07, qeor706, crgup09, crgup11, crgup12, sqora_73, sqo32_73, oplodbc, w32btint, ivor709, lldriver, dhodbc, polite, sqrdb, sqrdb32, ivor711, qmss04, sqora73,sqora7, sqora71, sqora, sqo32_72, ivor712, sgor712, sqora73n" "OJSyntax"="ISCDRV32" "OpenIngres"="oplodbc, oplodb32" "SpecialDll"="simclt32" "PlusJoinDBMS"="oracle" "StarJoinDBMS"="" "Sql2JoinDBMS"="" "AccessDriver"="odbcjt16, odbcjt32, qbodbc, qbodbc32, cwbodbc" "SimbaDriver"="simba" "OpenIngres"="oplodbc, oplodb32"    </html>