Re: JET Database errors

From: Rich Palarea (nospam_at_none.com)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 11:42:04 -0400

Kevin:

Thanks for the help.

I checked the sql of the page and it appears to be correct. The WHERE clause
specifies ID, which is my primary key for the database record. All records
in the dB have a value, including the one I'm trying to edit (all attempts
to edit any records in any databases on my server give the same error).

Since all of these sites worked before I migrated them, I thought it was
something on the server. Also, other pages with queries are working fine
(so its not a global.asa or dsn issue).

Since my other sites are now having issues, could it be server-based. I have
a copy of JET Database update 4.0, but I'm not going to install it until I
can figure out what version is on the server and what the issue is. This is
a production server...!

Thanks for any other help you can offer.
Rich

"Kevin Spencer" <uce@ftc.gov> wrote in message
news:%23fD55hXHEHA.3032@TK2MSFTNGP09.phx.gbl...
> The first thing I would check for is a syntax error in the UPDATE
statement.
> In other words, rather than not thinking that it is the ASP page that
> FrontPage created, find out. Note that a syntax error can occcur in a
> DIW-Generated ASP page when certainl form fields are not filled in, and no
> client-side validation is performed. The values from the form are
> concatenated into a SQL string, which, if they are empty, may result in a
> syntax error. Example:
>
> UPDATE myTable SET someNumericColumn = someValue WHERE someTextColumn =
> 'someOtherValue'
>
> if "someValue" is empty, the resulting SQL reads:
>
> UPDATE myTable SET someNumericColumn = WHERE someTextColumn =
> 'someOtherValue'
>
> In the case of text, the single quotes delimiting it will prevent this:
>
> UPDATE myTable SET someNumericColumn = someValue WHERE someTextColumn =
''
>
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Big things are made up
> of lots of little things.
>
> "Rich Palarea" <nospam@none.com> wrote in message
> news:#v4RgKXHEHA.2744@TK2MSFTNGP10.phx.gbl...
> > I've noticed that since moving a number of sites that use the DIW from
> > shared hosting to my dedicated Windwos 2003 server, I get the following
> > error when trying to update records using the DIW:
> >
> > Database Results Error
> > Description: Syntax error in UPDATE statement.
> > Number: -2147217900 (0x80040E14)
> > Source: Microsoft JET Database Engine
> >
> > I don't think the issue resides in the DIW-generated update.asp file,
> since
> > I just used the DIW to create a brand new application and tested the
> > update.asp file. Got the same error.
> >
> > I'm wondering if it has something to do with the way that my Windows
2003
> > server is setup. When I do a Windows Update on the server, I get the
"all
> > clear" and no updates are available.
> >
> > Are there JET database components that reside on the server that need to
> be
> > updated? Am I on the right track?
> >
> > Thanks,
> > Rich
> >
> >
>
>

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
Loading