Answered by:
connection to remote server using .net

Question
-
User-333339241 posted
To whom it may concern:
I have a server named shoreTel. It is a 2003 server. It has MSAccess on it. On my intranet, I have my website.
I have tried many different connection strings. here is mine.
CONNECTION:
<
add name="MsAccess" connectionString="Provider=MS Remote;Remote Server=http://xx.xx.x.x;Remote Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\shoretel\Database\ShoreWare.mdb;User Id=SHORETEL\user ;Password=xxxxx"/>The datasource is a network share that I can get to. I have the USER/PW the net work guy made me.
my error is below.
Internet Server Error: Object/module not found.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Internet Server Error: Object/module not found.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OleDbException (0x800a2011): Internet Server Error: Object/module not found.] System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +44 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +245 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +190 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +162 System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +111 System.Data.OleDb.OleDbCommand.ExecuteReader() +6 ShoreTel.page2.getUser(String ext) in C:\Documents and Settings\dledbetter\My Documents\Visual Studio 2005\Projects\ShoreTel\ShoreTel\page2.aspx.cs:193 ShoreTel.page2.btnRunRpt_Click(Object sender, EventArgs e) in C:\Documents and Settings\dledbetter\My Documents\Visual Studio 2005\Projects\ShoreTel\ShoreTel\page2.aspx.cs:95 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +107 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3436
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082
Can someone help me? I would really appreciate it very much.
Thanks in advance.
<!-- [OleDbException]: Internet Server Error: Object/module not found. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.ExecuteReader() at ShoreTel.page2.getUser(String ext) in C:\Documents and Settings\dledbetter\My Documents\Visual Studio 2005\Projects\ShoreTel\ShoreTel\page2.aspx.cs:line 193 at ShoreTel.page2.btnRunRpt_Click(Object sender, EventArgs e) in C:\Documents and Settings\dledbetter\My Documents\Visual Studio 2005\Projects\ShoreTel\ShoreTel\page2.aspx.cs:line 95 at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) [HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.page2_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->Tuesday, April 28, 2009 4:28 PM
Answers
-
User-1199946673 posted
Access is not really designed for this. It's very hard to get this working, due to all kinds of permission problems, firewalls etc...
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, April 28, 2009 6:27 PM