Hello,
I have a similar problem to Brad some days ago, but the solution that
worked for him leads to new error messages for me. I am trying to insert
values into an Access database, conc_name and definition are of type
Memo. The error message I get is:
[Microsoft][ODBC Microsoft Access
Ulrike Schmidt wrote:
The error message I get is:
[Microsoft][ODBC Microsoft Access Driver]COUNT-Feld ungültig.
(SQL-07001)(DBD: st_execute/SQLExecute err=-1) at
PerlModule/Database.pm line 110.
This probalby translates to invalid COUNT-field.
Uli
]
erfurt.de cc:
Subject: RE: Quirky problem with
DBI
But don't you have an invalid count? 3 parameters in the SQL (3 question marks)
and onlt 2 bound parameters (two calls to bind_param for params 1 and 2).
Martin
On 18-Sep-2002 Ulrike Schmidt wrote:
Hello,
I have a similar problem to Brad some days ago, but the solution that
worked for
Oops, yes, now everything works fine, thanks a lot! (embarassing ...)
Uli
[EMAIL PROTECTED] wrote:
But don't you have an invalid count? 3 parameters in the SQL (3 question marks)
and onlt 2 bound parameters (two calls to bind_param for params 1 and 2).
Martin
On 18-Sep-2002 Ulrike Schmidt
Scenario:
I am using the following code to update an Access database. The fields
case_notes1...case_notes4 are MEMO fields. Sometimes, I have no
problem whatsoever. Other times, I get the following error:
DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access
Driver]Invalid
Brad,
What version of DBD::ODBC are you using? If you are using DBD::ODBC 0.28
from ActiveState, then I suggest upgrading to the latest (which has a PPM
file at ftp://ftp.esoftmatic.com/pub/outgoing/DBI
Please upgrade your DBI too, as you must use the version I have uploaded
there.
Regards,
Yes, access is sometimes quirky about longs/memos. Try doing this (in
pseudo code) (warning, may wrap long lines):
#!perl -w
# above line makes sure perl is running with warnings.
use strict; # make sure we have strict on to check for dumb typos
use DBI
for you.
Jeff
-Original Message-
From: Brad Smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 09, 2002 8:14 PM
To: Jeff Urlwin
Subject: RE: Quirky problem with DBI
Jeff:
Still, no luck. I have altered the code (below), but it fails with the
following error. PArdon my