-
Error
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
-
Error (reply)
Jim,
It sure sounds like a reserved word problem. Anyway, do this:
Turn on debug (X.dbDebug=4 or 101) to see what the exact SQL that is trying to execute. Take a close look at it and/or show it to us.
ALSO … Be sure the TableName doesn’t have a "minus sign" in it. such as [RES-FLD-NAMES].
Mark.
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
-
Error (reply)
Checked three times, the reserved listing.
Start ASPdb
Localize3
Localize -1
Enter Get Connection
Test Blank
Grid: Entering
Show Grid: SX, mode, SQL=_111/grid/Select * FROM [Central Iowa Equipment]
mySQL in Get_OrderBY=Select * FROM [Central Iowa Equipment]
tail,p1=/39
heads=Select * FROM [Central Iowa Equipment]/
Show Grid: Sort Name V=
Grid: mySQL Select * FROM [Central Iowa Equipment]
Grid: After get RS - Select * FROM [Central Iowa Equipment]
PT=GridPtr/RecInc/FormPtr=0/5/0
PT right before move = 0
Grid SQL=Select * FROM [Central Iowa Equipment]
Before move (Show Grid) = 5/9/00 9:46:36 AM
Get_RS: Entering mode=dual-horiz
Begin Setfilterinsql, filter=Select * FROM [Central Iowa Equipment]/
Get_RS_get_Count, SQL=Select * FROM [Central Iowa Equipment]/0
Get_RS_GetCount: DBTYPE, SelectFROM,UseRSFilter,ORACLEServer,CountSQL=ACCES S / True / False / /
Construct CountSQL - SELECT COUNT(*) as c FROM [Central Iowa Equipment]
No filter count=1929
Count=1929
Get_RS_OPEN: Entering GET_RS_OPEN
Get_RS_OPEN: mySQL in memory=Select * FROM [Central Iowa Equipment]
Get_RS_OPEN: High speed TOP
TOPSQL,psize=Select TOP 5 * FROM [Central Iowa Equipment]/5
Get_RS_OPEN: TOPSQL, cursor=Select TOP 5 * FROM [Central Iowa Equipment]/0
Get_RS_OPEN: After oRs open Fcount=33
Display=True
DisplayLookUpListSetup-
Get_Form_TrueCnt: TrueCnt=33
Exit Get_RS
After Get_RS
Show Navigation Bar =top
Total Buttons=25
Top Prev Next Filter Canedit=1
Add Update
HeadSelBG, HeadSelFG= BGCOLOR=#FF99FF /#000000
HeadSelBG, HeadSelFG= BGCOLOR=#FF99FF /#000000
HeadSelBG, HeadSelFG= BGCOLOR=#FF99FF /#000000
# PMI Make Model Serial
1 Gateway2000/solo2300 8004696
2 Gateway2000/solo2300 8004697
3 Gateway2000/solo2300 8004700
4 DIGITAL/5000PC KN746PZS99
5 Gateway2000/GP7-550 0018334351
Grid: Leaving, FormPtr=0
Form: Entering SQL = Select * FROM [Central Iowa Equipment]
Form:SQL/FTP=Select * FROM [Central Iowa Equipment]/0
Get_RS: Entering mode=dual-horiz
Begin Setfilterinsql, filter=Select * FROM [Central Iowa Equipment]/
Get_RS_get_Count, SQL=Select * FROM [Central Iowa Equipment]/1929
Get_RS_OPEN: Entering GET_RS_OPEN
Get_RS_OPEN: mySQL in memory=Select * FROM [Central Iowa Equipment]
Get_RS_OPEN: High speed TOP
TOPSQL,psize=Select TOP 1 * FROM [Central Iowa Equipment]/1
Get_RS_OPEN: TOPSQL, cursor=Select TOP 1 * FROM [Central Iowa Equipment]/0
Get_RS_OPEN: After oRs open Fcount=33
Display=True
Get_Form_TrueCnt: TrueCnt=33
Exit Get_RS
Form: Return from Get_RS - UserRs=False
ID 24199
PMI
Make Model Gateway2000/solo2300
Serial 8004696
Purchase Order P71045
Cost
Type of Device PC
Memory
Mouse
Hard Disk Size
Hard Disk Type
Disk Drives
Other
Service Using IRM
Phone
Program Using
Status STORAGE
Building 68
Room 206A
Cable Pair
CMR
Month
Work Station Lap Top
Total 1
Network Address
IP Address
System Using
Serial DB
INV True
Date Installed
Printer
Location Knoxville
Campus Navigation at form bottom - top
Knoxville
Show Status Bar
[1 - 5 : 1929]
------------
Mark at 5/9/00 9:55:49 AM
Jim,
It sure sounds like a reserved word problem. Anyway, do this:
Turn on debug (X.dbDebug=4 or 101) to see what the exact SQL that is trying to execute. Take a close look at it and/or show it to us.
ALSO … Be sure the TableName doesn’t have a "minus sign" in it. such as [RES-FLD-NAMES].
Mark.
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
-
Error (reply)
Jim,
I still don't see the UPDATE SQL in your debug output. Maybe you didn't go far enough. Did you actually click on Update Current Record and get to the error message? BTW "Date Installed" is an illegal field name according to Microsoft. See the list of Reserved Words at:
http://www.aspdb.com/docs/aspdbman.htm#TOC_IVB
The Debug line we are looking for will look something like this:
Edit SQL=UPDATE Employees SET LastName = 'Davolio', FirstName = 'Nancy', Title = 'Sales Representative', TitleOfCourtesy = 'Ms.', BirthDate = #12/8/1962#, HireDate = #5/1/1992#, Address = '507 - 20th Ave. E.Apt. 2Ax', City = 'Seattle', Region = 'WA', PostalCode = '98122', Country = 'USA', HomePhone = '(206) 555-9857', Extension = '5467', Notes = 'Education includes a BA in psychology from Colorado State University in 1970. She also completed "The Art of the Cold Call"', ReportsTo = 5 WHERE EmployeeID = 1
Mark.
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
-
Error (reply)
Thanks for the call Mark, here is the information after selecting update
current record:
Start ASPdb
Localize3
Localize -1
Enter Get Connection
Test Blank
Edit Action=Update Current Record
Entering edit: Update Current Record
f1=, ID = #ID# , PMI = '#PMI#', [Make Model] = '#Make Model#', Serial = '#Serial#', [Purchase Order] = '#Purchase Order#', Cost = #Cost# , [Type of Device] = '#Type of Device#', Memory = '#Memory#', Mouse = '#Mouse#', [Hard Disk Size] = '#Hard Disk Size#', [Hard Disk Type] = '#Hard Disk Type#', [Disk Drives] = '#Disk Drives#', Other = '#Other#', [Service Using] = '#Service Using#', Phone = #Phone# , [Program Using] = '#Program Using#', Status = '#Status#', Building = '#Building#', Room = '#Room#', [Cable Pair] = #Cable Pair# , CMR = '#CMR#', Month = '#Month#', [Work Station] = '#Work Station#', [Network Address] = '#Network Address#', Total = #Total# , [IP Address] = '#IP Address#', [System Using] = '#System Using#', [Serial DB] = '#Serial DB#', INV = #INV# , [Date Installed] = #Date Installed#, Printer = '#Printer#', Location = '#Location#', Campus = '#Campus#',
Update Arg, Field Value=ID|24199|
Update Arg, Field Value=IP Address||
Update Arg, Field Value=INV|True|
Update Arg, Field Value=PMI||
Update Arg, Field Value=Purchase Order|P71045|
Update Arg, Field Value=Cost||
Update Arg, Field Value=Other|testing error|
Update Arg, Field Value=Make Model|Gateway2000/solo2300|
Update Arg, Field Value=Serial|8004696|
Update Arg, Field Value=Disk Drives||
Update Arg, Field Value=Service Using|IRM|
Update Arg, Field Value=Room|206A|
Update Arg, Field Value=Location|Knoxville|
Update Arg, Field Value=Type of Device|PC|
Update Arg, Field Value=Program Using||
Update Arg, Field Value=Campus|Knoxville|
Update Arg, Field Value=aspDBUnit|_111|
Update Arg, Field Value=Memory||
Update Arg, Field Value=Total|1|
Update Arg, Field Value=aspDBClick_111|applyupdate|
Update Arg, Field Value=Mouse||
Update Arg, Field Value=Network Address||
Update Arg, Field Value=System Using||
Update Arg, Field Value=Serial DB||
Update Arg, Field Value=Hard Disk Size||
Update Arg, Field Value=Hard Disk Type||
Update Arg, Field Value=CMR||
Update Arg, Field Value=Printer||
Update Arg, Field Value=Phone||
Update Arg, Field Value=Status|STORAGE|
Update Arg, Field Value=Building|68|
Update Arg, Field Value=Cable Pair||
Update Arg, Field Value=Month||
Update Arg, Field Value=Date Installed||
Update Arg, Field Value=Work Station|Lap Top|
final update f1=, ID = 24199 , PMI = 'Null', [Make Model] = 'Gateway2000/solo2300', Serial = '8004696', [Purchase Order] = 'P71045', Cost = Null , [Type of Device] = 'PC', Memory = 'Null', Mouse = 'Null', [Hard Disk Size] = 'Null', [Hard Disk Type] = 'Null', [Disk Drives] = 'Null', Other = 'testing error', [Service Using] = 'IRM', Phone = Null , [Program Using] = 'Null', Status = 'STORAGE', Building = '68', Room = '206A', [Cable Pair] = Null , CMR = 'Null', Month = 'Null', [Work Station] = 'Lap Top', [Network Address] = 'Null', Total = 1 , [IP Address] = 'Null', [System Using] = 'Null', [Serial DB] = 'Null', INV = #INV# , [Date Installed] = Null, Printer = 'Null', Location = 'Knoxville', Campus = 'Knoxville',
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
End SQL execution
------------
Mark at 5/9/00 11:00:53 AM
Jim,
I still don't see the UPDATE SQL in your debug output. Maybe you didn't go far enough. Did you actually click on Update Current Record and get to the error message? BTW "Date Installed" is an illegal field name according to Microsoft. See the list of Reserved Words at:
http://www.aspdb.com/docs/aspdbman.htm#TOC_IVB
The Debug line we are looking for will look something like this:
Edit SQL=UPDATE Employees SET LastName = 'Davolio', FirstName = 'Nancy', Title = 'Sales Representative', TitleOfCourtesy = 'Ms.', BirthDate = #12/8/1962#, HireDate = #5/1/1992#, Address = '507 - 20th Ave. E.Apt. 2Ax', City = 'Seattle', Region = 'WA', PostalCode = '98122', Country = 'USA', HomePhone = '(206) 555-9857', Extension = '5467', Notes = 'Education includes a BA in psychology from Colorado State University in 1970. She also completed "The Art of the Cold Call"', ReportsTo = 5 WHERE EmployeeID = 1
Mark.
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
-
Error (reply)
Per your instructions, editing one field at a time, received same error
throughout, double checked reserved words against the database, nothing
received this error with debug:
Start ASPdb
Localize3
Localize -1
Enter Get Connection
Test Blank
Edit Action=Update Current Record
Entering edit: Update Current Record
f1=, ID = #ID# , PMI = '#PMI#', Cost = #Cost# , [Type of Device] = '#Type of Device#', Memory = '#Memory#', Mouse = '#Mouse#', [Hard Disk Size] = '#Hard Disk Size#', [Hard Disk Type] = '#Hard Disk Type#', [Disk Drives] = '#Disk Drives#', Other = '#Other#', [Service Using] = '#Service Using#', Phone = '#Phone#', [Program Using] = '#Program Using#', Status = '#Status#', Building = '#Building#', Room = '#Room#', Cable = #Cable# , CMR = '#CMR#', Month = '#Month#', [Work Station] = '#Work Station#', [Network Address] = '#Network Address#', Total = #Total# , [IP Address] = '#IP Address#', [System Using] = '#System Using#', [Serial DB] = '#Serial DB#', INV = #INV# , Installed = #Installed#, Printer = '#Printer#', Location = '#Location#', Campus = '#Campus#',
Update Arg, Field Value=ID|24199|
Update Arg, Field Value=IP Address||
Update Arg, Field Value=INV|True|
Update Arg, Field Value=PMI||
Update Arg, Field Value=Cost|35.00|
Update Arg, Field Value=Other||
Update Arg, Field Value=Installed||
Update Arg, Field Value=Type of Device|PC|
Update Arg, Field Value=Program Using||
Update Arg, Field Value=Campus|Knoxville|
Update Arg, Field Value=aspDBUnit|_111|
Update Arg, Field Value=Memory||
Update Arg, Field Value=Total|1|
Update Arg, Field Value=aspDBClick_111|applyupdate|
Update Arg, Field Value=Mouse||
Update Arg, Field Value=Cable||
Update Arg, Field Value=Network Address||
Update Arg, Field Value=System Using||
Update Arg, Field Value=Serial DB||
Update Arg, Field Value=Hard Disk Size||
Update Arg, Field Value=Hard Disk Type||
Update Arg, Field Value=CMR||
Update Arg, Field Value=Printer||
Update Arg, Field Value=Disk Drives||
Update Arg, Field Value=Service Using|IRM|
Update Arg, Field Value=Room|206A|
Update Arg, Field Value=Location|Knoxville|
Update Arg, Field Value=Phone||
Update Arg, Field Value=Status|STORAGE|
Update Arg, Field Value=Building|68|
Update Arg, Field Value=Month||
Update Arg, Field Value=Work Station|Lap Top|
final update f1=, ID = 24199 , PMI = 'Null', Cost = 35.00 , [Type of Device] = 'PC', Memory = 'Null', Mouse = 'Null', [Hard Disk Size] = 'Null', [Hard Disk Type] = 'Null', [Disk Drives] = 'Null', Other = 'Null', [Service Using] = 'IRM', Phone = 'Null', [Program Using] = 'Null', Status = 'STORAGE', Building = '68', Room = '206A', Cable = Null , CMR = 'Null', Month = 'Null', [Work Station] = 'Lap Top', [Network Address] = 'Null', Total = 1 , [IP Address] = 'Null', [System Using] = 'Null', [Serial DB] = 'Null', INV = #INV# , Installed = Null, Printer = 'Null', Location = 'Knoxville', Campus = 'Knoxville',
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
End SQL execution
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
-
FOUND THE PROBLEM!!!
Mark, I inserted dbRESET right after the SQL statement, and that appears
to have fixed it.
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
-
FOUND THE PROBLEM!!! (reply)
You are right, next and filter do not work well, but doesn't this prove
a point that the reserved list is adhered too, and that this is another
problem?
------------
Jim Presley at 5/9/00 3:05:28 PM
Mark, I inserted dbRESET right after the SQL statement, and that appears
to have fixed it.
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
-
FOUND THE PROBLEM!!! (reply)
Jim,
I don't think we've proved anything yet. I still haven't seen your source code and I would really appreciate it if you could email us a simple asp and mdb file that demonstrates your problem. Also, please set dbDebug=101 and try it again. 101 will dump the exact SQL that was trying to run at the time of the error. You can then copy it off your screen and paste it into an Access Query and let Access try to run it. Access will give you a better clue as to exactly where in the SQL the syntax error is occurring.
Mark.
------------
Jim Presley at 5/9/00 4:35:51 PM
You are right, next and filter do not work well, but doesn't this prove
a point that the reserved list is adhered too, and that this is another
problem?
------------
Jim Presley at 5/9/00 3:05:28 PM
Mark, I inserted dbRESET right after the SQL statement, and that appears
to have fixed it.
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
-
sorry
------------
Mark at 5/9/00 4:46:11 PM
Jim,
I don't think we've proved anything yet. I still haven't seen your source code and I would really appreciate it if you could email us a simple asp and mdb file that demonstrates your problem. Also, please set dbDebug=101 and try it again. 101 will dump the exact SQL that was trying to run at the time of the error. You can then copy it off your screen and paste it into an Access Query and let Access try to run it. Access will give you a better clue as to exactly where in the SQL the syntax error is occurring.
Mark.
------------
Jim Presley at 5/9/00 4:35:51 PM
You are right, next and filter do not work well, but doesn't this prove
a point that the reserved list is adhered too, and that this is another
problem?
------------
Jim Presley at 5/9/00 3:05:28 PM
Mark, I inserted dbRESET right after the SQL statement, and that appears
to have fixed it.
Sorry, got other jobs to do, but here is what dbDebug=101
says:
Edit SQL=UPDATE Central Iowa Equipment SET ID = 1 , PMI = 'Null', Cost = 0 , [Type of Device] = 'PRINTER', Memory = 'Null', Mouse = 'Null', [Hard Disk Size] = 'Null', [Hard Disk Type] = 'Null', [Disk Drives] = 'Null', Other = 'testing error', [Service Using] = 'MHC', Phone = '5807', [Program Using] = 'Null', Status = 'ACTIVE', Building = '1', Room = '233', Cable = 0 , CMR = 'Null', Month = 'Null', [Work Station] = 'Null', [Network Address] = 'Null', Total = 1 , [IP Address] = 'Null', [System Using] = 'Null', Installed = Null, Printer = 'Null', Location = 'DesMoines', Campus = 'DesMoines' WHERE ID = 1
here is a simple asp I used:
<html>
<body>
<%
Set X = Server.CreateObject("ASPdb.Y2K"
X.dbUnit = 141
X.dbMDB="D:InetPubwwwrootIRMdatabase.mdb"
X.dbSQL="Select * FROM [Central Iowa Equipment]"
X.dbMode="Grid"
X.dbNavigationItem="Next,Prev,Add,Update,Delet e,Filter"
X.dbFilterFlds ="Campus,Status,Installed"
X.dbEditParams="TableName=Central Iowa Equipment,BookMarkFlds=0"
X.dbEditFlds="Make Model,Cost,Service Using,Status,Building,Room,Location,Campus"
X.ASPdbY2k
%>
</body>
</html>
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
-
copied Access Db
Mark, I copied the MS Access2000 table that was causing the error, and
then deleted all entries except 9, then updated, this new table
I received no Syntax errors. I reviewed both the table causing the
error and the new table (9 entries), the structure is the same (field names
types, etc.). The only difference I can tell is the number of entries (
9 entries versus 1981 entries)
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
-
Sent E-mail with attachments
Mark, I sent you copies via E-mail
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|