> Sent: Thursday, November 14, 2002 11:58 AM
> Subject: Re: accessing ACCESS database
>
>
> > Thank you very much for the support. I tried whatever you recommended
> me
> > and I isolated the error in the sql statement. The script connects to
> the
> > database
>finish;
$db->disconnect || die "Cannot disconnect from database";
Douglas Gardiner <[EMAIL PROTECTED]>:
>
> - Original Message -
> From: "Beau E. Cox" <[EMAIL PROTECTED]>
> To: "Angel Iliev Kafazov" <[EMAIL PROTECTED]>
Thank you for correcting me Douglas - I have worked
exclusively with DBI. It's good to learn something new!
Aloha => Beau.
-Original Message-
From: Douglas Gardiner [mailto:dgardiner@;houston.rr.com]
> Hi -
>
> I have never heard of the "Sql" method in DBI. Something like this works:
- Original Message -
From: "Beau E. Cox" <[EMAIL PROTECTED]>
To: "Angel Iliev Kafazov" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 6:55 PM
Subject: RE: accessing ACCESS database
> Hi -
>
> I have never heard
> Hi,
>
> I am trying to write a script that copies an information from
> ACCESS but
> it gives me the following error:
>
> Can't call method "Sql" on an undefined value at
> franowner.pl.txt line 4.
>
> Here's the script:
>
>
> use Win32::ODBC;
> $DSN="db1";
> $db = new Win32::ODBC("db1");
Hi -
I have never heard of the "Sql" method in DBI. Something like this works:
use strict;
use warnings;
use DBI;
my $dbh = DBI->connect("DBI:ODBC:cpan")
|| die "could not connect to ODBC:MyDatabase:\n$DBI::errstr\n";
my $stmt = "select * from modules;";
my $sth = $dbh->prepare($stmt);
