Ingres-specific Handle object for perl DBIx

Chris wrote:

> On Jan 22, 3:18 am, Roy Hann wrote:
>> Has anyone out there done any work on an Ingres-specific Handle object
>> for perl DBIx?
>
> Roy,
>
> It sounds like you want a DBD driver, is that what you are looking
> for?
>
> Try http://community.ingres.com/wiki/Perl_DBI as a starting point.
> There are two options on that page.
>
> I would be tempted to take the ODBC option; if you are on Windows this
> comes as part of the install. If you are on a Linux distro you can get
> prebuilt binaries.

Thanks Chris.

As you probably know, DBIx is supposed to be an application development
layer that is claimed to provide a higher level of abstraction than
DBI, and sits on top of DBI.

Unfortunately the package that I am trying to coax into life was written
using DBIx, so I am stuck with it.

The ODBC option is my Plan B. It would be nice to get DBIx working
natively with Ingres though, for aesthetic and propaganda reasons if for
no other.

Since I posted this question Grant Croker has pointed me to Keith
Bolam's work on DBIx for Ingres. I shall encourage Keith to brag about
his victory here, once it is fully working.

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.
 >> Stay informed about: Ingres-specific Handle object for perl DBIx 

On Jan 22, 6:18 am, Roy Hann wrote:
> Has anyone out there done any work on an Ingres-specific Handle object
> for perl DBIx?
>
> --
> Roy
>
> UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
> Go tohttp://www.iua.org.uk/jointo get on the mailing list.

Here's simple connect perl script for your imadb. Love perl - works
great with Ingres. Run our scripts on a Solaris box:

use
strict;
use
DBI;

my $dbh = DBI->connect('dbi:Ingres:imadb') || die "Database connection
not made:

$DBI::errstr";

print "Connected!\n
\n";

print
"Disconnecting ...";
$dbh->disconnect
();
print "Done\n
\n";
 >> Stay informed about: Ingres-specific Handle object for perl DBIx 

wrote:

> On Jan 22, 6:18 am, Roy Hann wrote:
>> Has anyone out there done any work on an Ingres-specific Handle object
>> for perl DBIx?
>
> Here's simple connect perl script for your imadb. Love perl - works
> great with Ingres. Run our scripts on a Solaris box:
>
> use
> strict;
> use
> DBI;
>
> my $dbh = DBI->connect('dbi:Ingres:imadb') || die "Database connection
> not made:
>
> $DBI::errstr";
>
> print "Connected!\n
> \n";
>
> print
> "Disconnecting ...";
> $dbh->disconnect
> ();
> print "Done\n
> \n";

Thanks Jimmy.

I must apologise for not having made it clearer that I was asking about
DBIx (with an "x" on the end), not DBI. However I do have an answer
now, thanks to Grant Croker and Keith Bolam.

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.
 >> Stay informed about: Ingres-specific Handle object for perl DBIx