同一个数据库,数据源配制一致,但一台机可以运行,另一台机却运行不了,是什么原因呢?
我是用OLE DB provider 配制数据源的,数据库安装在另一台机,应用程序在我电脑上运行是没出现任何问题的,但拷到数据库那台机,数据源配制和我本机一样,运行时就提示下面的错,我用数据库那台机的OLE DB Provider数据源程序里提供的"Test Connect",测试结果是:"Test connect succeded.",但实际在数据库这台机运行怎么会提示找不到存储过程呢?

Server Error in '/ReportsQuery' Application.
--------------------------------------------

[Native Error code: 2812]
[DataDirect ADO Sybase Provider] Stored procedure 'TVMRevenueTotal' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). 
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: [Native Error code: 2812]
[DataDirect ADO Sybase Provider] Stored procedure 'TVMRevenueTotal' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

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 (0x80004005): [Native Error code: 2812]
[DataDirect ADO Sybase Provider] Stored procedure 'TVMRevenueTotal' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).]
  System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult) +161
  System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +160
  System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +48
  System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +106
  System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +111
  System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +4
  System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141
  System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
  System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +86
  DBOperate.DBSelect(String sqlCommand, String[] paraNames, String[] paraValues) +187
  ReportAdapter.RptViewerData(ReportViewer reportViewer, String dataSourceName, String reportName, String sqlString, String[] paraName, String[] paraValue, String[] paraSqlName, String[] paraSqlValue) +147
  TVMRevenueTotal.Page_Load(Object sender, EventArgs e) +80
  System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
  System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
  System.Web.UI.Control.OnLoad(EventArgs e) +99
  System.Web.UI.Control.LoadRecursive() +47
  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

 


--------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

------解决方案--------------------