Trying to establish connection to MS Access database

[Carol]

Hi -

I'm trying to connect my FP website to an Access
database. I have been unable to do so, even though I've
uploaded my .mdb file to my host's server and tried to
establish the correct DSN connection.

Is there something that I need to do in Front Page that
to connect the database to the website? I've already
imported the .mdb file into the fpdb folder.

Thanks!

 

[Don]

How are you trying to connect?
Have you mad the .asp pages?
Did the connection work then?

Don
===================
| Hi -
|
| I'm trying to connect my FP website to an Access
| database. I have been unable to do so, even though I've
| uploaded my .mdb file to my host's server and tried to
| establish the correct DSN connection.
|
| Is there something that I need to do in Front Page that
| to connect the database to the website? I've already
| imported the .mdb file into the fpdb folder.
|
| Thanks!
|
|

 

[Thomas A. Rowe]

You have publish to the server via FP, and the server is Windows IIS and you have the ability to run
ASP based application?

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

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

 

[Carol]

Hi -

I've created the .asp pages and have published them to
the site. The pages with query results will not display
because the database and website are not connected
properly.

I have no idea what I'm doing wrong.

Thanks!

 

[Don]

Does your server have FrontPage extensions installed?

To find out try this
http://www.dnswiz.com/fptype.htm

Don
===============
| Hi -
|
| I've created the .asp pages and have published them to
| the site. The pages with query results will not display
| because the database and website are not connected
| properly.
|
| I have no idea what I'm doing wrong.
|
| Thanks!
|
|
| >-----Original Message-----
| >How are you trying to connect?
| >Have you mad the .asp pages?
| >Did the connection work then?
| >
| >Don
| >===================
| message
| >| >| Hi -
| >|
| >| I'm trying to connect my FP website to an Access
| >| database. I have been unable to do so, even though
| I've
| >| uploaded my .mdb file to my host's server and tried to
| >| establish the correct DSN connection.
| >|
| >| Is there something that I need to do in Front Page that
| >| to connect the database to the website? I've already
| >| imported the .mdb file into the fpdb folder.
| >|
| >| Thanks!
| >|
| >|
| >
| >
| >.
| >

 

[Andrew Murray]

initially, once you create the form, then you need to go and rightclick the form,
form properties and send to database, then choose to create a new database, or
connect to an existing DB. Frontpage will do the connecting for you, and add
the connection code to the asa file, which you need to upload with the form page
and the mdb file.

You need to publish to a server running IIS and ASP with FP server ext.