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
ge- From: Angel Iliev Kafazov [mailto:angel.kafazov@;mail.bg] Sent: Wednesday, November 13, 2002 1:04 PM To: '[EMAIL PROTECTED]' Subject: accessing ACCESS database Hi, I am trying to write a script that copies an information from ACCESS but it gives me the following error: Can't ca

accessing ACCESS database

2002-11-13 Thread Angel Iliev Kafazov
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"); $db->Sql("SELECT owner_first_na