Latest Odbc driver for Ingres.
John Harkin
I'm looking to get/download the latest Odbc driver for Ingres.
I've download the one from their web site which is 2.8 but it appears
to be quite old i.e 1998.
I can only imagine there is a more recent version ( i've heard of a
version 3.50.00.25 ) . Anyone know a download url?
Specially want to use this driver in a Com+ based application using
Odbc for accessing a Ingress 11 2.0/001 all running on windows 2000.
Thanks for all info.
Regards
John
Mike Lay
The 3.5 driver isn't available on its own for reasons that aren't quite
clear to me (there was some mumbling about this at the UK IUA meeting).
It is available on the installation CDs *if* you install INGRES 2.6 on
the client machine (as you do have to to get NET).
Which is a nuisance.
--
Mike Lay - Clinical Trial Service Unit
"I can barely speak for myself, let alone the CTSU"
w: http://www.ctsu.ox.ac.uk/
e: michael dot lay at ctsu (with an ox, an ac, and an uk on the end).
John Harkin
Thanks for this info.
I am correct in saying then to use the latest( or at least more recent
than 2.8) verion of Odbc driver then i must get a copy of Ingres 2.6?
My customer is using Ingres 11 2.0/0001 so i effect we are "stuck"
with version 2.8 of driver?
This seems crazy , as if they don't want the database to be accessed
via Odbc.
Anyone from CA out there?
Regards
John
Mike Lay <ctsu...@herald.ox.ac.uk> wrote in message news:<3F8D56B5...@herald.ox.ac.uk>...
Gerhard Hofmann
> Hi Mike,
> Thanks for this info.
> I am correct in saying then to use the latest( or at least more recent
> than 2.8) verion of Odbc driver then i must get a copy of Ingres 2.6?
> My customer is using Ingres 11 2.0/0001 so i effect we are "stuck"
> with version 2.8 of driver?
> This seems crazy , as if they don't want the database to be accessed
> via Odbc.
> Anyone from CA out there?
>
> Regards
> John
>
>
I think you have mixed up some version numbers. Latest Ingres-ODBC-driver
release can always be found on CA FTP server (web pages may be out of
date!):
ftp://ftp.ca.com/pub/ingres/int_wnt/ODBC/2.8/p7343/
This will update 2.8.x drivers, excerpt from patch.txt:
"This patch updates the Ingres ODBC driver version to 2.80.0072."
You will need an existing installation of Ingres (client) II 2.0 or II 2.5,
unfortunately 2.6 is not mentioned in the release notes.
The version number 3.5.x.y you mention may be the number of the MS Data
Access Components (MDAC). Latest MDAC can be downloaded from
www.microsoft.com/downloads
HTH
Regards
Gerhard
John Harkin
Thanks for this info.
I will certainly download the patch.
Even with this patch it appears to me that this driver has not progressed
much such its release in 1998.
I would have expected a 2.9 , 3.0 etc rather than patches.
Is 2.80.0072 definetly the latest and greatest Odbc driver from Ca?
Also the rel notes states it must be
"The Ingres ODBC driver can only be installed into an existing
Ingres installation. The Ingres installation (client and/or
server) must be one of the following releases:
- Ingres II 2.0/9808 or later for Windows NT.
- Ingres II 2.5 for Windows (32-bit)."
i'm using Ingres 11 2.0/0001 , still ok to install this driver?
Thanks very much for youre time .
Regards
Mike Lay
> Hi Mike,
> Thanks for this info.
> I am correct in saying then to use the latest( or at least more recent
> than 2.8) verion of Odbc driver then i must get a copy of Ingres 2.6?
> My customer is using Ingres 11 2.0/0001 so i effect we are "stuck"
> with version 2.8 of driver?
> This seems crazy , as if they don't want the database to be accessed
> via Odbc.
That is indeed what I am saying - your client installation has to be set
up using ingres 2.6 in order to get the 3.5 driver.
*However* note that there's no reason why your client and server
versions have to be the same. We currently have PCs running XP and
INGRES 2.6 chatting to an Alpha VMS server running INGRES 2.0, and have
experienced no problems that might be attributed to the different versions.
Mike Lay
> I think you have mixed up some version numbers. Latest Ingres-ODBC-driver
> release can always be found on CA FTP server (web pages may be out of
> date!):
> ftp://ftp.ca.com/pub/ingres/int_wnt/ODBC/2.8/p7343/
> This will update 2.8.x drivers, excerpt from patch.txt:
> "This patch updates the Ingres ODBC driver version to 2.80.0072."
> You will need an existing installation of Ingres (client) II 2.0 or II 2.5,
> unfortunately 2.6 is not mentioned in the release notes.
>
> The version number 3.5.x.y you mention may be the number of the MS Data
> Access Components (MDAC). Latest MDAC can be downloaded from
> www.microsoft.com/downloads
Not correct I'm afriad; the version number on the ODBC driver is 3.50,
however this seems to be only available with an INGRES 2.6 client
installation. The download site does still give you the 2.80 version;
this is apparently because they've not rolled out the 3.5 version as a
separate install.
The MDAC version numbers (on my machine at least are 3.520.etc)
Kingsley Idehen
> > Hi,
> > I'm looking to get/download the latest Odbc driver for Ingres.
> > I've download the one from their web site which is 2.8 but it appears
> > to be quite old i.e 1998.
> > I can only imagine there is a more recent version ( i've heard of a
> > version 3.50.00.25 ) . Anyone know a download url?
> > Specially want to use this driver in a Com+ based application using
> > Odbc for accessing a Ingress 11 2.0/001 all running on windows 2000.
>
> The 3.5 driver isn't available on its own for reasons that aren't quite
> clear to me (there was some mumbling about this at the UK IUA meeting).
> It is available on the installation CDs *if* you install INGRES 2.6 on
> the client machine (as you do have to to get NET).
>
> Which is a nuisance.
You do have alternative or at the very worst comparative ODBC Drivers
for Ingres from OpenLink Software. Simply visit:
http://www.openlinksw.com to download a free 30 day evaluation copy.
These Drivers are available in formats that work with or without
Ingres NET.
Kingsley Idehen
OpenLink Software http://www.openlinksw.com/blog/~kidehen
John Harkin
Thanks for all the great info.
So far i've started doing some work with the Ca 2.8 Odbc driver with
patch 7343 in my Com+ based app and find it "unstable" in that it
seems to hang quite a bit and get messages like :
"The XA Transaction Manager attempted to perform recovery with the XA
resource manager. The XA resource manager reported that recovery was
unsuccessful. DSN = CAIIOD32.DLL."
in event log quite alot.
Is the 2.8 with patch 7343 a good driver for Com+?
Is the openlink driver better for Com+ support rather than the above
Ca driver?
Would i better trying to get the latest ( 3.5 ) driver from Ca. It
would be good if they would make this downloadable - anyone from CA
know the status of this?.
Basiaclly whats the best Odbc driver for Com+ based applications?
Regards
John
Mike Lay <ctsu...@herald.ox.ac.uk> wrote in message news:<3F8EB711...@herald.ox.ac.uk>...
> John Harkin wrote:
> > Hi Mike,
> > Thanks for this info.
> > I am correct in saying then to use the latest( or at least more recent
> > than 2.8) verion of Odbc driver then i must get a copy of Ingres 2.6?
> > My customer is using Ingres 11 2.0/0001 so i effect we are "stuck"
> > with version 2.8 of driver?
> > This seems crazy , as if they don't want the database to be accessed
> > via Odbc.
>
> That is indeed what I am saying - your client installation has to be set
> up using ingres 2.6 in order to get the 3.5 driver.
>
> *However* note that there's no reason why your client and server
> versions have to be the same. We currently have PCs running XP and
> INGRES 2.6 chatting to an Alpha VMS server running INGRES 2.0, and have
> experienced no problems that might be attributed to the different versions.
_______________________________________________
Info-ingres mailing list
Info-...@cariboulake.com
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres