I am using FP 2002 - have many sites. Two sites are stored on the the same
server (different URL's and directories on the server), both have MS ACCESS
databases.
I want to create a DBR report on a page in SITE #1 that gets it's info from
the database stored with the web files for SITE #2. In other words, I want to
produce a DBR on a page within a site that access the records stored in
another website's db. Both databases are stored on the same server but the
URLs and directories are unique. I'm having trouble setting up the ODBC -
can this be done and can anyone give me a littel direction?

THANKS!

This might help: Connecting Your Form to an External Database


http://www.microsoftfrontpage.com/content/articles/datintro. html#Connecting%20Your%20Form%20to%20an%20External%20Databas e

--

~ 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






"MaureenKLM" <MaureenKLM [at] discussions.microsoft.com> wrote in message
news:D2C4B123-DB47-4CD9-BF33-3AEDA7CB0867 [at] microsoft.com...
>I am using FP 2002 - have many sites. Two sites are stored on the the same
> server (different URL's and directories on the server), both have MS
> ACCESS
> databases.
> I want to create a DBR report on a page in SITE #1 that gets it's info
> from
> the database stored with the web files for SITE #2. In other words, I want
> to
> produce a DBR on a page within a site that access the records stored in
> another website's db. Both databases are stored on the same server but
> the
> URLs and directories are unique. I'm having trouble setting up the ODBC -
> can this be done and can anyone give me a littel direction?
>
> THANKS!
>
>

Thank you - but that article did not cover what I am trying to accomplish. I
want to create a Database Results in Web#1 using the records in an access
database that is stored/saved as part of a totally separate website (Web#2).
Using the DBRW, I am uncertain how to create the new DB Connection from Web#1
into Web#2.

I assume I use the custom definition box to create the new connection - what
is the correct syntax to use when entering the URL location of the database I
wish to connect to (I've tried several options but can't get it to work). I
am using the correct userID and pswd.


"Kathleen Anderson" wrote:

> This might help: Connecting Your Form to an External Database
>
>
> http://www.microsoftfrontpage.com/content/articles/datintro. html#Connecting%20Your%20Form%20to%20an%20External%20Databas e
>
> --
>
> ~ 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
>
>
>
>
>
>
> "MaureenKLM" <MaureenKLM [at] discussions.microsoft.com> wrote in message
> news:D2C4B123-DB47-4CD9-BF33-3AEDA7CB0867 [at] microsoft.com...
> >I am using FP 2002 - have many sites. Two sites are stored on the the same
> > server (different URL's and directories on the server), both have MS
> > ACCESS
> > databases.
> > I want to create a DBR report on a page in SITE #1 that gets it's info
> > from
> > the database stored with the web files for SITE #2. In other words, I want
> > to
> > produce a DBR on a page within a site that access the records stored in
> > another website's db. Both databases are stored on the same server but
> > the
> > URLs and directories are unique. I'm having trouble setting up the ODBC -
> > can this be done and can anyone give me a littel direction?
> >
> > THANKS!
> >
> >
>
>
>

Not possible when using the FP database components.

You would have to hand code this, and you web host would have to set permissions to allow two
accounts / domains to share a database.

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

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


"MaureenKLM" <MaureenKLM [at] discussions.microsoft.com> wrote in message
news:DDB0E4D4-AFE6-4619-B60B-1BD1C9CC71B1 [at] microsoft.com...
> Thank you - but that article did not cover what I am trying to accomplish. I
> want to create a Database Results in Web#1 using the records in an access
> database that is stored/saved as part of a totally separate website (Web#2).
> Using the DBRW, I am uncertain how to create the new DB Connection from Web#1
> into Web#2.
>
> I assume I use the custom definition box to create the new connection - what
> is the correct syntax to use when entering the URL location of the database I
> wish to connect to (I've tried several options but can't get it to work). I
> am using the correct userID and pswd.
>
>
> "Kathleen Anderson" wrote:
>
>> This might help: Connecting Your Form to an External Database
>>
>>
>> http://www.microsoftfrontpage.com/content/articles/datintro. html#Connecting%20Your%20Form%20to%20an%20External%20Databas e
>>
>> --
>>
>> ~ 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
>>
>>
>>
>>
>>
>>
>> "MaureenKLM" <MaureenKLM [at] discussions.microsoft.com> wrote in message
>> news:D2C4B123-DB47-4CD9-BF33-3AEDA7CB0867 [at] microsoft.com...
>> >I am using FP 2002 - have many sites. Two sites are stored on the the same
>> > server (different URL's and directories on the server), both have MS
>> > ACCESS
>> > databases.
>> > I want to create a DBR report on a page in SITE #1 that gets it's info
>> > from
>> > the database stored with the web files for SITE #2. In other words, I want
>> > to
>> > produce a DBR on a page within a site that access the records stored in
>> > another website's db. Both databases are stored on the same server but
>> > the
>> > URLs and directories are unique. I'm having trouble setting up the ODBC -
>> > can this be done and can anyone give me a littel direction?
>> >
>> > THANKS!
>> >
>> >
>>
>>
>>

Thanks again. I appreciate the support.

FYI: for future users - I got around this by using frames in Web#1 that
linked to a specific page in WEB#2 which displayed the correct DBR that I
wanted.

"Thomas A. Rowe" wrote:

> Not possible when using the FP database components.
>
> You would have to hand code this, and you web host would have to set permissions to allow two
> accounts / domains to share a database.
>
> --
> ==============================================
> Thomas A. Rowe
> Microsoft MVP - FrontPage
>
> http://www.Ecom-Data.com
> ==============================================
>
>
> "MaureenKLM" <MaureenKLM [at] discussions.microsoft.com> wrote in message
> news:DDB0E4D4-AFE6-4619-B60B-1BD1C9CC71B1 [at] microsoft.com...
> > Thank you - but that article did not cover what I am trying to accomplish. I
> > want to create a Database Results in Web#1 using the records in an access
> > database that is stored/saved as part of a totally separate website (Web#2).
> > Using the DBRW, I am uncertain how to create the new DB Connection from Web#1
> > into Web#2.
> >
> > I assume I use the custom definition box to create the new connection - what
> > is the correct syntax to use when entering the URL location of the database I
> > wish to connect to (I've tried several options but can't get it to work). I
> > am using the correct userID and pswd.
> >
> >
> > "Kathleen Anderson" wrote:
> >
> >> This might help: Connecting Your Form to an External Database
> >>
> >>
> >> http://www.microsoftfrontpage.com/content/articles/datintro. html#Connecting%20Your%20Form%20to%20an%20External%20Databas e
> >>
> >> --
> >>
> >> ~ 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
> >>
> >>
> >>
> >>
> >>
> >>
> >> "MaureenKLM" <MaureenKLM [at] discussions.microsoft.com> wrote in message
> >> news:D2C4B123-DB47-4CD9-BF33-3AEDA7CB0867 [at] microsoft.com...
> >> >I am using FP 2002 - have many sites. Two sites are stored on the the same
> >> > server (different URL's and directories on the server), both have MS
> >> > ACCESS
> >> > databases.
> >> > I want to create a DBR report on a page in SITE #1 that gets it's info
> >> > from
> >> > the database stored with the web files for SITE #2. In other words, I want
> >> > to
> >> > produce a DBR on a page within a site that access the records stored in
> >> > another website's db. Both databases are stored on the same server but
> >> > the
> >> > URLs and directories are unique. I'm having trouble setting up the ODBC -
> >> > can this be done and can anyone give me a littel direction?
> >> >
> >> > THANKS!
> >> >
> >> >
> >>
> >>
> >>
>
>
>

FYI: Users can block Frame/IFrame content that crosses domains.

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

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


"MaureenKLM" <MaureenKLM [at] discussions.microsoft.com> wrote in message
news:07328BFF-EC7B-4CC7-BDA7-4514720E2FAB [at] microsoft.com...
> Thanks again. I appreciate the support.
>
> FYI: for future users - I got around this by using frames in Web#1 that
> linked to a specific page in WEB#2 which displayed the correct DBR that I
> wanted.
>
> "Thomas A. Rowe" wrote:
>
>> Not possible when using the FP database components.
>>
>> You would have to hand code this, and you web host would have to set permissions to allow two
>> accounts / domains to share a database.
>>
>> --
>> ==============================================
>> Thomas A. Rowe
>> Microsoft MVP - FrontPage
>>
>> http://www.Ecom-Data.com
>> ==============================================
>>
>>
>> "MaureenKLM" <MaureenKLM [at] discussions.microsoft.com> wrote in message
>> news:DDB0E4D4-AFE6-4619-B60B-1BD1C9CC71B1 [at] microsoft.com...
>> > Thank you - but that article did not cover what I am trying to accomplish. I
>> > want to create a Database Results in Web#1 using the records in an access
>> > database that is stored/saved as part of a totally separate website (Web#2).
>> > Using the DBRW, I am uncertain how to create the new DB Connection from Web#1
>> > into Web#2.
>> >
>> > I assume I use the custom definition box to create the new connection - what
>> > is the correct syntax to use when entering the URL location of the database I
>> > wish to connect to (I've tried several options but can't get it to work). I
>> > am using the correct userID and pswd.
>> >
>> >
>> > "Kathleen Anderson" wrote:
>> >
>> >> This might help: Connecting Your Form to an External Database
>> >>
>> >>
>> >> http://www.microsoftfrontpage.com/content/articles/datintro. html#Connecting%20Your%20Form%20to%20an%20External%20Databas e
>> >>
>> >> --
>> >>
>> >> ~ 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
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> "MaureenKLM" <MaureenKLM [at] discussions.microsoft.com> wrote in message
>> >> news:D2C4B123-DB47-4CD9-BF33-3AEDA7CB0867 [at] microsoft.com...
>> >> >I am using FP 2002 - have many sites. Two sites are stored on the the same
>> >> > server (different URL's and directories on the server), both have MS
>> >> > ACCESS
>> >> > databases.
>> >> > I want to create a DBR report on a page in SITE #1 that gets it's info
>> >> > from
>> >> > the database stored with the web files for SITE #2. In other words, I want
>> >> > to
>> >> > produce a DBR on a page within a site that access the records stored in
>> >> > another website's db. Both databases are stored on the same server but
>> >> > the
>> >> > URLs and directories are unique. I'm having trouble setting up the ODBC -
>> >> > can this be done and can anyone give me a littel direction?
>> >> >
>> >> > THANKS!
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>