Added: October/15/2005 at 10:40pm | IP Logged

is there any way of doing the folllowing, we have 2 domain names on a server and an MS Access database on site A but would also like to use this database for site B.

Is there a way of doing a connection string that uses the data in either domain.

Added: October/16/2005 at 2:38pm | IP Logged

sure, if all the sites and the access database are on the same server.

just use a dsn-less connection that specifies the exact physical path to the database file including the drive letter.

sorta like this example though there are other ways to do it as well.

ConnectionString = "DBQ=C:\Inetpub\wwwroot\somesite\data\somedatabase.mdb;Driver ={Microsoft Access Driver (*.mdb)};"

If ya dont know the physical path ask the server admins or read my article.
http://www.powerasp.com/content/hintstips/physical-path.asp

Added: May/27/2006 at 8:37am | IP Logged

cwilliams: this doesnt work at his situation, because the server.mappath give u the physical location of the server the page is at not from other server, and that is impossible, because if it works, then it will be a security breach

nobby: the soulution for ur problem cant be done directly, u have to access the database through normal asp pages, by sending a command from page on server A to page on server B that the page on B will only understand

for example, when u post a form data let the action be to a page at server B and on that page put an if statement that says if the page at B recives a certian command then open the database an output the folloeing records and then post them back to the page at server A with a command, and the page at A will read that command and understnads that the following information was posted back from the page at server B then it will show it to the user

in other words, you have accessed the database using a gateway which a page on the other server

hope this helps

Regards