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

See http://tutorials.aspfaq.com/8000xxxx...78-errors.html

What is your strSQL calling for
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


"Rick" <(E-Mail Removed)> wrote in message news:948C8181-B76C-455F-B710-(E-Mail Removed)...
| 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
|
|

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/8000xxxx...78-errors.html
>
> What is your strSQL calling for
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "Rick" <(E-Mail Removed)> wrote in message news:948C8181-B76C-455F-B710-(E-Mail Removed)...
> | 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
> |
> |
>
>
>

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" <(E-Mail Removed)> wrote in message
news:2C6C68ED-CCC3-4281-96C1-(E-Mail Removed)...
> 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/8000xxxx...78-errors.html
>>
>> What is your strSQL calling for
>> --
>>
>> _____________________________________________
>> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> "Warning - Using the F1 Key will not break anything!" (-;
>> _____________________________________________
>>
>>
>> "Rick" <(E-Mail Removed)> wrote in message
>> news:948C8181-B76C-455F-B710-(E-Mail Removed)...
>> | 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
>> |
>> |
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
> news:2C6C68ED-CCC3-4281-96C1-(E-Mail Removed)...
> > 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/8000xxxx...78-errors.html
> >>
> >> What is your strSQL calling for
> >> --
> >>
> >> _____________________________________________
> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> >> "Warning - Using the F1 Key will not break anything!" (-;
> >> _____________________________________________
> >>
> >>
> >> "Rick" <(E-Mail Removed)> wrote in message
> >> news:948C8181-B76C-455F-B710-(E-Mail Removed)...
> >> | 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
> >> |
> >> |
> >>
> >>
> >>
>
>
>

Name and key are both reserved words in Access 2002 and in later versions of
Access http://support.microsoft.com/default...b;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" <(E-Mail Removed)> wrote in message
news:708E801B-EC34-4B71-8305-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:2C6C68ED-CCC3-4281-96C1-(E-Mail Removed)...
>> > 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/8000xxxx...78-errors.html
>> >>
>> >> What is your strSQL calling for
>> >> --
>> >>
>> >> _____________________________________________
>> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> >> "Warning - Using the F1 Key will not break anything!" (-;
>> >> _____________________________________________
>> >>
>> >>
>> >> "Rick" <(E-Mail Removed)> wrote in message
>> >> news:948C8181-B76C-455F-B710-(E-Mail Removed)...
>> >> | 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
>> >> |
>> >> |
>> >>
>> >>
>> >>
>>
>>
>>

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 and this is why the wizard cannot
finish the connection process. if this is true, then why doesn't fp2003 know
these words are reserved and not use them when creating the database
connection.

when i clicked the link provided, igot a http 404 error.

thanks

"Kathleen Anderson" wrote:

> Name and key are both reserved words in Access 2002 and in later versions of
> Access http://support.microsoft.com/default...b;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" <(E-Mail Removed)> wrote in message
> news:708E801B-EC34-4B71-8305-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:2C6C68ED-CCC3-4281-96C1-(E-Mail Removed)...
> >> > 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/8000xxxx...78-errors.html
> >> >>
> >> >> What is your strSQL calling for
> >> >> --
> >> >>
> >> >> _____________________________________________
> >> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> >> >> "Warning - Using the F1 Key will not break anything!" (-;
> >> >> _____________________________________________
> >> >>
> >> >>
> >> >> "Rick" <(E-Mail Removed)> wrote in message
> >> >> news:948C8181-B76C-455F-B710-(E-Mail Removed)...
> >> >> | 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
> >> >> |
> >> >> |
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

The database/table is created based on the fields in your form. You have to rename the form fields.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================


"Rick" <(E-Mail Removed)> wrote in message
news:C209514C-059F-4337-A196-(E-Mail Removed)...
> 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 and this is why the wizard cannot
> finish the connection process. if this is true, then why doesn't fp2003 know
> these words are reserved and not use them when creating the database
> connection.
>
> when i clicked the link provided, igot a http 404 error.
>
> thanks
>
> "Kathleen Anderson" wrote:
>
>> Name and key are both reserved words in Access 2002 and in later versions of
>> Access http://support.microsoft.com/default...b;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" <(E-Mail Removed)> wrote in message
>> news:708E801B-EC34-4B71-8305-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
>> >> news:2C6C68ED-CCC3-4281-96C1-(E-Mail Removed)...
>> >> > 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/8000xxxx...78-errors.html
>> >> >>
>> >> >> What is your strSQL calling for
>> >> >> --
>> >> >>
>> >> >> _____________________________________________
>> >> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> >> >> "Warning - Using the F1 Key will not break anything!" (-;
>> >> >> _____________________________________________
>> >> >>
>> >> >>
>> >> >> "Rick" <(E-Mail Removed)> wrote in message
>> >> >> news:948C8181-B76C-455F-B710-(E-Mail Removed)...
>> >> >> | 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
>> >> >> |
>> >> >> |
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
news:C209514C-059F-4337-A196-(E-Mail Removed)...
> 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...b;en-us;286335



> "Kathleen Anderson" wrote:
>
>> Name and key are both reserved words in Access 2002 and in later versions
>> of
>> Access http://support.microsoft.com/default...b;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" <(E-Mail Removed)> wrote in message
>> news:708E801B-EC34-4B71-8305-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
>> >> news:2C6C68ED-CCC3-4281-96C1-(E-Mail Removed)...
>> >> > 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/8000xxxx...78-errors.html
>> >> >>
>> >> >> What is your strSQL calling for
>> >> >> --
>> >> >>
>> >> >> _____________________________________________
>> >> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> >> >> "Warning - Using the F1 Key will not break anything!" (-;
>> >> >> _____________________________________________
>> >> >>
>> >> >>
>> >> >> "Rick" <(E-Mail Removed)> wrote in message
>> >> >> news:948C8181-B76C-455F-B710-(E-Mail Removed)...
>> >> >> | 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
>> >> >> |
>> >> >> |
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
> news:C209514C-059F-4337-A196-(E-Mail Removed)...
> > 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...b;en-us;286335
>
>
>
> > "Kathleen Anderson" wrote:
> >
> >> Name and key are both reserved words in Access 2002 and in later versions
> >> of
> >> Access http://support.microsoft.com/default...b;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" <(E-Mail Removed)> wrote in message
> >> news:708E801B-EC34-4B71-8305-(E-Mail Removed)...
> >> > 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" <(E-Mail Removed)> wrote in message
> >> >> news:2C6C68ED-CCC3-4281-96C1-(E-Mail Removed)...
> >> >> > 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/8000xxxx...78-errors.html
> >> >> >>
> >> >> >> What is your strSQL calling for
> >> >> >> --
> >> >> >>
> >> >> >> _____________________________________________
> >> >> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> >> >> >> "Warning - Using the F1 Key will not break anything!" (-;
> >> >> >> _____________________________________________
> >> >> >>
> >> >> >>
> >> >> >> "Rick" <(E-Mail Removed)> wrote in message
> >> >> >> news:948C8181-B76C-455F-B710-(E-Mail Removed)...
> >> >> >> | 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
> >> >> >> |
> >> >> >> |
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>