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
khaled_jawaher
-2
Junior Poster in Training
Recommended Answers
Jump to Posti 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
thankswell anonymous should be selected. i think accessing the mdb database is not a problem , all you need to …
All 2 Replies
vuyiswamb
17
Posting Whiz
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
khaled_jawaher
-2
Junior Poster in Training
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.