Re: Insert Database Results - Get Error
From: Thomas A. Rowe (tarowe_at_mvps.org)
Date: 06/17/04
- Next message: doug: "Re: Saving Pages"
- Previous message: Thomas A. Rowe: "Re: Event viewer log entry question"
- In reply to: JimK: "Re: Insert Database Results - Get Error"
- Next in thread: JimK: "Re: Insert Database Results - Get Error"
- Reply: JimK: "Re: Insert Database Results - Get Error"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 17 Jun 2004 13:37:14 -0400
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: doug: "Re: Saving Pages"
- Previous message: Thomas A. Rowe: "Re: Event viewer log entry question"
- In reply to: JimK: "Re: Insert Database Results - Get Error"
- Next in thread: JimK: "Re: Insert Database Results - Get Error"
- Reply: JimK: "Re: Insert Database Results - Get Error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
