perl date

------=_NextPart_000_0007_01C7E89F.B29A01B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I am using ODBC to convert an old clipper application to a web based =
application and I came across something seems simple but it's not.

how can I save a date from perl to a date field in dbf file? can a perl =
expert helps out someone who is novice in perl like me? your help would =
be very much appreciated! Thanks.

Samuel

------=_NextPart_000_0007_01C7E89F.B29A01B0--

Re: perl date

Samuel_Zheng a écrit :
> Hi,
>
> I am using ODBC to convert an old clipper application to a web based application and I came across something seems simple but it's not.
>
Hehe sorry at first sight I thought your were looking for a perl date.

Hmm I wonder how much longer we can live without a perl dating site.

Eriam

DBI::Informix and DBD::Informix

Evening All

Anyone know where the DBD::Informix and DBI::Informix packages are located?

Thanks!
Martin--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.

----- Original Message -----
From: "Samuel_Zheng"
To:
Sent: Monday, August 27, 2007 11:44 AM
Subject: perl date


Hi,

I am using ODBC to convert an old clipper application to a web based
application and I came across something seems simple but it's not.

how can I save a date from perl to a date field in dbf file? can a perl
expert helps out someone who is novice in perl like me? your help would be
very much appreciated! Thanks.

Samuel

Fwd: DBI::Informix and DBD::Informix

Oops - omitted dbi-users; sorry.

---------- Forwarded message ----------
From: Jonathan Leffler
Date: Aug 27, 2007 6:43 PM
Subject: Re: DBI::Informix and DBD::Informix
To: Martin Gainty


On 8/27/07, Martin Gainty wrote:
> Anyone know where the DBD::Informix and DBI::Informix packages are located?

DBD::Informix is located on CPAN, as usual.

There is no DBI::Informix package that I know of.

I suspect that your question means that you are running on Windows,
rather than Unix, and using ActiveState Perl, and are wanting a PPM
for DBD::Informix on Windows.

Sadly, I have not yet got DBD::Informix running on Windows - partly
for lack of motivation, partly for lack of time. So, there is no PPM
available. Various people at various times have reported various
issues; due to the lack of a test environment, I've not tested it
recently (meaning in the last 5+ years). Fundamentally, it hasn't
been enough of an itch for me to be particularly interested in
scratching it - which may or may not be wholly a good idea, but I'm
only a volunteeer when it comes to doing DBD::Informix (I'm not
specifically paid by IBM or anyone else to do it).

I'm hoping to do some testing on Windows between now and the end of
the year (hoping means that - no promises). If anyone needs it sooner
than that, they'll have to provide some round tuits.

--
Jonathan Leffler #include
Guardian of DBD::Informix - v2007.0826 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."

If you're not familiar with 'Round Tuits', Google is your friend.


--
Jonathan Leffler #include
Guardian of DBD::Informix - v2007.0826 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."

Re: DBI::Informix and DBD::Informix

On 8/27/07, Martin Gainty wrote:
> ActiveStates answer for windows is
> ;extension=php_ifx.dll
> which of course does not load and therefore doesnt work

I wouldn't really expect a PHP extension to work with Perl. You
shouldn't either.

> Havent seen anything from IBM which is disappointing since Informix is their
> product

Fair enough - discuss with your IBM sales rep. If I get tasked with
it formally, I'll do it - assuming that time is allocated too. If
not, it will happen on my (non-urgent) schedule.

Amongst other things, I use Cygwin on Windows - and AFAIK, CSDK does
not support that (despite my putting in a request for ESQL/C to
support GCC out of the box several years ago - not being a customer, I
don't have much clout). So, to get things to work on Windows, I have
to get a MSVC compiler that will do the job. There may be
sufficiently good freebies from MS for my purposes - but it just adds
to the complexity of the job. "Cobbler's Children" springs to mind as
an epithet - so does "over-worked, under-paid".

> >From: "Jonathan Leffler"
> >
> >On 8/27/07, Martin Gainty wrote:
> > > Anyone know where the DBD::Informix and DBI::Informix packages are
> >located?
> >
> >DBD::Informix is located on CPAN, as usual.
> >
> >There is no DBI::Informix package that I know of.
> >
> >I suspect that your question means that you are running on Windows,
> >rather than Unix, and using ActiveState Perl, and are wanting a PPM
> >for DBD::Informix on Windows.
> >
> >Sadly, I have not yet got DBD::Informix running on Windows - partly
> >for lack of motivation, partly for lack of time. So, there is no PPM
> >available. Various people at various times have reported various
> >issues; due to the lack of a test environment, I've not tested it
> >recently (meaning in the last 5+ years). Fundamentally, it hasn't
> >been enough of an itch for me to be particularly interested in
> >scratching it - which may or may not be wholly a good idea, but I'm
> >only a volunteeer when it comes to doing DBD::Informix (I'm not
> >specifically paid by IBM or anyone else to do it).
> >
> >I'm hoping to do some testing on Windows between now and the end of
> >the year (hoping means that - no promises). If anyone needs it sooner
> >than that, they'll have to provide some round tuits.

--
Jonathan Leffler #include
Guardian of DBD::Informix - v2007.0826 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."

Re: perl date

Thank you Nelson for your response. Please cut and paste your codes and so I
can try them, or how can I get YYYY
MM and DD? What is the function to convert a string to a numeric? Do I need
this function? Thank you for the help!

----- Original Message -----
From: "Nelson, Erick [HDS]"
To: "Samuel_Zheng" ;
Sent: Monday, August 27, 2007 11:51 AM
Subject: RE: perl date


I've created dbf files using DBD::XBase a few times.
To get dates to insert correctly I had to have the date in YYYYMMDD
format.
DBD::Xbase writes dbase 4 files.
If Clipper is old enough that it is using dbase 3 files the answer might
be different.

-----Original Message-----
From: Samuel_Zheng [mailto:samuel_zheng@keunghing.com]
Sent: Monday, August 27, 2007 8:45 AM
To: dbi-users@perl.org
Subject: perl date

Hi,

I am using ODBC to convert an old clipper application to a web based
application and I came across something seems simple but it's not.

how can I save a date from perl to a date field in dbf file? can a perl
expert helps out someone who is novice in perl like me? your help would
be very much appreciated! Thanks.

Samuel

__________ NOD32 2489 (20070828) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk

Re: perl date

Hi Nelson,
Thanks for the codes. Please forgive my ignoracne, but how to update a date
field in dbf ? thanks again.
Samuel
----- Original Message -----
From: "Nelson, Erick [HDS]"
To: "Samuel_Zheng"
Sent: Tuesday, August 28, 2007 6:43 PM
Subject: RE: perl date


use strict;
use warnings;
use DBI;
use DBD::XBase;
use DBU;

my $xbase_dbh = DBI->connect("DBI:XBase:.", undef, undef, {RaiseError =>
1});
my $oracle_dbh = DBI->connect(DBU::connect('mwh'));

my $create_table = < create table sample (
id int,
dt date
)
EOT

unlink 'sample.dbf';

$xbase_dbh->do($create_table);

my $sel = "select 1, to_char(sysdate,'YYYYMMDD') dt from dual";
my $sel_csr = $oracle_dbh->prepare($sel);

my $ins = "insert into sample (id, dt) values (?,?)";
my $ins_csr = $xbase_dbh->prepare($ins);

$sel_csr->execute();
while (my ($id, $dt) = $sel_csr->fetchrow_array()) {
$ins_csr->execute($id, $dt);
}

$xbase_dbh->disconnect();
$oracle_dbh->disconnect();

-----Original Message-----
From: Samuel_Zheng [mailto:samuel_zheng@keunghing.com]
Sent: Tuesday, August 28, 2007 3:30 PM
To: Nelson, Erick [HDS]; dbi-users@perl.org
Subject: Re: perl date

Thank you Nelson for your response. Please cut and paste your codes and
so I
can try them, or how can I get YYYY
MM and DD? What is the function to convert a string to a numeric? Do I
need
this function? Thank you for the help!

----- Original Message -----
From: "Nelson, Erick [HDS]"
To: "Samuel_Zheng" ;
Sent: Monday, August 27, 2007 11:51 AM
Subject: RE: perl date


I've created dbf files using DBD::XBase a few times.
To get dates to insert correctly I had to have the date in YYYYMMDD
format.
DBD::Xbase writes dbase 4 files.
If Clipper is old enough that it is using dbase 3 files the answer might
be different.

-----Original Message-----
From: Samuel_Zheng [mailto:samuel_zheng@keunghing.com]
Sent: Monday, August 27, 2007 8:45 AM
To: dbi-users@perl.org
Subject: perl date

Hi,

I am using ODBC to convert an old clipper application to a web based
application and I came across something seems simple but it's not.

how can I save a date from perl to a date field in dbf file? can a perl
expert helps out someone who is novice in perl like me? your help would
be very much appreciated! Thanks.

Samuel

__________ NOD32 2489 (20070828) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk


__________ NOD32 2489 (20070828) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk

RE: DBI::Informix and DBD::Informix

FYI...

While Jonathan doesn't support DBD::Informix on Windows, I have been
able to take his source and build a Windows version that works with
ActiveState Perl. For two different versions if DBD::Informix, the most
recent version being 200502. So it is possible, but requires the proper
windows tools, plus figuring out the numerous tweaks and changes to the
build scripts and source files. The details have been posted to this
mailing list in the past.

=20

-----Original Message-----
From: Jonathan Leffler [mailto:jonathan.leffler@gmail.com]=20
Sent: Monday, August 27, 2007 7:16 PM
To: DBI Users Mailing List
Subject: Fwd: DBI::Informix and DBD::Informix

Oops - omitted dbi-users; sorry.

---------- Forwarded message ----------
From: Jonathan Leffler
Date: Aug 27, 2007 6:43 PM
Subject: Re: DBI::Informix and DBD::Informix
To: Martin Gainty


On 8/27/07, Martin Gainty wrote:
> Anyone know where the DBD::Informix and DBI::Informix packages are
located?

DBD::Informix is located on CPAN, as usual.

There is no DBI::Informix package that I know of.

I suspect that your question means that you are running on Windows,
rather than Unix, and using ActiveState Perl, and are wanting a PPM for
DBD::Informix on Windows.

Sadly, I have not yet got DBD::Informix running on Windows - partly for
lack of motivation, partly for lack of time. So, there is no PPM
available. Various people at various times have reported various
issues; due to the lack of a test environment, I've not tested it
recently (meaning in the last 5+ years). Fundamentally, it hasn't been
enough of an itch for me to be particularly interested in scratching it
- which may or may not be wholly a good idea, but I'm only a volunteeer
when it comes to doing DBD::Informix (I'm not specifically paid by IBM
or anyone else to do it).

I'm hoping to do some testing on Windows between now and the end of the
year (hoping means that - no promises). If anyone needs it sooner than
that, they'll have to provide some round tuits.

--
Jonathan Leffler #include
Guardian of DBD::Informix - v2007.0826 - http://dbi.perl.org "Blessed
are we who can laugh at ourselves, for we shall never cease to be
amused."

If you're not familiar with 'Round Tuits', Google is your friend.


--
Jonathan Leffler #include
Guardian of DBD::Informix - v2007.0826 - http://dbi.perl.org "Blessed
are we who can laugh at ourselves, for we shall never cease to be
amused."

Re: perl date

thank you so much for your help! I plan using the code for updating a date
field only while using ODBC for the rest. (with in mind of an upgrade of
DBMS later) Is there anything that anyone knows that I should pay attention
to? thanks


regards,
Samuel

----- Original Message -----
From: "Nelson, Erick [HDS]"
To: "Samuel_Zheng"
Sent: Wednesday, August 29, 2007 11:53 AM
Subject: RE: perl date


erickn@isfe:/home/erickn> perl test.pl
1 = 20071202

erickn@isfe:/home/erickn> cat test.pl

use strict;
use warnings;
use DBI;
use DBD::XBase;

my $xbase_dbh = DBI->connect("DBI:XBase:.", undef, undef, {RaiseError =>
1});

my $upd = "update sample set dt = ? where id = ?";
my $upd_csr = $xbase_dbh->prepare($upd);

my $sel = "select id, dt from sample";
my $sel_csr = $xbase_dbh->prepare($sel);

$upd_csr->execute('20071202', 1);

$sel_csr->execute();
while (my ($id, $dt) = $sel_csr->fetchrow_array()) {
print "$id = $dt\n";
}

$xbase_dbh->disconnect();

-----Original Message-----
From: Samuel_Zheng [mailto:samuel_zheng@keunghing.com]
Sent: Wednesday, August 29, 2007 2:30 AM
To: Nelson, Erick [HDS]; dbi-users@perl.org
Subject: Re: perl date

Hi Nelson,
Thanks for the codes. Please forgive my ignoracne, but how to update a
date
field in dbf ? thanks again.
Samuel
----- Original Message -----
From: "Nelson, Erick [HDS]"
To: "Samuel_Zheng"
Sent: Tuesday, August 28, 2007 6:43 PM
Subject: RE: perl date


use strict;
use warnings;
use DBI;
use DBD::XBase;
use DBU;

my $xbase_dbh = DBI->connect("DBI:XBase:.", undef, undef, {RaiseError =>
1});
my $oracle_dbh = DBI->connect(DBU::connect('mwh'));

my $create_table = < create table sample (
id int,
dt date
)
EOT

unlink 'sample.dbf';

$xbase_dbh->do($create_table);

my $sel = "select 1, to_char(sysdate,'YYYYMMDD') dt from dual";
my $sel_csr = $oracle_dbh->prepare($sel);

my $ins = "insert into sample (id, dt) values (?,?)";
my $ins_csr = $xbase_dbh->prepare($ins);

$sel_csr->execute();
while (my ($id, $dt) = $sel_csr->fetchrow_array()) {
$ins_csr->execute($id, $dt);
}

$xbase_dbh->disconnect();
$oracle_dbh->disconnect();

-----Original Message-----
From: Samuel_Zheng [mailto:samuel_zheng@keunghing.com]
Sent: Tuesday, August 28, 2007 3:30 PM
To: Nelson, Erick [HDS]; dbi-users@perl.org
Subject: Re: perl date

Thank you Nelson for your response. Please cut and paste your codes and
so I
can try them, or how can I get YYYY
MM and DD? What is the function to convert a string to a numeric? Do I
need
this function? Thank you for the help!

----- Original Message -----
From: "Nelson, Erick [HDS]"
To: "Samuel_Zheng" ;
Sent: Monday, August 27, 2007 11:51 AM
Subject: RE: perl date


I've created dbf files using DBD::XBase a few times.
To get dates to insert correctly I had to have the date in YYYYMMDD
format.
DBD::Xbase writes dbase 4 files.
If Clipper is old enough that it is using dbase 3 files the answer might
be different.

-----Original Message-----
From: Samuel_Zheng [mailto:samuel_zheng@keunghing.com]
Sent: Monday, August 27, 2007 8:45 AM
To: dbi-users@perl.org
Subject: perl date

Hi,

I am using ODBC to convert an old clipper application to a web based
application and I came across something seems simple but it's not.

how can I save a date from perl to a date field in dbf file? can a perl
expert helps out someone who is novice in perl like me? your help would
be very much appreciated! Thanks.

Samuel

__________ NOD32 2489 (20070828) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk


__________ NOD32 2489 (20070828) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk


__________ NOD32 2490 (20070829) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk

Re: perl date

Hi Nelson,
Thank you for your help! Just one more question: if I specify the directory
name (location) of the file,e.g.:
c:/sample
it won't run. Is there a way I can specify the location of the dbf?
Regards,
Samuel

----- Original Message -----
From: "Nelson, Erick [HDS]"
To: "Samuel_Zheng"
Sent: Wednesday, August 29, 2007 11:53 AM
Subject: RE: perl date


erickn@isfe:/home/erickn> perl test.pl
1 = 20071202

erickn@isfe:/home/erickn> cat test.pl

use strict;
use warnings;
use DBI;
use DBD::XBase;

my $xbase_dbh = DBI->connect("DBI:XBase:.", undef, undef, {RaiseError =>
1});

my $upd = "update sample set dt = ? where id = ?";
my $upd_csr = $xbase_dbh->prepare($upd);

my $sel = "select id, dt from sample";
my $sel_csr = $xbase_dbh->prepare($sel);

$upd_csr->execute('20071202', 1);

$sel_csr->execute();
while (my ($id, $dt) = $sel_csr->fetchrow_array()) {
print "$id = $dt\n";
}

$xbase_dbh->disconnect();

-----Original Message-----
From: Samuel_Zheng [mailto:samuel_zheng@keunghing.com]
Sent: Wednesday, August 29, 2007 2:30 AM
To: Nelson, Erick [HDS]; dbi-users@perl.org
Subject: Re: perl date

Hi Nelson,
Thanks for the codes. Please forgive my ignoracne, but how to update a
date
field in dbf ? thanks again.
Samuel
----- Original Message -----
From: "Nelson, Erick [HDS]"
To: "Samuel_Zheng"
Sent: Tuesday, August 28, 2007 6:43 PM
Subject: RE: perl date


use strict;
use warnings;
use DBI;
use DBD::XBase;
use DBU;

my $xbase_dbh = DBI->connect("DBI:XBase:.", undef, undef, {RaiseError =>
1});
my $oracle_dbh = DBI->connect(DBU::connect('mwh'));

my $create_table = < create table sample (
id int,
dt date
)
EOT

unlink 'sample.dbf';

$xbase_dbh->do($create_table);

my $sel = "select 1, to_char(sysdate,'YYYYMMDD') dt from dual";
my $sel_csr = $oracle_dbh->prepare($sel);

my $ins = "insert into sample (id, dt) values (?,?)";
my $ins_csr = $xbase_dbh->prepare($ins);

$sel_csr->execute();
while (my ($id, $dt) = $sel_csr->fetchrow_array()) {
$ins_csr->execute($id, $dt);
}

$xbase_dbh->disconnect();
$oracle_dbh->disconnect();

-----Original Message-----
From: Samuel_Zheng [mailto:samuel_zheng@keunghing.com]
Sent: Tuesday, August 28, 2007 3:30 PM
To: Nelson, Erick [HDS]; dbi-users@perl.org
Subject: Re: perl date

Thank you Nelson for your response. Please cut and paste your codes and
so I
can try them, or how can I get YYYY
MM and DD? What is the function to convert a string to a numeric? Do I
need
this function? Thank you for the help!

----- Original Message -----
From: "Nelson, Erick [HDS]"
To: "Samuel_Zheng" ;
Sent: Monday, August 27, 2007 11:51 AM
Subject: RE: perl date


I've created dbf files using DBD::XBase a few times.
To get dates to insert correctly I had to have the date in YYYYMMDD
format.
DBD::Xbase writes dbase 4 files.
If Clipper is old enough that it is using dbase 3 files the answer might
be different.

-----Original Message-----
From: Samuel_Zheng [mailto:samuel_zheng@keunghing.com]
Sent: Monday, August 27, 2007 8:45 AM
To: dbi-users@perl.org
Subject: perl date

Hi,

I am using ODBC to convert an old clipper application to a web based
application and I came across something seems simple but it's not.

how can I save a date from perl to a date field in dbf file? can a perl
expert helps out someone who is novice in perl like me? your help would
be very much appreciated! Thanks.

Samuel

__________ NOD32 2489 (20070828) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk


__________ NOD32 2489 (20070828) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk


__________ NOD32 2490 (20070829) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk

Re: perl date

I see now the file location should be specify after DBI:XBase:,
not in front of the file name. Thank you.

Samuel

----- Original Message -----
From: "Nelson, Erick [HDS]"
To: "Samuel_Zheng"
Sent: Wednesday, August 29, 2007 11:53 AM
Subject: RE: perl date


erickn@isfe:/home/erickn> perl test.pl
1 = 20071202

erickn@isfe:/home/erickn> cat test.pl

use strict;
use warnings;
use DBI;
use DBD::XBase;

my $xbase_dbh = DBI->connect("DBI:XBase:.", undef, undef, {RaiseError =>
1});

my $upd = "update sample set dt = ? where id = ?";
my $upd_csr = $xbase_dbh->prepare($upd);

my $sel = "select id, dt from sample";
my $sel_csr = $xbase_dbh->prepare($sel);

$upd_csr->execute('20071202', 1);

$sel_csr->execute();
while (my ($id, $dt) = $sel_csr->fetchrow_array()) {
print "$id = $dt\n";
}

$xbase_dbh->disconnect();

-----Original Message-----
From: Samuel_Zheng [mailto:samuel_zheng@keunghing.com]
Sent: Wednesday, August 29, 2007 2:30 AM
To: Nelson, Erick [HDS]; dbi-users@perl.org
Subject: Re: perl date

Hi Nelson,
Thanks for the codes. Please forgive my ignoracne, but how to update a
date
field in dbf ? thanks again.
Samuel
----- Original Message -----
From: "Nelson, Erick [HDS]"
To: "Samuel_Zheng"
Sent: Tuesday, August 28, 2007 6:43 PM
Subject: RE: perl date


use strict;
use warnings;
use DBI;
use DBD::XBase;
use DBU;

my $xbase_dbh = DBI->connect("DBI:XBase:.", undef, undef, {RaiseError =>
1});
my $oracle_dbh = DBI->connect(DBU::connect('mwh'));

my $create_table = < create table sample (
id int,
dt date
)
EOT

unlink 'sample.dbf';

$xbase_dbh->do($create_table);

my $sel = "select 1, to_char(sysdate,'YYYYMMDD') dt from dual";
my $sel_csr = $oracle_dbh->prepare($sel);

my $ins = "insert into sample (id, dt) values (?,?)";
my $ins_csr = $xbase_dbh->prepare($ins);

$sel_csr->execute();
while (my ($id, $dt) = $sel_csr->fetchrow_array()) {
$ins_csr->execute($id, $dt);
}

$xbase_dbh->disconnect();
$oracle_dbh->disconnect();

-----Original Message-----
From: Samuel_Zheng [mailto:samuel_zheng@keunghing.com]
Sent: Tuesday, August 28, 2007 3:30 PM
To: Nelson, Erick [HDS]; dbi-users@perl.org
Subject: Re: perl date

Thank you Nelson for your response. Please cut and paste your codes and
so I
can try them, or how can I get YYYY
MM and DD? What is the function to convert a string to a numeric? Do I
need
this function? Thank you for the help!

----- Original Message -----
From: "Nelson, Erick [HDS]"
To: "Samuel_Zheng" ;
Sent: Monday, August 27, 2007 11:51 AM
Subject: RE: perl date


I've created dbf files using DBD::XBase a few times.
To get dates to insert correctly I had to have the date in YYYYMMDD
format.
DBD::Xbase writes dbase 4 files.
If Clipper is old enough that it is using dbase 3 files the answer might
be different.

-----Original Message-----
From: Samuel_Zheng [mailto:samuel_zheng@keunghing.com]
Sent: Monday, August 27, 2007 8:45 AM
To: dbi-users@perl.org
Subject: perl date

Hi,

I am using ODBC to convert an old clipper application to a web based
application and I came across something seems simple but it's not.

how can I save a date from perl to a date field in dbf file? can a perl
expert helps out someone who is novice in perl like me? your help would
be very much appreciated! Thanks.

Samuel

__________ NOD32 2489 (20070828) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk


__________ NOD32 2489 (20070828) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk


__________ NOD32 2490 (20070829) Information __________

This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk

Re: DBI::Informix and DBD::Informix

Hi Brian

Is there a URL where I can download the driver?

for some reason I could'nt get ahold of any of the other supposedly working
DLLs..

Thanks!
Martin
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.

----- Original Message -----
From: "CAMPBELL, BRIAN D (BRIAN)"
To: "Jonathan Leffler" ; "DBI Users Mailing
List"
Sent: Wednesday, August 29, 2007 3:38 PM
Subject: RE: DBI::Informix and DBD::Informix


FYI...

While Jonathan doesn't support DBD::Informix on Windows, I have been
able to take his source and build a Windows version that works with
ActiveState Perl. For two different versions if DBD::Informix, the most
recent version being 200502. So it is possible, but requires the proper
windows tools, plus figuring out the numerous tweaks and changes to the
build scripts and source files. The details have been posted to this
mailing list in the past.



-----Original Message-----
From: Jonathan Leffler [mailto:jonathan.leffler@gmail.com]
Sent: Monday, August 27, 2007 7:16 PM
To: DBI Users Mailing List
Subject: Fwd: DBI::Informix and DBD::Informix

Oops - omitted dbi-users; sorry.

---------- Forwarded message ----------
From: Jonathan Leffler
Date: Aug 27, 2007 6:43 PM
Subject: Re: DBI::Informix and DBD::Informix
To: Martin Gainty


On 8/27/07, Martin Gainty wrote:
> Anyone know where the DBD::Informix and DBI::Informix packages are
located?

DBD::Informix is located on CPAN, as usual.

There is no DBI::Informix package that I know of.

I suspect that your question means that you are running on Windows,
rather than Unix, and using ActiveState Perl, and are wanting a PPM for
DBD::Informix on Windows.

Sadly, I have not yet got DBD::Informix running on Windows - partly for
lack of motivation, partly for lack of time. So, there is no PPM
available. Various people at various times have reported various
issues; due to the lack of a test environment, I've not tested it
recently (meaning in the last 5+ years). Fundamentally, it hasn't been
enough of an itch for me to be particularly interested in scratching it
- which may or may not be wholly a good idea, but I'm only a volunteeer
when it comes to doing DBD::Informix (I'm not specifically paid by IBM
or anyone else to do it).

I'm hoping to do some testing on Windows between now and the end of the
year (hoping means that - no promises). If anyone needs it sooner than
that, they'll have to provide some round tuits.

--
Jonathan Leffler #include
Guardian of DBD::Informix - v2007.0826 - http://dbi.perl.org "Blessed
are we who can laugh at ourselves, for we shall never cease to be
amused."

If you're not familiar with 'Round Tuits', Google is your friend.


--
Jonathan Leffler #include
Guardian of DBD::Informix - v2007.0826 - http://dbi.perl.org "Blessed
are we who can laugh at ourselves, for we shall never cease to be
amused."

RE: DBI::Informix and DBD::Informix

The answer is no, not presently. At least with regard with anything I
have produced.

So I will anticipate your next question. Could it be made available?

I suppose, maybe. But in what form? Presently for use within our work
group, I just have some files and directories (i.e. folders) that you
drop into "C:\Perl\site\lib". =20

What's the best way to make this available? What issues do I need to
consider?

-----Original Message-----
From: Martin Gainty [mailto:mgainty@hotmail.com]=20
Sent: Friday, August 31, 2007 6:13 PM
To: CAMPBELL, BRIAN D (BRIAN); Jonathan Leffler; DBI Users Mailing List
Subject: Re: DBI::Informix and DBD::Informix

Hi Brian

Is there a URL where I can download the driver?

for some reason I could'nt get ahold of any of the other supposedly
working DLLs..

Thanks!
Martin
This email message and any files transmitted with it contain
confidential information intended only for the person(s) to whom this
email message is addressed. If you have received this email message in
error, please notify the sender immediately by telephone or email and
destroy the original message without making a copy. Thank you.

----- Original Message -----
From: "CAMPBELL, BRIAN D (BRIAN)"
To: "Jonathan Leffler" ; "DBI Users Mailing
List"
Sent: Wednesday, August 29, 2007 3:38 PM
Subject: RE: DBI::Informix and DBD::Informix


FYI...

While Jonathan doesn't support DBD::Informix on Windows, I have been
able to take his source and build a Windows version that works with
ActiveState Perl. For two different versions if DBD::Informix, the most
recent version being 200502. So it is possible, but requires the proper
windows tools, plus figuring out the numerous tweaks and changes to the
build scripts and source files. The details have been posted to this
mailing list in the past.



-----Original Message-----
From: Jonathan Leffler [mailto:jonathan.leffler@gmail.com]
Sent: Monday, August 27, 2007 7:16 PM
To: DBI Users Mailing List
Subject: Fwd: DBI::Informix and DBD::Informix

Oops - omitted dbi-users; sorry.

---------- Forwarded message ----------
From: Jonathan Leffler
Date: Aug 27, 2007 6:43 PM
Subject: Re: DBI::Informix and DBD::Informix
To: Martin Gainty


On 8/27/07, Martin Gainty wrote:
> Anyone know where the DBD::Informix and DBI::Informix packages are
located?

DBD::Informix is located on CPAN, as usual.

There is no DBI::Informix package that I know of.

I suspect that your question means that you are running on Windows,
rather than Unix, and using ActiveState Perl, and are wanting a PPM for
DBD::Informix on Windows.

Sadly, I have not yet got DBD::Informix running on Windows - partly for
lack of motivation, partly for lack of time. So, there is no PPM
available. Various people at various times have reported various
issues; due to the lack of a test environment, I've not tested it
recently (meaning in the last 5+ years). Fundamentally, it hasn't been
enough of an itch for me to be particularly interested in scratching it
- which may or may not be wholly a good idea, but I'm only a volunteeer
when it comes to doing DBD::Informix (I'm not specifically paid by IBM
or anyone else to do it).

I'm hoping to do some testing on Windows between now and the end of the
year (hoping means that - no promises). If anyone needs it sooner than
that, they'll have to provide some round tuits.

--
Jonathan Leffler #include
Guardian of DBD::Informix - v2007.0826 - http://dbi.perl.org "Blessed
are we who can laugh at ourselves, for we shall never cease to be
amused."

If you're not familiar with 'Round Tuits', Google is your friend.


--
Jonathan Leffler #include
Guardian of DBD::Informix - v2007.0826 - http://dbi.perl.org "Blessed
are we who can laugh at ourselves, for we shall never cease to be
amused."