i want to know how to configure iis in order to access a remote microsoft access database
in asp.net.permission how should it be,anonymous iis usrs,...
any exact information pls
well anonymous should be selected. i think accessing the mdb database is not a problem , all you need to do is to make sure that the connection string is correct. Try to access the db and get errors and we will tell you what is the problem. atleast attempt
it is a big problem i am trying every thing and useless
i am writing an application on my pc to insert record on a microsoft access database on another pc that has static ip address remotely.i can ping the remote address of the pc that i want to access without problems.the access database is in the folder c:\inetpub\wwwroot\db.mdb.
i have the code below but when i run i am getting the following error:
error on ther server the object model couldnºt be found
the code is :
<%@ LANGUAGE = VB Debug="true" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Net.Mail" %>
<%@ Import Namespace= "System.Web.UI.WebControls.Menu" %>
<%@ Import Namespace="System.Data" %>
<script Runat="Server" language="VB">
public sub button_click(s as object,e as EventArgs)
dim ssql as string
Dim ds As New DataSet
Dim da As OleDbDataAdapter = New OleDbDataAdapter
objconn=new oledbconnection("Provider=MS Remote; Remote Server=http://126.96.36.199; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\db.mdb;Persist Security Info=False")
dbcomm.commandtext="insert into employee values ('mostafa',7,'tanzania')"
dbcomm.Connection = objconn