locked
connection to remote server using .net RRS feed

  • 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