asp_database_setup thread: How to connect to a DB located in another web site (same server/hotel)
Some help needed please,
How to connect to a DB located in another web site (same server/hotel)
I have 2 websites on the same IIS 5.0 server.
a: D:\Inetpub\wwwroot\gem\
b: D:\Inetpub\wwwroot\gemint\
and I would like both sites to share (have access) to the same access 2000
database located in D:\Inetpub\wwwroot\gem\base\123.mdb.
Web site A works fine with this connection string:
Source=D:\Inetpub\wwwroot\gem\base\123.mdb; Persist Security Info=False"
But when I try to use the same string for web site B I get this
error "HTTP error code 403 Forbidden" and sometimes also
"Unable to create remote folder gemint/_mmDBScripts"
I am using Ultradev 4, but I dont think this is the problem at the moment
(Using Custom Connection String, and Connect using Driver on Application
Server)
I now hope I have provided all the nessary information.
Is there a trick/method to let 2 web sites share the same DB? Do you know
of any artickels.
Regards,
Chrilles, Copenhagen