i have a problem with my connection to sql server 2005

Discussion in 'Databases' started by derinweb, Sep 13, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. this is my current problem






    Server Error in '/kurdpedia' Application.


    Invalid object name 'K_comany'.


    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.SqlClient.SqlException: Invalid object name 'K_comany'.

    Source Error:





    Code:
    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:





    Code:
    [SqlException (0x80131904): Invalid object name 'K_comany'.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +95
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +82
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3244
       System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +52
       System.Data.SqlClient.SqlDataReader.get_MetaData() +130
       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +371
       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1121
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +334
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +45
       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +162
       System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +35
       System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +32
       System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +183
       System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +308
       System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +152
       System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2868
       System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +84
       System.Web.UI.WebControls.DataBoundControl.PerformSelect() +154
       System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +99
       System.Web.UI.WebControls.DetailsView.DataBind() +23
       System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +92
       System.Web.UI.WebControls.DetailsView.EnsureDataBound() +196
       System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +100
       System.Web.UI.Control.EnsureChildControls() +134
       System.Web.UI.Control.PreRenderRecursiveInternal() +109
       System.Web.UI.Control.PreRenderRecursiveInternal() +233
       System.Web.UI.Control.PreRenderRecursiveInternal() +233
       System.Web.UI.Control.PreRenderRecursiveInternal() +233
       System.Web.UI.Control.PreRenderRecursiveInternal() +233
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4436
    




    Version Information:Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 <!--
    [SqlException]: Invalid object name 'K_comany'.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
    at System.Data.SqlClient.SqlDataReader.get_MetaData()
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
    at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
    at System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
    at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
    at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
    at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
    at System.Web.UI.WebControls.DetailsView.DataBind()
    at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
    at System.Web.UI.WebControls.DetailsView.EnsureDataBound()
    at System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls()
    at System.Web.UI.Control.EnsureChildControls()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    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.admin_kurdish_compnay_company_upload_aspx.ProcessRequest(HttpContext context)
    at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
    -->
     
  2. hello , i have a problem with my connection to sql server 2005 , if you can help me
    with regards
    this is the error


    Server Error in '/' Application.


    The connection name 'ConnectionString' was not found in the applications configuration or the connection string is empty. 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.InvalidOperationException: The connection name 'ConnectionString' was not found in the applications configuration or the connection string is empty.

    Source Error:





    Code:
    Line 147:                                <InsertRowStyle BackColor="White" />
    Line 148:                            </asp:DetailsView>
    Line 149:                            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
    Line 150:                                ConnectionString="<%$ ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [K_comany] WHERE [id] = @original_id AND [Company_name] = @original_Company_name AND [xawan] = @original_xawan AND [bwary_karkrdn] = @original_bwary_karkrdn AND [nawnishan] = @original_nawnishan AND [zhmaray_mobile] = @original_zhmaray_mobile AND [zhmaray_mobile1] = @original_zhmaray_mobile1 AND [zhmaray_tel] = @original_zhmaray_tel AND [zhmaray_fax] = @original_zhmaray_fax AND [e_mail] = @original_e_mail AND [website] = @original_website AND [dp_pictrue] = @original_dp_pictrue AND [small_picture1] = @original_small_picture1 AND [small_picture2] = @original_small_picture2 AND [small_picture3] = @original_small_picture3 AND [small_picture4] = @original_small_picture4 AND [small_picture5] = @original_small_picture5 AND [small_picture6] = @original_small_picture6 AND [small_picture7] = @original_small_picture7 AND [small_picture8] = @original_small_picture8 AND [full_picture1] = @original_full_picture1 AND [full_picture2] = @original_full_picture2 AND [full_picture3] = @original_full_picture3 AND [full_picture4] = @original_full_picture4 AND [full_picture5] = @original_full_picture5 AND [full_picture6] = @original_full_picture6 AND [full_picture7] = @original_full_picture7 AND [full_picture8] = @original_full_picture8 AND [insert_date] = @original_insert_date AND [expire_date] = @original_expire_date"
    Line 151:                                InsertCommand="INSERT INTO [K_comany] ([Company_name], [xawan], [bwary_karkrdn], [nawnishan], [zhmaray_mobile], [zhmaray_mobile1], [zhmaray_tel], [zhmaray_fax], [e_mail], [website], [dp_pictrue], [small_picture1], [small_picture2], [small_picture3], [small_picture4], [small_picture5], [small_picture6], [small_picture7], [small_picture8], [full_picture1], [full_picture2], [full_picture3], [full_picture4], [full_picture5], [full_picture6], [full_picture7], [full_picture8], [insert_date], [expire_date]) VALUES (@Company_name, @xawan, @bwary_karkrdn, @nawnishan, @zhmaray_mobile, @zhmaray_mobile1, @zhmaray_tel, @zhmaray_fax, @e_mail, @website, @dp_pictrue, @small_picture1, @small_picture2, @small_picture3, @small_picture4, @small_picture5, @small_picture6, @small_picture7, @small_picture8, @full_picture1, @full_picture2, @full_picture3, @full_picture4, @full_picture5, @full_picture6, @full_picture7, @full_picture8, @insert_date, @expire_date)"
    Source File: E:\web\kurdpediaco\htdocs\admin\Kurdish\Compnay\Company_upload.aspx Line: 149

    Stack Trace:





    Code:
    [InvalidOperationException: The connection name 'ConnectionString' was not found in the applications configuration or the connection string is empty.]
       System.Web.Compilation.ConnectionStringsExpressionBuilder.GetConnectionString(String connectionStringName) +2955101
       ASP.admin_kurdish_compnay_company_upload_aspx.__BuildControl__control54() in E:\web\kurdpediaco\htdocs\admin\Kurdish\Compnay\Company_upload.aspx:149
       ASP.admin_kurdish_compnay_company_upload_aspx.__BuildControl__control4(Control __ctrl) in E:\web\kurdpediaco\htdocs\admin\Kurdish\Compnay\Company_upload.aspx:16
       System.Web.UI.CompiledTemplateBuilder.InstantiateIn(Control container) +12
       System.Web.UI.WebControls.LoginView.CreateChildControls() +208
       System.Web.UI.Control.EnsureChildControls() +87
       System.Web.UI.Control.PreRenderRecursiveInternal() +41
       System.Web.UI.Control.PreRenderRecursiveInternal() +161
       System.Web.UI.Control.PreRenderRecursiveInternal() +161
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
    

    Version Information:Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 <!--
    [InvalidOperationException]: The connection name 'ConnectionString' was not found in the applications configuration or the connection string is empty.
    at System.Web.Compilation.ConnectionStringsExpressionBuilder.GetConnectionString(String connectionStringName)
    at ASP.admin_kurdish_compnay_company_upload_aspx.__BuildControl__control54() in E:\web\kurdpediaco\htdocs\admin\Kurdish\Compnay\Company_upload.aspx:line 149
    at ASP.admin_kurdish_compnay_company_upload_aspx.__BuildControl__control4(Control __ctrl) in E:\web\kurdpediaco\htdocs\admin\Kurdish\Compnay\Company_upload.aspx:line 16
    at System.Web.UI.CompiledTemplateBuilder.InstantiateIn(Control container)
    at System.Web.UI.WebControls.LoginView.CreateChildControls()
    at System.Web.UI.Control.EnsureChildControls()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    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.admin_kurdish_compnay_company_upload_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.-->
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page