On Thu, Jun 26, 2014 at 1:04 AM, Bruce Ferrell <bferr...@baywinds.org>
wrote:
> On 06/25/2014 09:52 PM, Bruce Ferrell wrote:
>
>> On 06/25/2014 07:53 PM, siegfr...@heintze.com wrote:
>>
>>> use DBI;
>>> use strict;
>>> use warnings;
>>> use POSIX;
>>> use CGI qw(:standard);
>>> use CGI::Cookie;
>>> #my $dbh = DBI->connect("dbi:ODBC:driver=microsoft access driver
>>> (*.mdb, *.accdb);dbq=c:\\inetpub\\wwwroot\\Nwind.accdb");
>>> # $dbh->{LongReadLen} = 66000;
>>> # $dbh->{LongTruncOk} = 0;
>>> # my $stmt="SELECT * FROM Customers";
>>> # my $sth = $dbh->prepare($stmt);
>>> # $sth->execute || die "Could not execute SQL statement $stmt ... maybe
>>> invalid?";
>>> my $q =new CGI;
>>> my $ct = strftime "%a %b %d %H:%M:%S %Y\n", localtime;
>>> $q = new CGI; # create new CGI object
>>> print $q->header, # create the HTTP header
>>> $q->start_html('hello world'), # start the HTML
>>> $q->h1("hello world $ct"); # level 1 header
>>>
>>> print $q->end_html; # end the HTML
>>>
>> <snip...>
> One more thing that came up while testing your code... Did you configure
> the ODBC datasource?
Is Microsoft Access installed on the server? DBI will need it to read the
file.
--
Robert Wohlfarth
