In your current open FP web you should have global.asa file and fpdb folder in the root of the web
before starting, if you want to use the current database.
1. Create a form. like say the feedback form
2. Right click on form, then select form properties
3. Select send to database.
4. Select current connection.
5. Let FP create the "result" table in the current database.
Then you should be able to create a page to display the data from this new table using the FP
database component.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
Haven't worked with Forms - need basic steps to "connect directly to a table w/i database," etc..
I did just create what seemed to be a Form using Insert, published, and displayed all without
error.
--
Thanks - JimK
:
Try connecting directly to a table within the database or create new form, and then let FP
create
the table in the database under Form properties, then post here with the exact error message
returned, if any.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
1) Changed server setting to IIS. Rebooted and tried, but problem continues.
2) 'qry-010-Followup' is a query. Am getting the error in tables and queries from the
testers.mdb
database as well as a second. Both databases were created in my environment (vs. the sample
database, which works).
--
Thanks - JimK
:
Jim,
Is 'qry-010-Followup' an existing table within the WerleSAWTestERS.mdb ?
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
Change the Server Setting to Internet Information Server (IIS).
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
Under Compatibility tab, Browser set to "custom;" Server set to "custom." FP Server
Extensions
enabled. ALL "Available Technologies" entries were checked, consistent with your
suggestion
and
include ASP and VBScript, and several others, but no IIS.
Does "custom" make sense? Is it meant to imply "all?"
--
Thanks - JimK
:
Ok, look under Page/Authoring Options | Compatibility setting, and make sure you have
ASP,
IIS,
VBScript, etc. enabled.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
Thanks again! No to your question. Note that I do not have IIS installed.
Everything I
am
attempting to do is in FP. That is, insert database results in a FP .asp page. Since
I
can't
complete, there is nothing to check using a browser locally or on the remote server to
which I
publish.
When this feature has worked on other PCs and earlier versions of FP/ACCESS, I could
insert
the
database results, save the page, publish and view with browser on the server to which
it
was
published. I have also had PCs on which IIS was installed and successfully followed
the
same
process. Presence of IIS, based on my recollection, was not a determinant of whether
or
not
successfully inserting database results would or would not work.
Could there be a requirement for certain permissions in the exchange between FP and
ACCESS.
I've
checked and see nothing which appears amiss to me and certainly have not restricted
permissions
for
my out-of-the-box installations of FP and ACCESS. How about ACCESS drivers unique to
this
task?
I
checked the knowledge base and could not find any. Are there custom FP or ACCESS
installation
considerations needed to use this feature?
--
Thanks - JimK
:
Ok, are you opening the web under
http://localhost, etc. in FP before trying to
work
with
the
database?
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
Thanks. Moved testers.mdb under fpdb directory. No luck. Please note: 1) I
was
able
to
Insert
Database Results using the FourWins sample database, publish and view when located
under
fpdb
AND 2)
in a directory below that.
In the case of my mdb file, I can not even complete the "insert results" in an
asp
page.
Get
my
error as posted orignially. Upon leaving the insertion attempt get: "Unable to
retrieve
the
list
of
field names form the selected record source." It appears when using the Insert
Database
wizard
in
Step 2 of 5 at which point I am specifying a record source. Get the same results
if I
attempt
to
exercise the Custom Query option in that same step.
--
Thanks - JimK
:
The correct path should be:
C:\...\My Webs\KnowledgeManagement\fpdb\testers.mdb
not:
C:\...\My Webs\KnowledgeManagement\fpdb\sawtestcases\testers.mdb
There should not be any subfolders under fpdb.
However in order run/test ASP code locally, you must have IIS with FP
extensions
installed
and
test
the page using
http://localhost/pagename.asp or on a remote host running
Windows
IIS
server
and
supporting Access as a database.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
Name shortened to testers.mdb. File was/is located in the fpdb FP
sub-directory:
C:\...\My Webs\KnowledgeManagement\fpdb\sawtestcases\testers.mdb It has
been
"verified"
using FP
Web Settings. Getting same error message with any ACCESS file I create and
attempt to
use
in
either
of two XP system environments.
Kathleen, since I can not implement, not clear how/what html I can copy for
review?
--
Thanks - JimK
:
Also make sure the database in the fpdb folder under the root or subweb,
i.e.,
If "SAW-TestCases" is a subweb/site then:
/SAW-TestCases/fpdb/WerleSAWTestERS.mdb
If working in the root web, then just:
domainname/fpdb/WerleSAWTestERS.mdb
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
Hi Jim:
For starters, I would rename the database to something shorter and
simpler,
lower case, with no special characters, such as sawcases.mdb
If that doesn't help, please post back with your SQL (switch to HTML
view
and find the string that starts with s-sql="SELECT
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html
Using FP 2002 and XP, can not complete insertion of Database Results
using wizard in either of two different systems. Sample database
works OK.
Get "Database Connection Error" with following details:
Server error: Unable to retrieve schema information from the record
source 'qry-010-Followup' in a database using the connection string:
'DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/SAW-TestCases/WerleSAWTestERS.mdb'.
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 FROM
clause.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)
