Connect to Remote DB

[MaureenKLM]

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!

 

[Kathleen Anderson]

This might help: Connecting Your Form to an External Database


http://www.microsoftfrontpage.com/c...#Connecting Your Form to an External Database

--

~ 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]

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.

 

[Thomas A. Rowe]

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]

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]

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

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

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