RE: accessing access

2002-11-20 Thread Jerry Preston
Bob, Good find!! Now I need to install ODBC sense it is not found. Thanks, Jerry -Original Message- From: Bob Rasey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 7:50 AM To: [EMAIL PROTECTED] Cc: Beginners Perl Subject: Re: accessing access On Wed, 2002-11-20 at 08

Re: accessing access

2002-11-20 Thread Bob Rasey
On Wed, 2002-11-20 at 08:04, Jerry Preston wrote: > for the code: > > my $dbh = DBI->connect( "dbi::ODBC:pfawtbls.mdb", "", "", ) or die ^ extemporaneous colon, no? Bob Rasey -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional command

RE: accessing access

2002-11-20 Thread Ralph . Carey
t: 20 November 2002 13:18 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: accessing access Ralph, I am running on a SUN Unix system. I have DBI installed, but I guess I am missing this part of it. Regards, Jerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

RE: accessing access

2002-11-20 Thread Jerry Preston
: RE: accessing access Have you set up your ODBC driver via Control Panel (or Computer Management in W2K)? Ralph -Original Message- From: Jerry Preston [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 13:05 To: Beginners Perl Subject: accessing access Hi! I am trying to access an

RE: accessing access

2002-11-20 Thread Ralph . Carey
Have you set up your ODBC driver via Control Panel (or Computer Management in W2K)? Ralph -Original Message- From: Jerry Preston [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 13:05 To: Beginners Perl Subject: accessing access Hi! I am trying to access an access mdb file for the fi

Re: accessing ACCESS database

2002-11-14 Thread Angel Iliev Kafazov
> 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

Re: accessing ACCESS database

2002-11-14 Thread Angel Iliev Kafazov
>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]>

RE: accessing ACCESS database

2002-11-14 Thread Beau E. Cox
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:

Re: accessing ACCESS database

2002-11-13 Thread Douglas Gardiner
- 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

RE: accessing ACCESS database

2002-11-13 Thread Toby Stuart
> 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");

RE: accessing ACCESS database

2002-11-13 Thread Beau E. Cox
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);