G
Guest
I have built a database editor using the database interface wizard. However,
when I attempt to use the editor I get a database results error. I
re-entered the database results section of update.asp (which was built by the
database interface wizard) and attempted to verify the query and got the
following message
Server error: Unable to retrieve schema information from the query:
UPDATE Events SET Event = '1' , EventSeries = '2' , EventType = '3' ,
Headliner = '4' , Supporting = '5' , Venue = '6' , Date = '7' , Time = '8' ,
MoreInfoOnEvent = '9' , TicketsRequired = '10' , AdmissionFee = '11' ,
TicketsInfo = '12' , VenueDataSource = '13' , ProgramSummary = '14' WHERE
(ID = 15)
against a database using the connection s
The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)
I have two other database editors running against different tables in the
same access database and they all run add/change/delete without problems.
The database editor works for add/delete in this particular table, but the
change capability does not seem to work for some reason. There have been no
changes to the code generated by the database interface wizard except to flag
the field id as autonumber (it is the primary key).
I have contacted my server host and they tell me that everything is
correctly configured on their end.
Can anyone point me in the right direction to resolve this problem?
when I attempt to use the editor I get a database results error. I
re-entered the database results section of update.asp (which was built by the
database interface wizard) and attempted to verify the query and got the
following message
Server error: Unable to retrieve schema information from the query:
UPDATE Events SET Event = '1' , EventSeries = '2' , EventType = '3' ,
Headliner = '4' , Supporting = '5' , Venue = '6' , Date = '7' , Time = '8' ,
MoreInfoOnEvent = '9' , TicketsRequired = '10' , AdmissionFee = '11' ,
TicketsInfo = '12' , VenueDataSource = '13' , ProgramSummary = '14' WHERE
(ID = 15)
against a database using the connection s
The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)
I have two other database editors running against different tables in the
same access database and they all run add/change/delete without problems.
The database editor works for add/delete in this particular table, but the
change capability does not seem to work for some reason. There have been no
changes to the code generated by the database interface wizard except to flag
the field id as autonumber (it is the primary key).
I have contacted my server host and they tell me that everything is
correctly configured on their end.
Can anyone point me in the right direction to resolve this problem?