RE: Problem with DBI and Access newbie

2001-05-11 Thread Sterin, Ilya
: Re: Problem with DBI and Access newbie Thanks Phil for your help in this. Having implemented the suggested changes I was still getting the same error response: DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. (SQL-S1000)(DBD

Re: Problem with DBI and Access newbie

2001-05-11 Thread Trevor Webster
standard data directory on another partition and hey presto problem solved. Thanks to one and all for your helpful hints. Cheers Trevor - Original Message - From: Philip DiFalco To: [EMAIL PROTECTED] Sent: Friday, May 11, 2001 12:39 AM Subject: RE: Problem with DBI and Access

RE: Problem with DBI and Access newbie

2001-05-10 Thread Sterin, Ilya
Make sure your DSN is not *read only*. Ilya Sterin -Original Message- From: Trevor Webster [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 7:00 PM To: Sterin, Ilya; dbi-users Subject: Re: Problem with DBI and Access newbie Yeah sorry, but I had started preparing the message

Re: Problem with DBI and Access newbie

2001-05-10 Thread Trevor Webster
dbh->prepare($SQL); my $sth = $dbh->prepare($sqlstatement); > $sth-> execute|| > die "Could not execute SQL statement"; > > $myDb->disconnect; > > Looks like you are preparing an empty string $sqlstatement? > > Ilya Sterin > > -Or

RE: Problem with DBI and Access newbie

2001-05-10 Thread Sterin, Ilya
eil Lunn; Sterin, Ilya Sent: 05/10/2001 4:36 AM Subject: Re: Problem with DBI and Access newbie Thank you for the help. I think the problem was the DSN name. Having switched off the response form in the script it was coming back with an error in the dbi->connect line. I shortened the DSN

Re: Problem with DBI and Access newbie

2001-05-10 Thread Trevor Webster
Thank you for the help.  I think the problem was the DSN name.  Having switched off the response form in the script it was coming back with an error in the dbi->connect line.  I shortened the DSN name to a single word.  Having adjusted a couple of syntax errors the script runs to the execute

RE: Problem with DBI and Access newbie

2001-05-10 Thread Bodo Eing
From: Neil Lunn <[EMAIL PROTECTED]> To: "'Sterin, Ilya'" <[EMAIL PROTECTED]>, Neil Lunn <[EMAIL PROTECTED]>, 'Trevor Webster' <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject:

RE: Problem with DBI and Access newbie

2001-05-09 Thread Neil Lunn
> -Original Message- > From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 2:29 PM > To: Neil Lunn; 'Trevor Webster'; [EMAIL PROTECTED] > Subject: RE: Problem with DBI and Access newbie > > > Neil, not that I'm an Acces

RE: Problem with DBI and Access newbie

2001-05-09 Thread Neil Lunn
> -Original Message- > From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 2:26 PM > To: Neil Lunn; 'Trevor Webster'; [EMAIL PROTECTED] > Subject: RE: Problem with DBI and Access newbie > > > >>$SQL = qq|INS

RE: Problem with DBI and Access newbie

2001-05-09 Thread Sterin, Ilya
ECTED]] Sent: Thursday, May 10, 2001 12:11 AM To: 'Trevor Webster'; [EMAIL PROTECTED] Subject: RE: Problem with DBI and Access newbie Missed this before. My eyes hurt! Answer Below. > -Original Message- > From: Trevor Webster [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, M

RE: Problem with DBI and Access newbie

2001-05-09 Thread Sterin, Ilya
orth. $england would interpolate, since it's enclosed in double quotes qq | " ... $england = "test"; print qq/this is just a '$england'/; would print this is just a 'test' Ilya Sterin -Original Message- From: Neil Lunn [mailto:[EMAIL PROTECTED]] Sent

RE: Problem with DBI and Access newbie

2001-05-09 Thread Neil Lunn
Missed this before. My eyes hurt! Answer Below. > -Original Message- > From: Trevor Webster [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 09, 2001 5:03 PM > To: [EMAIL PROTECTED] > Subject: Problem with DBI and Access newbie > > > Hello > > I am running a Perl script that is suppos