cannot export a MSaccess file to web folder.

[Guest]

Hello.
I have encounter another problem with a database I created using MSAccess and using the add database results from frontpage.
Unitl recently I had been testing the database locally, now I finally got a website name register and a web host. But when I try to create the same database(still using frontpage) in my live site I get the following message when I try to save the MS database to a folder in my web.
error message
"only XML files can be exported to an internet address (http://, Ftp://). Enter a path that points to a location on your computer or on the network"
Thank you for any advice

 

[Thomas A. Rowe]

You need to drag/drop or import the database into your current open FP web
or use the database component to create the database within the current open
FP web.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

Hello.
I have encounter another problem with a database I created using MSAccess

and using the add database results from frontpage.

Unitl recently I had been testing the database locally, now I finally got

a website name register and a web host. But when I try to create the same
database(still using frontpage) in my live site I get the following message
when I try to save the MS database to a folder in my web.

error message
"only XML files can be exported to an internet address (http://, Ftp://).

Enter a path that points to a location on your computer or on the network"

 

[Guest]

it doesnt work I tried drag/dropping it in to the folder in the live web, but it once the file is in that folder I cannot open it.

 

[David Berry]

When you say you cannot "open" it, what do you mean? Do you mean you can't
open it and launch Access? You may need to contact your web host and see if
there's a special directory you should be putting your database in. Then
you should ask them to set up a System DSN (ODBC) connection for you to
access it. Once that's done go to Tools, Web Settings, Database and either
add it or "verify" it so FrontPage will create the needed folders (like
fpdb)

--
David Berry - MCP
Microsoft MVP - FrontPage
FrontPage Support: http://www.net-sites.com/sitebuilder/
-----------------------------------

-----------------------------------

it doesnt work I tried drag/dropping it in to the folder in the live web,

but it once the file is in that folder I cannot open it.

 

[Guest]

I have a ODBC, and a folder. I have place my MSAccess named RepairsDatabse file to the folder.
Once I began creating the database from the Database results wizard I encounter the following error message:

"The serve encounter an error while processing a database request.
Server error: Unable to connect to a database from the web server using the connection string 'DSN=RepairsDatabase;DRIVER={Driver do Microsoft Access (*.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.

 

[Thomas A. Rowe]

How are you placing the database within your web?

Open the web directly in FP, then import the database into the web, FP will
prompt you create a connection, enter RepairsDatabase, then FP will prompt
you for permission to move the database to the fpdb folder, let FP do this.
Then Tools | Web Settings | Database verify the connection.

In order to test the connection and run your ASP pages, you must access the
pages via http://localhost/pagename.asp on your local machine or you will
have to wait until you have published the site to a remote Windows IIS
server that has the FP2000 or FP2002 extensions.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

I have a ODBC, and a folder. I have place my MSAccess named

RepairsDatabse file to the folder.

Once I began creating the database from the Database results wizard I

encounter the following error message:

"The serve encounter an error while processing a database request.
Server error: Unable to connect to a database from the web server using

the connection string 'DSN=RepairsDatabase;DRIVER={Driver do Microsoft
Access (*.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] Could not find file '(unknown)'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)"