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.
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.
Note that the article is quite old and refers to Server 2000/XP, where the anonymous user account was IUSR_machineName. It's NETWORK SERVICE on Server 2003+
chandana
Participant
1356 Points
378 Posts
ODBC access Through IIS
Oct 28, 2011 09:35 AM|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.
Thanks
hans_v
All-Star
35986 Points
6550 Posts
Re: ODBC access Through IIS
Oct 28, 2011 10:06 AM|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:
http://www.mikesdotnetting.com/Article/74/Solving-the-Operation-Must-Use-An-Updateable-Query-error
chandana
Participant
1356 Points
378 Posts
Re: ODBC access Through IIS
Oct 28, 2011 10:28 AM|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.
Mikesdotnett...
All-Star
154905 Points
19866 Posts
Moderator
MVP
Re: ODBC access Through IIS
Oct 29, 2011 08:03 PM|LINK
You need to mess about synchronising the accounts on each computer: http://databases.aspfaq.com/database/why-can-t-i-access-a-database-or-text-file-on-another-server.html
Note that the article is quite old and refers to Server 2000/XP, where the anonymous user account was IUSR_machineName. It's NETWORK SERVICE on Server 2003+
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter