Re: Cannot find DBD::Informix for ActivePerl 5.8.3

Niall wrote: > (This message has already been posted to comp.lang.perl.misc but it was > suggested that I post it here ) > > I have installed the DBI module for ActivePerl5.8.3 and I can now > communicate with my Informix database using the ODBC drivers. > > > i.e , if I run the following code > > > my @drivers = DBI->available_drivers(); > print "\\nThe following DBD-Drivers/Datasources are available:\\n"; > foreach my $driver (@drivers) > { > print "Driver: [$driver]\\n"; > next if $driver =~ /proxy/i; > my @datasources = DBI->data_sources($driver); > foreach my $datasource (@datasources) > { > print "\\t$datasource\\n"; > } > > > > } > > > I can see the following > The following DBD-Drivers/Datasources are available: > Driver: [DBM] > DBI:DBM:f_dir=. > DBI:DBM:f_dir=backup > DBI:DBM:f_dir=Perl Scripts > Driver: [ExampleP] > dbi:ExampleP:dir=. > Driver: [File] > DBI:File:f_dir=. > DBI:File:f_dir=backup > DBI:File:f_dir=Perl Scripts > Driver: [ODBC] > DBI:ODBC:MS Access Database > DBI:ODBC:Excel Files > DBI:ODBC:Visual FoxPro Database > DBI:ODBC:Visual FoxPro Tables > DBI:ODBC:dBASE Files > DBI:ODBC:MQIS > DBI:ODBC:Xtreme Sample Database > DBI:ODBC:new_tktest > DBI:ODBC:ol_histinf > Driver: [Proxy] > Driver: [Sponge] > > The DBI:ODBC:new_tktest and DBI:ODBC:ol_histinf both provide > connections to my informix database. > I have written some simple scripts and verified that I can retrieve > data > > > However , I would like to connect to Informix directly rather than go > via ODBC. When I run ppm and enter the command 'Search DBD' I can see > 87 different drivers , but none relating to Informix . > > > Can anyone suggest how I do this ? Well, the conventional way of obtaining modules on platforms other than Windows is to download the source and build the module. That might or might not work reliably for you - and it does require the necessary infrastructure (MSVC, nmake and Informix CSDK). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/

Thanks for the info Jonathan I am familiar with this method having previously come from a Solaris background but I had a lot of problems building the source for the DBI module downloaded from CPAN on Windows, despite the fact that I have Visual Studio .NET and all of the Informix SDK installed. When I queried this on the comp.lang.perl.misc group it was recommended that I used ppm instead. I will go back to using the CPAN method and try to figure out why it won't build and fix it (hopefully)