database results wizard error

[Rick]

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

 

[Stefan B Rusynko]

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!" (-;
_____________________________________________


| 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
|
|

 

[Rick]

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

 

[Kathleen Anderson]

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

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

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!" (-;
_____________________________________________


| 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
|
|

 

[Rick]

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.

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

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

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!" (-;
_____________________________________________


| 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
|
|

 

[Kathleen Anderson]

Name and key are both reserved words in Access 2002 and in later versions of
Access http://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

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.

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

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


:

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!" (-;
_____________________________________________


| 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
|
|

 

[Rick]

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

Name and key are both reserved words in Access 2002 and in later versions of
Access http://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

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.

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


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


:

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!" (-;
_____________________________________________


| 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
|
|

 

[Thomas A. Rowe]

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
==============================================

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

Name and key are both reserved words in Access 2002 and in later versions of
Access http://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

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.


:

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


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


:

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!" (-;
_____________________________________________


| 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
|
|

 

[Kathleen Anderson]

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

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

Name and key are both reserved words in Access 2002 and in later versions
of
Access http://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

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.


:

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


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


:

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!" (-;
_____________________________________________


| 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
|
|

 

[Rick]

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.

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

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

Name and key are both reserved words in Access 2002 and in later versions
of
Access http://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


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.


:

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


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


:

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!" (-;
_____________________________________________


| 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
|
|

 

[Kathleen Anderson]

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

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.

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

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

:

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


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.


:

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


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


:

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!" (-;
_____________________________________________


| 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
|
|

 

[Rick]

i have tried using the database interface wizard to create a new database and
add it to the current web, same error. i have tried using different names.
the name "delivery" is what i want to use, since the db will be used to tract
deliveries of products.
what i have also done is to download the office 2003 service pack, i have
repaired fp2003, i have repaired office 2007.
i have imported a database that was created under fp2002. the import started
the wizard and at the end of the import, i got the same error as when i
created a new database using the interface wizard. i have checked my remote
site and it is setup for frontpage or sharepoint services. it is actually
being hosted on an iis webserver thru enterhost.

thanks

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

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.

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


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



:

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


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.


:

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


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


:

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!" (-;
_____________________________________________


| 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
|
|