0

i am writing an application on my pc considered as client, to insert record on a microsoft access database on another pc that u can consider it as server, 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 shared the folder and give it premission read write etc.....
i have the code below but when i run i am getting the following error:
error on the server: the object model couldnºt be found
OleDbException 0x800a2011

pls can any one try it and give me the solution.i mean also the steps,bcs i tried evey thing and i am fed up.
the code is :

<%@ LANGUAGE = VBScript 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="VBScript">
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://ip address; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\inetpub\wwwroot\db.mdb;Persist Security Info=False")  
             objconn.open ()
             dbcomm=New Oledbcommand("employee",objconn)
             dbcomm.commandtext="insert into employee values ('mousa',7,'rome')" 
             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>

best regards

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by khaled_jawaher
0

i am writing an application on my pc considered as client, to insert record on a microsoft access database on another pc that u can consider it as server, 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 shared the folder and give it premission read write etc.....
i have the code below but when i run i am getting the following error:
error on the server: the object model couldnºt be found
OleDbException 0x800a2011

pls can any one try it and give me the solution.i mean also the steps,bcs i tried evey thing and i am fed up.
the code is :

<%@ LANGUAGE = VBScript 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="VBScript">
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://ip address; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\inetpub\wwwroot\db.mdb;Persist Security Info=False")  
             objconn.open ()
             dbcomm=New Oledbcommand("employee",objconn)
             dbcomm.commandtext="insert into employee values ('mousa',7,'rome')" 
             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>

best regards

Hi Khaled

Try to move your .mdb file in App_Data folder

Regards

Edited by reach_yousuf: n/a

0

i appreciate ur response yousuf.
Do u mean the APP_data in the asp.netWebAdminFiles in the microsoft.net folder.
and if so,must i change the data source location in the code,with sharing the folder app_data and giving all types of permissions.
thanx
regards

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.