How can I get my asp application to access a database on my domain, from my subdomain

[buynorwex]

I am using a member area manager program, and have subdomains on my website. My challenge is that I want the program to access the same database (on the domain) from both subdomains. The file I've been told to change is this:

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO" 
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
MM_membersareamanager_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/databases/MembersAreaManager.mdb") & ";"
%>
 

I've been instructed to change it to call on the main domain, but am at a loss as to how to do this. Any advice would be greatly appreciated.

[Rabbit]

Please use code tags

I've never used ASP but I suspect they want you to use the absolute path instead of a relative path.

i.e. C:\Website\Database.mdb rather than

\Website\Database.mdb

[missinglinq]

This really is an ASP question, I think, so I'm going to move it over to that side of the fence!

Welcome to TheScripts!

Linq ;0)>

[jaxjagfan]

The location of the database is relative to the root folder of the site. If you have your db in a subfolder of the website's root folder then your connection string would be \mydbfolder\mydb.mdb. Same goes for images and other items \images\myimage.jpg. The domain/subdomain should not be an issue - if the users have access to the site and the appropiate db drivers (Access) are set up then users should be able to retrieve data via your asp pages.

I am not positive how to do this if and when the db resides outside the rootfolder structure.