error "80040e14" need help please

Dear All

Hoping anyone can help, recently moved the site onto a new server, site
started throwing this error up, worked fine before, any clues ?
Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement.

/admin/homes/uhomes.asp, line 52





Where line 52 is:

set cnProps = server.createobject("adodb.connection")
cnProps.Open cnnString
cnProps.Execute sSQL
cnProps.Close
set cnProps = nothing



Thanks



Jez Ward

Re: error "80040e14" need help please

> "Jez" wrote in message
> news:%230EXv18TFHA.3244@TK2MSFTNGP15.phx.gbl...
> Dear All
>
> Hoping anyone can help, recently moved the site onto a new server, site
> started throwing this error up, worked fine before, any clues ?
> Microsoft JET Database Engine error '80040e14'
>
> Syntax error in UPDATE statement.
>
> /admin/homes/uhomes.asp, line 52
>


The relevant source is the contents of sSQL when it is executed.


-Mark





> Where line 52 is:
>
> set cnProps = server.createobject("adodb.connection")
> cnProps.Open cnnString
> cnProps.Execute sSQL
> cnProps.Close
> set cnProps = nothing
>
>
>
> Thanks
>
>
>
> Jez Ward
>
>

Re: error "80040e14" need help please

Jez wrote:
> Dear All
>
> Hoping anyone can help, recently moved the site onto a new server,
> site started throwing this error up, worked fine before, any clues ?

Not without seeing the sql statement you're attempting to run. (I'm not
talking about the vbscript code used to generate the sql statement. Use
response.write to reveal the result of your concatenation)


> set cnProps = server.createobject("adodb.connection")
> cnProps.Open cnnString

on error resume next

> cnProps.Execute sSQL

if err <> 0 then
response.write sSQL
end if

Look at the resulting sql statement, and read the first link below. If the
problemm is still not clear, show us the sql statement as well as the
vbscript code used to create it.

Better yet, stop using dynamic sql:

saved parameter queries:
http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&sel m=e6lLVvOcDHA.1204%40TK2MSFTNGP12.phx.gbl

Using Command object to parameterize CommandText:
http://groups-beta.google.com/group/microsoft.public.inetser ver.asp.db/msg/72e36562fee7804e

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: error "80040e14" need help please

Mark

Would it be relevant that I have moved the site and not the sql database
from my old host, as this worked when the site was with another hosting
company, I can access the sql database but am unsure what to look for,
my database programmer is on holiday so I am trying to work out the
problem myself.

Many thanks for your swift reply

Jez



*** Sent via Developersdex http://www.developersdex.com ***

Re: error "80040e14" need help please

"J W" wrote in message
news:Omt9mJ9TFHA.1384@TK2MSFTNGP09.phx.gbl...
> Mark
>
> Would it be relevant that I have moved the site and not the sql database
> from my old host, as this worked when the site was with another hosting
> company, I can access the sql database but am unsure what to look for,
> my database programmer is on holiday so I am trying to work out the
> problem myself.

It's difficult to estimate the relevance of the move, however, that error is
quite specific as to the locus and nature of the error; it indicates that
there is a problem with th SQL statement that is being executed by the
connection object. To debug, you could try:

Response.Write sSQL
Response.End

just before the line that errors. Without seeing that statement, there's
nowhere left for me to go with it.


-Mark




> Many thanks for your swift reply
>
> Jez
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***