Problem connecting to a remote DB

[EdRev]

I am trying to connect to an Access database that resides in another server. This is my connection string and it does not seem to be connecting. Database is not password-protected.

sConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\mysever\testDB.mdb"

where myserver is the name of the remote server.

Any help will be greatly appreciated.

 

[Sheco]

The default ASP security is anonymous access using an account that is local to the web server rather than a network account. This is done because, if some hacker were to gain control of ASP it would limit the damage done to other machines on your network.

On the other hand, sometimes when you need ASP to talk to other machines... in these cases you can override the default security. You could override it for your entire web app but it is best to only override for the specific ASP file that needs remote access. You can change these permissions by using the IIS admin tool. The name of the default local account is IUSR_<MachineName> except for use the name of the web server instead of MachineName[/b]

 

[Sheco]

Oh, and if you want each user to connect to the MDB using his or her own credentials then use windows authentication.

On the other hand, if not all of your users have a network account with permission to the file itself then you can specify a specific shared network account to be used by everyone's anonymous access... it just needs to be a network account instead of a local account.

Hope that makes sense.