How To Acess Microsoft Access Remotely
May 28, 2010
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:inetpubwwwrootdb.mdb.
I have the code below but when I run it I am getting the following error:
error on ther server the object model couldnšt be found
OleDbException 0x800a2011
<%@ 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>
View 1 Replies
Similar Messages:
Feb 9, 2010
[Code]....
I still a beginner and i want to create a website asp.net with c# and microsoft acess as a database ,the problem that i can't insert new lines in my database
View 13 Replies
Sep 9, 2010
have deployed an mvc 2 app to a local iis server. It works fine when i go to http://localhost/MyApp. However when i insert my ip address in the place of localhost and try to go to it i get an 'oops google chrome can't connect'. I have all firewalls disabled. I can view the default web site at http://82.168.191.228, just not my mvc app at http://82.168.191.228/MyApp.
View 6 Replies
Dec 17, 2010
I create a project in ASP.NET and my sql database and query procedure are stored at other system. i remotly access this file and i want to do access this database on my project
can it access from webconfig connectionString?
View 2 Replies
Dec 24, 2010
I am facing a problem in accessing the asp.net webpages remotely.
i am using the server as my windows 7 laptop with vs2008 and sql server 2008. when i try to connect from client XP PC it says time out error.
View 6 Replies
May 18, 2010
How can i connect my local project with the SQL server 2008 Database that is running on other server (This server is not on my network and i connect to it via remote desktop connection).
View 1 Replies
Jun 3, 2010
I installed a basic TFS 2010 instance on a Windows Server 2008 32bit VM. I didn't need SSRS or WSS so I left those unconfigured.
It works fine when I'm on our local network but how do I get the default TFS website [URL] to be accessible over the internet when I'm not on our local network? I'd also like for off-site members to be able to connect to the TFS via Visual Studio (this also works fine internally)
I'm having a hard time finding any documentation on how to acheive this.
View 2 Replies
Jan 6, 2011
I have 4 file uploader in my form to upload 4 images in the DB for each article submitted. My issue when I want update/edit my article with some new pictures and I want delete or update the old pictures with the replacement with the new one.
How I can implement it? I am using ASP.NET based on VB.NOT .... NOT C#
View 1 Replies
Sep 10, 2010
actually I have deployed the website .and some user is able to acess the same site from one location but some user is not able to acess the same site from other location .there is time out problem users get access and after some time there is time out ,but it is working fine in other locationsall the system configuration setting is the same .
View 2 Replies
Aug 12, 2010
I have a code to link to sql can anyone give me the same code for microsoft access....
try
{
int videoID = Convert.ToInt32(Request.QueryString["ID"]);
SqlConnection conn = new SqlConnection("server=WEBDESIGN-PC;database=Credentials;uid=sa;pwd=Azeem;");
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM videopath WHERE videoID=" + videoID, conn);
SqlDataReader dtr = cmd.ExecuteReader();
dtr.Read();
FlashVideo1.VideoURL = Convert.ToString(dtr["Filepath"]);
Label1.Text = Convert.ToString(dtr["Filename"]);
conn.Close();
}
catch (Exception ex)
{
Label1.Text = Convert.ToString(ex);
}
finally
{
}
View 2 Replies
Jun 23, 2010
write code that can send bulk emails from an access database using asp.net/vb? I only need to send about 200 emails per day. also the email must be addressed to that person, eg. if the email address is kylesmith@gmail.com then the email should read Dear Kyle as well as the TO field should state kylesmith@gmail.com
View 22 Replies
Jan 18, 2010
I'm using a ListView to populate products data from LinQDataSource and using a DataPager for paging.
When I choose a product from page 2 and put it into cart then I go to cart, if I click on "Continue shopping" I want to back the page 2 contain product I've just selected before.
How can I do that?
Here is my code snipet:
ASPX File
[Code]....
CS File
[Code]....
View 2 Replies
Jan 23, 2010
I am planning to start learning asp.net mvc. And also I want to learn Microsoft's Data Access application block. But I dont want to waste time in MDAC block if theres a better option to go for, or if MVC provides any good feature than MDAC. As I have heard MVC architecture automatically generates code.
View 2 Replies
Mar 20, 2011
how many users can open a connection to Microsoft Access database simultaneously ?I am using asp.net 4.0 to write my application.
<add name="E_ShopAccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|
eport.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>
View 4 Replies
Mar 25, 2011
How can I move records from one table to another in Microsoft Access?. I would like to be using an sql.
View 4 Replies
Dec 12, 2010
Currently i am developing ASP.NET AJAX server control in which i am using jquery code. Inside jquery event, i wish to access the microsoft ajax object. If it is not clear, find the below code example,
Type.registerNamespace("MyControls");
View 2 Replies
Dec 25, 2010
i need to rename microsoft access database in APP_Data folder using ASP.Net - VB.Net
View 1 Replies
Feb 15, 2011
I am developing a simple web app on Visual Studio 2010 on Vista, using Local IIS. When I ran I got this error message:
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).
For this app, I did the following.
-- Add Reference of Microsoft Excel 12.0 Object Library from WebSite option on Visual Studio 2010.
-- Here is the code: (Error occured @ Dim xii2 As New Excel.application). The identical code and idential Add Reference were fine when developed under window .net asp
application, not web app.
Imports Microsoft.Office.Interop
Partial Class _Default
Inherits System.Web.UI.Page
[Code]....
View 2 Replies
Dec 17, 2010
For some reason neither SQL managment studio nor import and export wizard works on my friends network due to some security policy
i asked a question about OSQL two days ago and StackOverflow guys told me it is going to be obselete and that i should use SQLCMD instead.
to cut long things short my question is very precise:
using SQLCMD..1-need to import and export command from AND to MDB/MDF
2-need attach / detach commands
View 2 Replies
Apr 15, 2010
I have a problem and I could not solve it. Hope you can write a sample code for me. I have a Microsoft Access database, and in asp.net website, i draw a grid view on the design page. I also configure the source data access. It works, but display all the data in the database. i want to display all the data which is related to John. sql = "select username, customer_name, phone from db where username = John" how do i configure the data grid view?
View 3 Replies
Feb 26, 2010
I want to know how do I use outer joiin with microsoft visual web developer 2008.
I am using an access database. There are two table in the table t1 and t2.
I want to list the items in both table that have the same id.
my query is as follows:
select t1.id, t1.date, t1.count, t2.date, t2.count from t1 outer join t2 on t1.id=t2.id;
I am completely depressed ... I have been trying this for more than 200hrs.
View 23 Replies
Mar 19, 2011
am absolutely clueless on this. I've been told that the web application I'm building (.net 4 / mvc3 / c# / sql server) will be "sitting behind UAG so we can silently authenticate". I've no idea now how to approach the authentication part of the build in my dev environment. Should I just use "windows authentication"? Will that be the required setting when the application goes live? How do I test the authentication?The people asking me to do this are currently just getting started with UAG too do so any help, pointers, .To put the situation in context, this application will be accessible via the company network internally, and also via the web externally (via UAG portal, of course). The company is on Active Directory, and all I actually need to "pull through" to the application to get further people entity data is the AD username.
View 1 Replies
Dec 16, 2010
It looks that the old SqlHelper class from the Microsoft Enterprise Library has been mostly replaced by the Database class which is included in the new Enterprise Library version 5.
I have a very simple and trivial example:
using Microsoft.ApplicationBlocks.Data;
private void PopulateCheckBoxGroup()
{
const string strConnTxt = "Server=(local);Database=DataBindTests;Integrated Security=True;";
const string strlSql = "select Technology from PreferredTechnology where ParentId = 1";
CheckBoxList1.DataSource = SqlHelper.ExecuteReader(strConnTxt, CommandType.Text, strlSql);
CheckBoxList1.DataTextField = "Technology";
CheckBoxList1.DataBind();
}
View 1 Replies
Apr 14, 2010
I want to create a search button and put the results in a data grid.
Select Company_Name,Contact_Name,Contact_Number From ClientSystem WHERE Company_Name=txtSearch.Text
View 2 Replies
Mar 12, 2010
Iam using the DBconnection object through out my applicationI use the same as a singleton objectWhen more operations are performed on the single objectit throws an error ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Cannot open any more tables.But it occurs only some timesHow to solve this?Can any property can be set to avoid this type of error.Or can i overload and write any method to avoid thisTo Identify the same i wrote some Poc and tried alsoLike opening the connection object and looping through 1000 times and creating a command object for the connection and running a query.Some times iam getting the exception and some times its running
View 7 Replies
