Database connections how do I

  • Thread starter Thread starter Brian Royston
  • Start date Start date
B

Brian Royston

Hi

I have a database in my root from which I want members of my club to enter
their details. I then want to be able to access that same database from a
subweb would appreciate any info on how to

Thanks in advance
 
In your sub web create a connection to where the database is using Tools,
Site Settings, Database
 
If you are storing the database within your web site, then the database must be within the same web
/ subweb that you will be access it from your pages.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
A database can exist anywhere in the web, or sub web, or even outside of the
web. All you need to know is the path to the database (to use OLE DB) or
set up a System DSN. Each sub web must have it's own global.asa but the
database can live anywhere. Some web hosts don't even put it in the web.
 
Not when using the FP database components to connect via the file system, as FP can not set
permissions outside of the specific web.

If using a System DSN, then you are correct, the database can be any place on the server.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
Thanks for all that much appreciated and I think understood mostly so lets
see.

1/ FP is unable to create a connection to a database in another web.

2/ To create a connection I am going to have to use ASP code in my page to
create the connection?

3/ The bit I didn't quite understand was the DSN! I already have a
connection on my server to my database setup via the server control panel
i.e. DBQ string. I also have a connection via ODBC admin tools on my laptop.
Can I not just create another connection to that from my subweb? Or is it
possible to doctor the global.asa in the subweb to force it to look in a
different directory?

Apologies if these are remedial questions but this is my first attempt so
still on a learning curve.

Thanks

Brian
 
See inline below

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================


Brian Royston said:
Thanks for all that much appreciated and I think understood mostly so lets see.

1/ FP is unable to create a connection to a database in another web.
Correct.


2/ To create a connection I am going to have to use ASP code in my page to create the connection?
Click to expand...

Correct, you will have to manually write the code to create the connections.
3/ The bit I didn't quite understand was the DSN! I already have a connection on my server to my
database setup via the server control panel i.e. DBQ string. I also have a connection via ODBC
admin tools on my laptop. Can I not just create another connection to that from my subweb? Or is
it possible to doctor the global.asa in the subweb to force it to look in a different directory?
Click to expand...

I always use a System DSN, which allows me to have the database anywhere on the web server and to
have it in a different location on my local system without me having to remember to change any
connection strings when publishing.
 
Thank you all

Thomas A. Rowe said:
See inline below

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================




Correct, you will have to manually write the code to create the
connections.


I always use a System DSN, which allows me to have the database anywhere
on the web server and to have it in a different location on my local
system without me having to remember to change any connection strings when
publishing.
Click to expand...
 
Back
Top