Re: Insert Database Results - Get Error

From: JimK (JimK_at_discussions.microsoft.com)
Date: 06/17/04

• Next message: Danno: "Re: Front Page Links to databases."
• Previous message: Jon Spivey: "Re: Can't veiw the result of dhtml Drop Down menu in normal pane"
• In reply to: Thomas A. Rowe: "Re: Insert Database Results - Get Error"
• Next in thread: Thomas A. Rowe: "Re: Insert Database Results - Get Error"
• Reply: Thomas A. Rowe: "Re: Insert Database Results - Get Error"
• Messages sorted by: [ date ] [ thread ]

Date: Thu, 17 Jun 2004 11:37:01 -0700

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
"Thomas A. Rowe" wrote:
> 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)
> http://www.ycoln-resources.com
> 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
> 
> "JimK" <JimK@discussions.microsoft.com> wrote in message
> news:9E66AD24-A1EA-4E4A-84EA-A4BA8BA98C16@microsoft.com...
> > 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
> >
> >
> > "Thomas A. Rowe" wrote:
> >
> > > 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)
> > > http://www.ycoln-resources.com
> > > 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
> > >
> > > "JimK" <JimK@discussions.microsoft.com> wrote in message
> > > news:BD421017-DCFF-40B9-9477-A65518FF27BC@microsoft.com...
> > > > 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
> > > >
> > > >
> > > > "Thomas A. Rowe" wrote:
> > > >
> > > > >
> > > > > 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)
> > > > > http://www.ycoln-resources.com
> > > > > 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
> > > > >
> > > > > "JimK" <JimK@discussions.microsoft.com> wrote in message
> > > > > news:A788228D-04F9-4B42-8616-74A714C0B846@microsoft.com...
> > > > > > 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
> > > > > >
> > > > > >
> > > > > > "Thomas A. Rowe" wrote:
> > > > > >
> > > > > > > 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)
> > > > > > > http://www.ycoln-resources.com
> > > > > > > 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
> > > > > > >
> > > > > > > "Kathleen Anderson [MVP - FP]" <spiderwebwoman@mvps.org> wrote in message
> > > > > > > news:uxreW8yUEHA.4048@TK2MSFTNGP12.phx.gbl...
> > > > > > > > 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
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > JimK <JimK@discussions.microsoft.com> wrote:
> > > > > > > > > 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)
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
> 
> 
> 

• Next message: Danno: "Re: Front Page Links to databases."
• Previous message: Jon Spivey: "Re: Can't veiw the result of dhtml Drop Down menu in normal pane"
• In reply to: Thomas A. Rowe: "Re: Insert Database Results - Get Error"
• Next in thread: Thomas A. Rowe: "Re: Insert Database Results - Get Error"
• Reply: Thomas A. Rowe: "Re: Insert Database Results - Get Error"
• Messages sorted by: [ date ] [ thread ]

• Windows
• Science
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint