Database Interface Wizard

C

ConnerS

When I use New > Page or Web> Database Interface Wizard>
Add to existing Web
Using an existing database connection
Select a table, Choice of ~TMPCLP51541, or Alumni
I Choose Alumni, next
no changes to column types
Check Results, Submission, and Database Editor

and when I try to use the editor I get this error:
Database Results Error
Your page contains a query with user input parameters that could not be
resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing
s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.

I can't use Workaround 1, but I can use Workaround 2 and it still doesn't
work.
I have searched on different words in the error message s-columnnames and
s-columtypes and the only thing the knowledge base comes up with is 817029.
What is my next step?
 
C

ConnerS

I am using: FP2002, with Office 2000 with SP1, 2 and 3. Windows XP.
I connect remotely to the webserver, and all I know is that it does use IIS.
Is there any way I can find out more about them (if I need to) from my end?
 
C

ConnerS

There are 5 updates shown to be installed on 9/3/05. They were part of the
automatic updates from Microsoft. It says they can't be removed. One of the
support numbers is DA256408-A2E7-41A58AD6-62ACB86A0FD7.
 
C

ConnerS

Thank you for the resource at www.frontpagewebmaster.com. After reading lots
of threads, I replaced the files, first moving the old ones to a different
folder _fpclassold. But the hyperlinks "followed" the files to
_fpclassold/fpdblib.inc (etc). so then I renamed the original files to
fbdblibold.inc and put them back in the _fpclass directory. The hyperlinks
view shows that they are directed to the correct place.
Once I did this, I started getting the http error 500-12 on every .asp page.
So I don't know if it worked. BeTheBall (from frontpagewebmaster.com)
thinks it may be anti-virus software on the server end. I am over my head
and just learning to swim with all of this.
Can't figure a way to stop the application from restarting without calling
the help desk in the morning. Any ideas?
 
K

Kathleen Anderson [MVP - FrontPage]

It's possible that moving the files out of the _fpclass folder, instead of
just overlaying them, might have something to do with this.

This is still just a test web site, yes? If you can, try this: open the web,
export the database to your desktop, delete the database from the web,
delete the fpdb folder, delete the global.asa, and delete the _fpclass
folder.

Close the web, open it again, and import the database from your desktop back
into your web. This will recreate the fpdb and _fpclass folders, and the
global.asa.

At this point, try creating a simple query page using the Database Results
Wizard and see if it works.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
 
C

ConnerS

It is NOt a test web site. This is my production site. (I think that is the
correct term)
 
C

ConnerS

I was able to export to my desktop and the files look good, so I am
proceeding. Theyre are acturally 5 little databases in the fpdb folder, all
with differernt connections. I started to delete them, but one will not
delete I get the message: Server error: Cannot remove file: "Parents.mdb".
I tried deleting the folder fpdb and it won't delete either, giving me the
same message:
Server error: Cannot remove file: "Parents.mdb".
Should I proceed?
 
K

Kathleen Anderson [MVP - FrontPage]

Now you know what I meant when I said: "The questions about why something
isn't working are much more difficult to answer.". :)

I've always been under the impression, and I could be wrong, that you
can/should only have two databases in a root web or subweb.

By any chance do you see a file in the fpdb folder called parents.ldb?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
 
C

ConnerS

I had no idea how hard it was to figure this stuff out!
No, the only thing that shows is the Parents.mdb
I opened the database from within Frontpage, and when I tried to close I got
the message: Server error: Cannot lock file "Parents.mdb". eith the file is
no use or the web server is temporarily busy.
 
C

ConnerS

I tried importing the one from my desktop to replace the problem child,
Unable to Lock file.
What would happen if I went ahead and deleted global.asa and _fpclass? I
want to say it couldn't get much worse... but I am beginning to learn that
doesnt work with .asp
 
K

Kathleen Anderson [MVP - FrontPage]

If you have all the databases backed up I would delete the global.asa and
the _fpclass folder and then see if it will let you delete parents.mdb. If
that doesn't work, maybe your host can delete it for you.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
 
S

Stefan B Rusynko

You should not have opened the Access DB from w/i FP
(always export the db to your PC and open from there)
Try Tools Site Settings Database and if you see it listed select the option to remove it
- you may need to have you host stop & restart the server to clear your DB locked error




|I had no idea how hard it was to figure this stuff out!
| No, the only thing that shows is the Parents.mdb
| I opened the database from within Frontpage, and when I tried to close I got
| the message: Server error: Cannot lock file "Parents.mdb". eith the file is
| no use or the web server is temporarily busy.
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > Now you know what I meant when I said: "The questions about why something
| > isn't working are much more difficult to answer.". :)
| >
| > I've always been under the impression, and I could be wrong, that you
| > can/should only have two databases in a root web or subweb.
| >
| > By any chance do you see a file in the fpdb folder called parents.ldb?
| >
| > --
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web: http://www.spiderwebwoman.com/resources/
| >
| >
| > | > >I was able to export to my desktop and the files look good, so I am
| > > proceeding. Theyre are acturally 5 little databases in the fpdb folder,
| > > all
| > > with differernt connections. I started to delete them, but one will not
| > > delete I get the message: Server error: Cannot remove file:
| > > "Parents.mdb".
| > > I tried deleting the folder fpdb and it won't delete either, giving me the
| > > same message:
| > > Server error: Cannot remove file: "Parents.mdb".
| > > Should I proceed?
| > >
| > >
| > > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >
| > >> It's possible that moving the files out of the _fpclass folder, instead
| > >> of
| > >> just overlaying them, might have something to do with this.
| > >>
| > >> This is still just a test web site, yes? If you can, try this: open the
| > >> web,
| > >> export the database to your desktop, delete the database from the web,
| > >> delete the fpdb folder, delete the global.asa, and delete the _fpclass
| > >> folder.
| > >>
| > >> Close the web, open it again, and import the database from your desktop
| > >> back
| > >> into your web. This will recreate the fpdb and _fpclass folders, and the
| > >> global.asa.
| > >>
| > >> At this point, try creating a simple query page using the Database
| > >> Results
| > >> Wizard and see if it works.
| > >>
| > >> --
| > >> ~ Kathleen Anderson
| > >> Microsoft MVP - FrontPage
| > >> Spider Web Woman Designs
| > >> web: http://www.spiderwebwoman.com/resources/
| > >>
| > >>
| > >> | > >> > Same error
| > >> > see page
| > >> > http://www.diocesephoenix.org/school/seton_catholic_hs/Alumni/resultsYear.asp
| > >> >
| > >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >> >
| > >> >> Try turning off Show Friendly HTTP Error Messages in IE:
| > >> >> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q294807 to see
| > >> >> if
| > >> >> you can get more information about the error.
| > >> >>
| > >> >> --
| > >> >> ~ Kathleen Anderson
| > >> >> Microsoft MVP - FrontPage
| > >> >> Spider Web Woman Designs
| > >> >> web: http://www.spiderwebwoman.com/resources/
| > >> >>
| > >> >>
| > >> >> | > >> >> > Thank you for the resource at www.frontpagewebmaster.com. After
| > >> >> > reading
| > >> >> > lots
| > >> >> > of threads, I replaced the files, first moving the old ones to a
| > >> >> > different
| > >> >> > folder _fpclassold. But the hyperlinks "followed" the files to
| > >> >> > _fpclassold/fpdblib.inc (etc). so then I renamed the original files
| > >> >> > to
| > >> >> > fbdblibold.inc and put them back in the _fpclass directory. The
| > >> >> > hyperlinks
| > >> >> > view shows that they are directed to the correct place.
| > >> >> > Once I did this, I started getting the http error 500-12 on every
| > >> >> > .asp
| > >> >> > page.
| > >> >> > So I don't know if it worked. BeTheBall (from
| > >> >> > frontpagewebmaster.com)
| > >> >> > thinks it may be anti-virus software on the server end. I am over
| > >> >> > my
| > >> >> > head
| > >> >> > and just learning to swim with all of this.
| > >> >> > Can't figure a way to stop the application from restarting without
| > >> >> > calling
| > >> >> > the help desk in the morning. Any ideas?
| > >> >> >
| > >> >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >> >> >
| > >> >> >> Try replacing your .inc files in the _fpclass folder with the ones
| > >> >> >> from
| > >> >> >> FP2000 - you can get them here:
| > >> >> >> http://www.frontpagewebmaster.com/m-175524/tm.htm
| > >> >> >>
| > >> >> >> --
| > >> >> >> ~ Kathleen Anderson
| > >> >> >> Microsoft MVP - FrontPage
| > >> >> >> Spider Web Woman Designs
| > >> >> >> web: http://www.spiderwebwoman.com/resources/
| > >> >> >>
| > >> >> >>
| > >> >> >> | > >> >> >> > About says FrontPage 2002 (10.6308.6735)SP3
| > >> >> >> >
| > >> >> >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >> >> >> >
| > >> >> >> >> To find out if you've applied any Service Packs to FrontPage,
| > >> >> >> >> Open
| > >> >> >> >> FrontPage
| > >> >> >> >> and do a Help | About.
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >> >> --
| > >> >> >> >> ~ Kathleen Anderson
| > >> >> >> >> Microsoft MVP - FrontPage
| > >> >> >> >> Spider Web Woman Designs
| > >> >> >> >> web: http://www.spiderwebwoman.com/resources/
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >> >> | > >> >> >> >> > There are 5 updates shown to be installed on 9/3/05. They
| > >> >> >> >> > were
| > >> >> >> >> > part
| > >> >> >> >> > of
| > >> >> >> >> > the
| > >> >> >> >> > automatic updates from Microsoft. It says they can't be
| > >> >> >> >> > removed.
| > >> >> >> >> > One
| > >> >> >> >> > of
| > >> >> >> >> > the
| > >> >> >> >> > support numbers is DA256408-A2E7-41A58AD6-62ACB86A0FD7.
| > >> >> >> >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >> >> >> >> >
| > >> >> >> >> >> Have you applied any Service Packs to FrontPage 2002?
| > >> >> >> >> >>
| > >> >> >> >> >> --
| > >> >> >> >> >> ~ Kathleen Anderson
| > >> >> >> >> >> Microsoft MVP - FrontPage
| > >> >> >> >> >> Spider Web Woman Designs
| > >> >> >> >> >> web: http://www.spiderwebwoman.com/resources/
| > >> >> >> >> >>
| > >> >> >> >> >>
| > >> >> >> >> >> message
| > >> >> >> >> >> | > >> >> >> >> >> >I am using: FP2002, with Office 2000 with SP1, 2 and 3.
| > >> >> >> >> >> >Windows
| > >> >> >> >> >> >XP.
| > >> >> >> >> >> > I connect remotely to the webserver, and all I know is that
| > >> >> >> >> >> > it
| > >> >> >> >> >> > does
| > >> >> >> >> >> > use
| > >> >> >> >> >> > IIS.
| > >> >> >> >> >> > Is there any way I can find out more about them (if I need
| > >> >> >> >> >> > to)
| > >> >> >> >> >> > from
| > >> >> >> >> >> > my
| > >> >> >> >> >> > end?
| > >> >> >> >> >> > "ConnerS" wrote:
| > >> >> >> >> >> >
| > >> >> >> >> >> >> When I use New > Page or Web> Database Interface Wizard>
| > >> >> >> >> >> >> Add to existing Web
| > >> >> >> >> >> >> Using an existing database connection
| > >> >> >> >> >> >> Select a table, Choice of ~TMPCLP51541, or Alumni
| > >> >> >> >> >> >> I Choose Alumni, next
| > >> >> >> >> >> >> no changes to column types
| > >> >> >> >> >> >> Check Results, Submission, and Database Editor
| > >> >> >> >> >> >>
| > >> >> >> >> >> >> and when I try to use the editor I get this error:
| > >> >> >> >> >> >> Database Results Error
| > >> >> >> >> >> >> Your page contains a query with user input parameters that
| > >> >> >> >> >> >> could
| > >> >> >> >> >> >> not
| > >> >> >> >> >> >> be
| > >> >> >> >> >> >> resolved.
| > >> >> >> >> >> >> This could happen if your DatabaseRegionStart webbot has
| > >> >> >> >> >> >> an
| > >> >> >> >> >> >> empty
| > >> >> >> >> >> >> or
| > >> >> >> >> >> >> missing
| > >> >> >> >> >> >> s-columnnames or s-columntypes attributes.
| > >> >> >> >> >> >> You may need to read Microsoft Knowledge Base Article
| > >> >> >> >> >> >> 817029.
| > >> >> >> >> >> >>
| > >> >> >> >> >> >> I can't use Workaround 1, but I can use Workaround 2 and
| > >> >> >> >> >> >> it
| > >> >> >> >> >> >> still
| > >> >> >> >> >> >> doesn't
| > >> >> >> >> >> >> work.
| > >> >> >> >> >> >> I have searched on different words in the error message
| > >> >> >> >> >> >> s-columnnames
| > >> >> >> >> >> >> and
| > >> >> >> >> >> >> s-columtypes and the only thing the knowledge base comes
| > >> >> >> >> >> >> up
| > >> >> >> >> >> >> with
| > >> >> >> >> >> >> is
| > >> >> >> >> >> >> 817029.
| > >> >> >> >> >> >> What is my next step?
| > >> >> >> >> >> >>
| > >> >> >> >> >> >>
| > >> >> >> >> >> >>
| > >> >> >> >> >> >>
| > >> >> >> >> >> >>
| > >> >> >> >> >> >>
| > >> >> >> >> >>
| > >> >> >> >> >>
| > >> >> >> >> >>
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >>
| > >> >>
| > >> >>
| > >>
| > >>
| > >>
| >
| >
| >
 
C

ConnerS

The global.asa deleted, and the include files but not the folder _fpclass and
I still have _fpclassold. When I imported the database back in, I was asked
if I wanted a database connection, yes, message couldn't create _vti ... I'll
get with the host this morning and see where to go from here.
 
M

mystic

If I understand your error correctly, you are having an issue when you try to
made changes to records in your dBase. I resolved this issue with by the
following procedure: *the Following is based on the default web build when
using the “Database Interface Wizardâ€*

FYI, RECORD1 IS BEING USED AS AN EXAMPLE FIELD NAME, THIS WOULD BE REPLACED
WITH THE ACTUAL FIELD NAME ON THE DATABASE TABLE.
Go to the web directory… “Database_files\editor\†and locate file “update.aspâ€
Right click database region (highlighted in yellow) > click next > Custom
query, click edit…
In the Custom Query window, you should see the field queries in the
following format… RECORD1 = ‘::RECORD1::’ this needs to be changed to
[RECORD1] = ‘::RECORD1::’

You’ll notice that only brackets were added before and after the 1st
instance of RECORD1. Continue procure for remaining filed names. Note that
the ‘:: and ::’ may vary based on type of data, i.e. text. Only make these
modifications to field names after “SET†and before “WHEREâ€.

Once this procedure is complete, click on verify query and continue. These
modifications were tested only with the use of an access database. The
following is an example of the query script in correct working format…

UPDATE mydbase SET [FN] = '::FN::' , [LN] = '::LN::' , [DOB] = '::DOB::' ,
[CELL] = '::CELL::' , [TN] = '::TN::' , [FX] = '::FX::' WHERE (ID = ::ID::)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top