Pure Database Interface Wizard doesn't work

ConnerS · Sep 14, 2005

http://www.diocesephoenix.org/school/seton_catholic_hs/A_interface/Alumni2/editor/login.asp

User: alum Password; Seton

I created a Database Interface using the wizard. I made no changes to it
after it was created.
When I try it I get this: Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

If I put a character in each field, then I get just the syntax error in the
update statement. The code is:
UPDATE Alumni SET GradYear = '::GradYear::' , Title = '::Title::' , Fname =
'::Fname::' , Lname = '::Lname::' , Suffix = '::Suffix::' , Address1 =
'::Address1::' , City = '::City::' , Zip = '::Zip::' , Salutation =
'::Salutation::' , Hphone = '::Hphone::' , Wphone = '::Wphone::' , email =
'::email::' , Comments = '::Comments::' , Employer = '::Employer::' ,
Occupation = '::Occupation::' , Position = ':

osition::' , Mstatus =
'::Mstatus::' , Parish = ':

arish::' , Spouse = '::Spouse::' , Child1 =
'::Child1::' , Child2 = '::Child2::' , Child3 = '::Child3::' , Child4 =
'::Child4::' , Pname = ':

name::' , Tdate = '::Tdate::' , ClassRep =
::ClassRep:: , Timestamp = '::Timestamp::' , AdditionalComments =
'::AdditionalComments::' WHERE (ID = ::ID:

And the detail from the verify query within the update query is

Server error: Unable to retrieve schema information from the query:
UPDATE Alumni SET GradYear = '1' , Title = '2' , Fname = '3' , Lname = '4' ,
Suffix = '5' , Address1 = '6' , City = '7' , Zip = '8' , Salutation = '9' ,
Hphone = '10' , Wphone = '11' , email = '12' , Comments = '13' , Employer =
'14' , Occupation = '15' , Position = '16' , Mstatus = '17' , Parish = '18' ,
Spouse = '19' , Child1 = '20' , Child2

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)

And the code from the html page is fp_sQry="UPDATE Alumni SET GradYear =
'::GradYear::' , Title = '::Title::' , Fname = '::Fname::' , Lname =
'::Lname::' , Suffix = '::Suffix::' , Address1 = '::Address1::' , City =
'::City::' , Zip = '::Zip::' , Salutation = '::Salutation::' , Hphone =
'::Hphone::' , Wphone = '::Wphone::' , email = '::email::' , Comments =
'::Comments::' , Employer = '::Employer::' , Occupation = '::Occupation::' ,
Position = ':

osition::' , Mstatus = '::Mstatus::' , Parish = ':

arish::' ,
Spouse = '::Spouse::' , Child1 = '::Child1::' , Child2 = '::Child2::' ,
Child3 = '::Child3::' , Child4 = '::Child4::' , Pname = ':

name::' , Tdate =
'::Tdate::' , ClassRep = ::ClassRep:: , Timestamp = '::Timestamp::' ,
AdditionalComments = '::AdditionalComments::' WHERE (ID = ::ID:

"

Any ideas?

Tony · Sep 14, 2005

I wish I could help, however I am having very similar problems in that I
cannot get the Database Interface Wizard to generate a website where the
Access db can be updated via ASP.Net. It does seem to work when I choose the
ASP option, though.

There is a Microsoft KB article that may be relevant in the event you are
trying to build this under ASP.Net and you have control of your server
(unfortunatley I am in a hosted environment and cannot get them to respond to
this KB).

The article is

http://support.microsoft.com/default.aspx?scid=kb;en-us;830977

If you figure this out, I would really like to know the answer. I am about
to abandon Frontpage and move to another environment.

ConnerS said:
http://www.diocesephoenix.org/school/seton_catholic_hs/A_interface/Alumni2/editor/login.asp

User: alum Password; Seton

I created a Database Interface using the wizard. I made no changes to it
after it was created.
When I try it I get this: Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

If I put a character in each field, then I get just the syntax error in the
update statement. The code is:
UPDATE Alumni SET GradYear = '::GradYear::' , Title = '::Title::' , Fname =
'::Fname::' , Lname = '::Lname::' , Suffix = '::Suffix::' , Address1 =
'::Address1::' , City = '::City::' , Zip = '::Zip::' , Salutation =
'::Salutation::' , Hphone = '::Hphone::' , Wphone = '::Wphone::' , email =
'::email::' , Comments = '::Comments::' , Employer = '::Employer::' ,
Occupation = '::Occupation::' , Position = ':osition::' , Mstatus =
'::Mstatus::' , Parish = ':arish::' , Spouse = '::Spouse::' , Child1 =
'::Child1::' , Child2 = '::Child2::' , Child3 = '::Child3::' , Child4 =
'::Child4::' , Pname = ':name::' , Tdate = '::Tdate::' , ClassRep =
::ClassRep:: , Timestamp = '::Timestamp::' , AdditionalComments =
'::AdditionalComments::' WHERE (ID = ::ID:

And the detail from the verify query within the update query is

Server error: Unable to retrieve schema information from the query:
UPDATE Alumni SET GradYear = '1' , Title = '2' , Fname = '3' , Lname = '4' ,
Suffix = '5' , Address1 = '6' , City = '7' , Zip = '8' , Salutation = '9' ,
Hphone = '10' , Wphone = '11' , email = '12' , Comments = '13' , Employer =
'14' , Occupation = '15' , Position = '16' , Mstatus = '17' , Parish = '18' ,
Spouse = '19' , Child1 = '20' , Child2

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)

And the code from the html page is fp_sQry="UPDATE Alumni SET GradYear =
'::GradYear::' , Title = '::Title::' , Fname = '::Fname::' , Lname =
'::Lname::' , Suffix = '::Suffix::' , Address1 = '::Address1::' , City =
'::City::' , Zip = '::Zip::' , Salutation = '::Salutation::' , Hphone =
'::Hphone::' , Wphone = '::Wphone::' , email = '::email::' , Comments =
'::Comments::' , Employer = '::Employer::' , Occupation = '::Occupation::' ,
Position = ':osition::' , Mstatus = '::Mstatus::' , Parish = ':arish::' ,
Spouse = '::Spouse::' , Child1 = '::Child1::' , Child2 = '::Child2::' ,
Child3 = '::Child3::' , Child4 = '::Child4::' , Pname = ':name::' , Tdate =
'::Tdate::' , ClassRep = ::ClassRep:: , Timestamp = '::Timestamp::' ,
AdditionalComments = '::AdditionalComments::' WHERE (ID = ::ID:"

Any ideas?

ConnerS · Sep 15, 2005

From a previous inquiry I made:
Temporarily to see more details on the error, open the hidden folder
/_fpclass/ and edit the
fpdbrgn1.inc file and at about line 19, change :
fp_DEBUG = False
to :
fp_DEBUG = True
Thanks to Stefan B Rusynko

What is your url, so I can see if it is the same error message I am getting.
I know it can work, I have had it up and running for a couple of years, but
something changed, and I can't figure out where (server or site) or what.

Tony said:
I wish I could help, however I am having very similar problems in that I
cannot get the Database Interface Wizard to generate a website where the
Access db can be updated via ASP.Net. It does seem to work when I choose the
ASP option, though.

There is a Microsoft KB article that may be relevant in the event you are
trying to build this under ASP.Net and you have control of your server
(unfortunatley I am in a hosted environment and cannot get them to respond to
this KB).

The article is

http://support.microsoft.com/default.aspx?scid=kb;en-us;830977

If you figure this out, I would really like to know the answer. I am about
to abandon Frontpage and move to another environment.

ConnerS said:

http://www.diocesephoenix.org/school/seton_catholic_hs/A_interface/Alumni2/editor/login.asp

User: alum Password; Seton

I created a Database Interface using the wizard. I made no changes to it
after it was created.
When I try it I get this: Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

If I put a character in each field, then I get just the syntax error in the
update statement. The code is:
UPDATE Alumni SET GradYear = '::GradYear::' , Title = '::Title::' , Fname =
'::Fname::' , Lname = '::Lname::' , Suffix = '::Suffix::' , Address1 =
'::Address1::' , City = '::City::' , Zip = '::Zip::' , Salutation =
'::Salutation::' , Hphone = '::Hphone::' , Wphone = '::Wphone::' , email =
'::email::' , Comments = '::Comments::' , Employer = '::Employer::' ,
Occupation = '::Occupation::' , Position = ':osition::' , Mstatus =
'::Mstatus::' , Parish = ':arish::' , Spouse = '::Spouse::' , Child1 =
'::Child1::' , Child2 = '::Child2::' , Child3 = '::Child3::' , Child4 =
'::Child4::' , Pname = ':name::' , Tdate = '::Tdate::' , ClassRep =
::ClassRep:: , Timestamp = '::Timestamp::' , AdditionalComments =
'::AdditionalComments::' WHERE (ID = ::ID:

And the detail from the verify query within the update query is

Server error: Unable to retrieve schema information from the query:
UPDATE Alumni SET GradYear = '1' , Title = '2' , Fname = '3' , Lname = '4' ,
Suffix = '5' , Address1 = '6' , City = '7' , Zip = '8' , Salutation = '9' ,
Hphone = '10' , Wphone = '11' , email = '12' , Comments = '13' , Employer =
'14' , Occupation = '15' , Position = '16' , Mstatus = '17' , Parish = '18' ,
Spouse = '19' , Child1 = '20' , Child2

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)

And the code from the html page is fp_sQry="UPDATE Alumni SET GradYear =
'::GradYear::' , Title = '::Title::' , Fname = '::Fname::' , Lname =
'::Lname::' , Suffix = '::Suffix::' , Address1 = '::Address1::' , City =
'::City::' , Zip = '::Zip::' , Salutation = '::Salutation::' , Hphone =
'::Hphone::' , Wphone = '::Wphone::' , email = '::email::' , Comments =
'::Comments::' , Employer = '::Employer::' , Occupation = '::Occupation::' ,
Position = ':osition::' , Mstatus = '::Mstatus::' , Parish = ':arish::' ,
Spouse = '::Spouse::' , Child1 = '::Child1::' , Child2 = '::Child2::' ,
Child3 = '::Child3::' , Child4 = '::Child4::' , Pname = ':name::' , Tdate =
'::Tdate::' , ClassRep = ::ClassRep:: , Timestamp = '::Timestamp::' ,
AdditionalComments = '::AdditionalComments::' WHERE (ID = ::ID:"

Any ideas?

Click to expand...

ConnerS · Sep 15, 2005

I started over. I deleted the A-interface, and removed the code from the
global.asa file (OOPS?!) then recreated using the Database Interface Wizard
in FP2002. Now, I get an error message: HTTP Error 500-12 Application
Restarting
Internet Information Service
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Background:
The request cannot be processed while the Web site is restarting.
KB says it is temporary. So I went to bed. 12 hours later, still same
message.
(In my quest for solutions, I also found that you don't put the timestamp in
the update query) Separate issue at this point.

Now the link is
http://www.diocesephoenix.org/school/seton_catholic_hs/A_interface/Alumni/editor/login.asp
user: alum pass: seton

ConnerS said:
http://www.diocesephoenix.org/school/seton_catholic_hs/A_interface/Alumni2/editor/login.asp

User: alum Password; Seton

I created a Database Interface using the wizard. I made no changes to it
after it was created.
When I try it I get this: Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

If I put a character in each field, then I get just the syntax error in the
update statement. The code is:
UPDATE Alumni SET GradYear = '::GradYear::' , Title = '::Title::' , Fname =
'::Fname::' , Lname = '::Lname::' , Suffix = '::Suffix::' , Address1 =
'::Address1::' , City = '::City::' , Zip = '::Zip::' , Salutation =
'::Salutation::' , Hphone = '::Hphone::' , Wphone = '::Wphone::' , email =
'::email::' , Comments = '::Comments::' , Employer = '::Employer::' ,
Occupation = '::Occupation::' , Position = ':osition::' , Mstatus =
'::Mstatus::' , Parish = ':arish::' , Spouse = '::Spouse::' , Child1 =
'::Child1::' , Child2 = '::Child2::' , Child3 = '::Child3::' , Child4 =
'::Child4::' , Pname = ':name::' , Tdate = '::Tdate::' , ClassRep =
::ClassRep:: , Timestamp = '::Timestamp::' , AdditionalComments =
'::AdditionalComments::' WHERE (ID = ::ID:

And the detail from the verify query within the update query is

Server error: Unable to retrieve schema information from the query:
UPDATE Alumni SET GradYear = '1' , Title = '2' , Fname = '3' , Lname = '4' ,
Suffix = '5' , Address1 = '6' , City = '7' , Zip = '8' , Salutation = '9' ,
Hphone = '10' , Wphone = '11' , email = '12' , Comments = '13' , Employer =
'14' , Occupation = '15' , Position = '16' , Mstatus = '17' , Parish = '18' ,
Spouse = '19' , Child1 = '20' , Child2

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)

And the code from the html page is fp_sQry="UPDATE Alumni SET GradYear =
'::GradYear::' , Title = '::Title::' , Fname = '::Fname::' , Lname =
'::Lname::' , Suffix = '::Suffix::' , Address1 = '::Address1::' , City =
'::City::' , Zip = '::Zip::' , Salutation = '::Salutation::' , Hphone =
'::Hphone::' , Wphone = '::Wphone::' , email = '::email::' , Comments =
'::Comments::' , Employer = '::Employer::' , Occupation = '::Occupation::' ,
Position = ':osition::' , Mstatus = '::Mstatus::' , Parish = ':arish::' ,
Spouse = '::Spouse::' , Child1 = '::Child1::' , Child2 = '::Child2::' ,
Child3 = '::Child3::' , Child4 = '::Child4::' , Pname = ':name::' , Tdate =
'::Tdate::' , ClassRep = ::ClassRep:: , Timestamp = '::Timestamp::' ,
AdditionalComments = '::AdditionalComments::' WHERE (ID = ::ID:"

Any ideas?