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 to http://www.iua.org.uk/join to get on the mailing list.

On Jan 22, 3:18*am, Roy Hann <specia... (AT) processed (DOT) almost.meat> wrote:
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.

Regards,

Chris

Chris wrote:

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.

On Jan 22, 6:18*am, Roy Hann <specia... (AT) processed (DOT) almost.meat> wrote:
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";

jimmythegeek44720 (AT) yahoo (DOT) com wrote:

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.