Last post Oct 29, 2011 04:03 PM by Mikesdotnetting
Oct 28, 2011 05:35 AM|chandana|LINK
I have this kind of requirement
There is two computer A and B ,A computer has an IIS server and run a website, B computer has Access database
So I need to
Create ODBC in A computer using B computer’s Access Database and then connect it using A computer IIS server. I already test it for windows application created in A computer. But when I access through IIS (for web site) it gives the error message saying
it is invalid path. How can I solve this?
In addition to that, B computer is given access only for specific domain user.
Oct 28, 2011 06:06 AM|hans_v|LINK
First of all, you better use the System.Data.OleDb namespace when using Access databases
When you want to connect to an Access database, the ASP.NET user needs to have Modify permissions on the folder where the database is located:
Oct 28, 2011 06:28 AM|chandana|LINK
The problem is database locate on another computer and giving it to permission. So how can I handle this. I can navigate that locaction & open DB too. But when I run the website it fail.
Oct 29, 2011 04:03 PM|Mikesdotnetting|LINK
You need to mess about synchronising the accounts on each computer.
Note that many articles are quite old and refer to Server 2000/XP, where the anonymous user account was IUSR_machineName. It's NETWORK SERVICE on Server 2003+