Member Avatar for khaled_jawaher

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
thanks

  • 2 Contributors
  • 2 Replies
  • 142 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by khaled_jawaher
Member Avatar for vuyiswamb

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
thanks

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

Member Avatar for khaled_jawaher

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
OleDbException 0x800a2011
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 strconn,objconn,rs,dbcomm
Dim ds As New DataSet
Dim da As OleDbDataAdapter = New OleDbDataAdapter
objconn=new oledbconnection("Provider=MS Remote; Remote Server=http://196.45.161.123; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\db.mdb;Persist Security Info=False")
objconn.open ()
dbcomm=New Oledbcommand("employee",objconn)
dbcomm.commandtext="insert into employee values ('mostafa',7,'tanzania')"
dbcomm.Connection = objconn
dbcomm.ExecuteNonQuery()
objconn.close ()

end sub
</script>
<html>
<Head>
</HEAD>

<BODY BGCOLOR="White" TOPMARGIN="10" LEFTMARGIN="10">
<form Runat="Server">
<asp:textbox id="t1" Runat="Server" text="type" />
<asp:button id="b1" Runat="Server" onclick="button_click" text="clickme" />

</form>
</BODY>
</HTML>

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.