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


"Brian Royston" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>

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


"Brian Royston" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>

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.


"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
> ==============================================
>
>
> "Brian Royston" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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
>>
>
>

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


"David Berry" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>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.
>
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>> 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
>> ==============================================
>>
>>
>> "Brian Royston" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> 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
>>>
>>
>>
>
>

If you're using straight ASP (and not the DRW) it will work with OLEDB.


"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
> ==============================================
>
>
> "David Berry" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>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.
>>
>>
>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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
>>> ==============================================
>>>
>>>
>>> "Brian Royston" <(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>> 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
>>>>
>>>
>>>
>>
>>
>
>

Correct.

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

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


"David Berry" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
> If you're using straight ASP (and not the DRW) it will work with OLEDB.
>
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>> 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
>> ==============================================
>>
>>
>> "David Berry" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>>>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.
>>>
>>>
>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> 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
>>>> ==============================================
>>>>
>>>>
>>>> "Brian Royston" <(E-Mail Removed)> wrote in message
>>>> news:%(E-Mail Removed)...
>>>>> 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
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

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

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Correct.
>
> --
> ==============================================
> Thomas A. Rowe
> Microsoft MVP - FrontPage
>
> http://www.Ecom-Data.com
> ==============================================
>
>
> "David Berry" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> If you're using straight ASP (and not the DRW) it will work with OLEDB.
>>
>>
>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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
>>> ==============================================
>>>
>>>
>>> "David Berry" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>>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.
>>>>
>>>>
>>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>> 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
>>>>> ==============================================
>>>>>
>>>>>
>>>>> "Brian Royston" <(E-Mail Removed)> wrote in message
>>>>> news:%(E-Mail Removed)...
>>>>>> 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
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

See inline below

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

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


"Brian Royston" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?

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?

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.

>
> Apologies if these are remedial questions but this is my first attempt so still on a learning
> curve.
>
> Thanks
>
> Brian
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>> Correct.
>>
>> --
>> ==============================================
>> Thomas A. Rowe
>> Microsoft MVP - FrontPage
>>
>> http://www.Ecom-Data.com
>> ==============================================
>>
>>
>> "David Berry" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
>>> If you're using straight ASP (and not the DRW) it will work with OLEDB.
>>>
>>>
>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> 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
>>>> ==============================================
>>>>
>>>>
>>>> "David Berry" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>>>>>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.
>>>>>
>>>>>
>>>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>>>> news:(E-Mail Removed)...
>>>>>> 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
>>>>>> ==============================================
>>>>>>
>>>>>>
>>>>>> "Brian Royston" <(E-Mail Removed)> wrote in message
>>>>>> news:%(E-Mail Removed)...
>>>>>>> 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
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Thank you all

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> See inline below
>
> --
> ==============================================
> Thomas A. Rowe
> Microsoft MVP - FrontPage
>
> http://www.Ecom-Data.com
> ==============================================
>
>
> "Brian Royston" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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?
>
> 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?
>
> 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.
>
>>
>> Apologies if these are remedial questions but this is my first attempt so
>> still on a learning curve.
>>
>> Thanks
>>
>> Brian
>>
>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Correct.
>>>
>>> --
>>> ==============================================
>>> Thomas A. Rowe
>>> Microsoft MVP - FrontPage
>>>
>>> http://www.Ecom-Data.com
>>> ==============================================
>>>
>>>
>>> "David Berry" <(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>> If you're using straight ASP (and not the DRW) it will work with OLEDB.
>>>>
>>>>
>>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>> 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
>>>>> ==============================================
>>>>>
>>>>>
>>>>> "David Berry" <(E-Mail Removed)> wrote in message
>>>>> news:(E-Mail Removed)...
>>>>>>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.
>>>>>>
>>>>>>
>>>>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>>>>> news:(E-Mail Removed)...
>>>>>>> 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
>>>>>>> ==============================================
>>>>>>>
>>>>>>>
>>>>>>> "Brian Royston" <(E-Mail Removed)> wrote in message
>>>>>>> news:%(E-Mail Removed)...
>>>>>>>> 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
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>