Database results using databases in secure subwebs

[Mary Ann Hailey]

Hi! I have a public web and several secure subwebs directly under the public
web. I have databases in each secure subweb with similar, web-specific data.
I have created a new database in my public web and have linked tables in MS
Access (using a union query) from all of the subwebs and created a new query
to get the results I want. I created a new .asp page and connected to the new
database connection and query, but am not getting any database results. I am
administrator on all of the webs. I can't figure out if this isn't working
because of the database links or permissions or what. I'm still relatively
new to FrontPage and could sure use some Help!

 

[Stefan B Rusynko]

When using subwebs that have Access DB's the DBRW does not recognize any Access DB that are also not in the root web
- Check Tools Site Settings Database to see the ones connected in the root web

Normally to avoid duplicating DB in the root & subwebs
- you should work with your host to put all your DBs in a folder out side of the web and use a system DSN for the connection at any
level of your site

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Hi! I have a public web and several secure subwebs directly under the public
| web. I have databases in each secure subweb with similar, web-specific data.
| I have created a new database in my public web and have linked tables in MS
| Access (using a union query) from all of the subwebs and created a new query
| to get the results I want. I created a new .asp page and connected to the new
| database connection and query, but am not getting any database results. I am
| administrator on all of the webs. I can't figure out if this isn't working
| because of the database links or permissions or what. I'm still relatively
| new to FrontPage and could sure use some Help!

 

[Mary Ann Hailey]

Thank you! If I am understanding this correctly, I was on the wrong track
completely. What I was trying will not work. The prev webmaster put the
databases into each of their respective subweb fpdb folders. Now the company
wants to be able to get data from each subweb db to compile it, or acess it
from any of the subwebs. Am I understanding correctly? All of 25+ databases
need to be in the fpdb folder of the root web. Once there, I would need to
rework each webpage results page, etc.. in all of the subwebs for the new
location. I think that I am on the right track now. Not sure how to proceed
yet. This will be a daunting task, but thank you very much for your help.
Mary Ann

 

[Mary Ann Hailey]

I have another question on this. If I move all the databases up to the root
level, if that root web is not PW protected, and all the subwebs are, does
that leave the databases in the root web unsecure?

 

[Kathleen Anderson]

Stefan:
I keep many Access databases in their own subwebs (on many different sites
and servers) and have never had a problem with the DBRW.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Stefan B Rusynko]

The OP is trying to access 25 dbs in 25 subweb db's from the root web in a DBRW in the root web

It might work, w/o moving all the DBs to the root, if she creates a database connection for all 25 DBs in Tools Site Settings
Database in the root web
(so the root web global.asa has all 25 connections in it)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Stefan:
| I keep many Access databases in their own subwebs (on many different sites
| and servers) and have never had a problem with the DBRW.
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| Expression Web Resources: http://www.spiderwebwoman.com/xweb/
| Expression Web Wiki: http://expression-web-wiki.com/
| FrontPage Resources: http://www.spiderwebwoman.com/resources/
| Please reply to the newsgroup for the benefit of others
|
|
|
| | > When using subwebs that have Access DB's the DBRW does not recognize any
| > Access DB that are also not in the root web
| > - Check Tools Site Settings Database to see the ones connected in the root
| > web
| >
| > Normally to avoid duplicating DB in the root & subwebs
| > - you should work with your host to put all your DBs in a folder out side
| > of the web and use a system DSN for the connection at any
| > level of your site
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > message
| > | > | Hi! I have a public web and several secure subwebs directly under the
| > public
| > | web. I have databases in each secure subweb with similar, web-specific
| > data.
| > | I have created a new database in my public web and have linked tables in
| > MS
| > | Access (using a union query) from all of the subwebs and created a new
| > query
| > | to get the results I want. I created a new .asp page and connected to
| > the new
| > | database connection and query, but am not getting any database results.
| > I am
| > | administrator on all of the webs. I can't figure out if this isn't
| > working
| > | because of the database links or permissions or what. I'm still
| > relatively
| > | new to FrontPage and could sure use some Help!
| >
| >
|
|

 

[Mary Ann Hailey]

I have tried setting up the system DSN to connect the databases. I was able
to remote connect out to the server, set up a systemDSN on the server to
connect to the 'test' database I set up. I am able to verify the database
connection under Tools, Site Settings, database on both the server and my
local PC.

I have tried using both ODBC and MS Access drivers but get messages similar
to the following when I try to create a DBRW - this example is from the
attempt at using the MS Access Driver.
Server error: Unable to retrieve the list of record sources from a database
using the connection string:

DSN=test;DRIVER={Microsoft Access Driver (*.mdb)}.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
Source: ADO
Number: -2146824584 (0x800a0e78)

I did copy the global.asa file back - I can see the dsn connections, so I
know that part worked. I sure appreciate any help on what I am doing wrong.
Thank you!