: 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
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
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
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
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
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
From: Neil Lunn <[EMAIL PROTECTED]>
To: "'Sterin, Ilya'" <[EMAIL PROTECTED]>,
Neil Lunn <[EMAIL PROTECTED]>,
'Trevor Webster' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject:
> -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
> -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
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
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
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
12 matches
Mail list logo