Kathleen
Mon Mar 10 20:11:11 CDT 2008
I'd like to make one other suggestion. Try creating a new DBIW web, and when
it asks for the name of the database connection, name it something other
than Database1 - call it kathleen
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources:
http://www.spiderwebwoman.com/xweb/
FrontPage Resources:
http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
"Rick" <Rick@discussions.microsoft.com> wrote in message
news:40E8C7F0-D082-49E2-BA11-E80744AB3771@microsoft.com...
> still no joy. i tried renaming all of the fields. the db is created in the
> fpdb folder and the global.asa file is created but that is as far as it
> gets.
> i seem to remember that several asp pages are created if everything goes
> correctly. i have only done this once before several years ago and then i
> used fp2002.
>
> i have tried connecting to sample database with the same results.
>
> it's very frustating that microsoft will give you an error messae and then
> you can't find out what it means and how to correct it somewhere on their
> website.
>
> anyway, i thank everyone for trying and i am still looking for the answer.
>
> "Kathleen Anderson" wrote:
>
>> Inline.
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> Expression Web Resources:
http://www.spiderwebwoman.com/xweb/
>> FrontPage Resources:
http://www.spiderwebwoman.com/resources/
>> Please reply to the newsgroup for the benefit of others
>>
>>
>> "Rick" <Rick@discussions.microsoft.com> wrote in message
>> news:C209514C-059F-4337-A196-9F7EA5D85678@microsoft.com...
>> > if i understand this correctly, when i use frontpage 2003 database
>> > interface
>> > wizard to create a database, the wizard creates the database with 2
>> > fields,
>> > name and key that are reserved in access
>>
>> KA: Yes
>>
>> and this is why the wizard cannot
>> > finish the connection process.
>>
>> KA: Well, I'm not sure that is the reason why - I just tried it and it
>> worked for me. I even created a new search page and used the "name" field
>> as
>> the search field and it worked.
>>
>> if this is true, then why doesn't fp2003 know
>> > these words are reserved and not use them when creating the database
>> > connection.
>>
>> KA: That's an excellent question. I did notice that the wizard gives you
>> the
>> opportunity to modify the field names.
>>
>> > when i clicked the link provided, igot a http 404 error.
>> >
>>
>> That happens occasionally when you are using the web interface to access
>> these newsgroups - try this:
>>
>>
>>
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
>>
>>
>>
>> > "Kathleen Anderson" wrote:
>> >
>> >> Name and key are both reserved words in Access 2002 and in later
>> >> versions
>> >> of
>> >> Access
>> >> tp://support.microsoft.com/default.aspx?scid=kb;en-us;286335 -
>> >> you need to change them to something else.
>> >>
>> >> --
>> >>
>> >> ~ Kathleen Anderson
>> >> Microsoft MVP - FrontPage
>> >> Spider Web Woman Designs
>> >> Expression Web Resources:
http://www.spiderwebwoman.com/xweb/
>> >> FrontPage Resources:
http://www.spiderwebwoman.com/resources/
>> >> Please reply to the newsgroup for the benefit of others
>> >>
>> >>
>> >> "Rick" <Rick@discussions.microsoft.com> wrote in message
>> >> news:708E801B-EC34-4B71-8305-086615630B32@microsoft.com...
>> >> > on my pc at home. i have a website created in fp2003 that i want to
>> >> > add
>> >> > a
>> >> > database to. after adding the database, i would want to publish it
>> >> > to
>> >> > live
>> >> > website at my hosting company.
>> >> >
>> >> >
>> >> > "Kathleen Anderson" wrote:
>> >> >
>> >> >> Are you doing this on your PC or on your live site?
>> >> >>
>> >> >> --
>> >> >>
>> >> >> ~ Kathleen Anderson
>> >> >> Microsoft MVP - FrontPage
>> >> >> Spider Web Woman Designs
>> >> >> Expression Web Resources:
http://www.spiderwebwoman.com/xweb/
>> >> >> FrontPage Resources:
http://www.spiderwebwoman.com/resources/
>> >> >> Please reply to the newsgroup for the benefit of others
>> >> >>
>> >> >>
>> >> >> "Rick" <Rick@discussions.microsoft.com> wrote in message
>> >> >> news:2C6C68ED-CCC3-4281-96C1-C4DA94CE90F8@microsoft.com...
>> >> >> > this is the procedure i followed:
>> >> >> >
>> >> >> > file -> new -> database interface wizard
>> >> >> >
>> >> >> > add to current site -> OK
>> >> >> >
>> >> >> > ASP is selected -> Create a new microsoft access database within
>> >> >> > your
>> >> >> > website ->NEXT
>> >> >> >
>> >> >> > enter a name for your database connection -> Database1 -> NEXT
>> >> >> >
>> >> >> > this brings up a window with 4 fields, key, name, address,
>> >> >> > choice ->
>> >> >> > NEXT
>> >> >> >
>> >> >> > some processing happens and a screen appears that says :
>> >> >> >
>> >> >> > Press enter or Click NEXT to continue, I click NEXT
>> >> >> >
>> >> >> > i immediately get the following error:
>> >> >> >
>> >> >> > --------------------------------------------------------------------------------------------------------------------
>> >> >> >
>> >> >> > Server error: Unable to retrieve the list of record sources from
>> >> >> > a
>> >> >> > database
>> >> >> > using the connection string:
>> >> >> >
>> >> >> > DRIVER={Microsoft Access Driver
>> >> >> > (*.mdb)};DBQ=URL=fpdb/database1.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.
>> >> >> > -------------------------------------------------------
>> >> >> >
>> >> >> >
>> >> >> > Source: ADO
>> >> >> > Number: -2146824584 (0x800a0e78)
>> >> >> > -------------------------------------------------------------------------------------------------------------------
>> >> >> >
>> >> >> > i cannot finish the database connection wizard process. the
>> >> >> > window
>> >> >> > closes
>> >> >> >
>> >> >> > i hope this helps
>> >> >> >
>> >> >> > thanks
>> >> >> >
>> >> >> >
>> >> >> > "Stefan B Rusynko" wrote:
>> >> >> >
>> >> >> >> See
>> >> >> >>
http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-800a0e78-errors.html
>> >> >> >>
>> >> >> >> What is your strSQL calling for
>> >> >> >> --
>> >> >> >>
>> >> >> >> _____________________________________________
>> >> >> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> >> >> >> "Warning - Using the F1 Key will not break anything!" (-;
>> >> >> >> _____________________________________________
>> >> >> >>
>> >> >> >>
>> >> >> >> "Rick" <Rick@discussions.microsoft.com> wrote in message
>> >> >> >> news:948C8181-B76C-455F-B710-09AA9302186F@microsoft.com...
>> >> >> >> | hi all,
>> >> >> >> | using the fp2003 database wizard, i am trying to create a new
>> >> >> >> database
>> >> >> >> | connection. i reach a point where i get the following error
>> >> >> >> and i
>> >> >> >> need
>> >> >> >> to
>> >> >> >> | know what i am doing wrong or what i need to do to correct
>> >> >> >> this.
>> >> >> >> the
>> >> >> >> error is
>> >> >> >> | :
>> >> >> >> |
>> >> >> >> | Server error: Unable to retrieve the list of record sources
>> >> >> >> from
>> >> >> >> a
>> >> >> >> database
>> >> >> >> | using the connection string:
>> >> >> >> |
>> >> >> >> | DRIVER={Microsoft Access Driver
>> >> >> >> (*.mdb)};DBQ=URL=fpdb/delivery.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.
>> >> >> >> | -------------------------------------------------------
>> >> >> >> |
>> >> >> >> |
>> >> >> >> | Source: ADO
>> >> >> >> | Number: -2146824584 (0x800a0e78)
>> >> >> >> |
>> >> >> >> | any help greatly appreciated
>> >> >> >> |
>> >> >> >> |
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>