locked
ArgmentException was unhandled by user code RRS feed

  • Question

  • User1753414475 posted

    First time setting up database project, running SQL 2008. Getting error above details below on webcontent.ascx file

     

    System.ArgumentException was unhandled by user code
      Message=Invalid value for key 'attachdbfilename'.
      Source=System.Data
      StackTrace:
           at System.Data.SqlClient.SqlConnectionString.VerifyLocalHostAndFixup(String& host, Boolean enforceLocalHost, Boolean fixup)
           at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
           at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
           at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
           at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)
           at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
           at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
           at ASP.WebContent.Page_Load(Object sender, EventArgs e) in C:\Users\daaaon\Desktop\WSC club kit\UserControls\WebContent.ascx:line 61
           at System.Web.UI.Control.OnLoad(EventArgs e)
           at System.Web.UI.Control.LoadRecursive()
           at System.Web.UI.Control.LoadRecursive()
           at System.Web.UI.Control.LoadRecursive()
           at System.Web.UI.Control.LoadRecursive()
           at System.Web.UI.Control.LoadRecursive()
           at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
      InnerException:

    Tuesday, July 13, 2010 8:35 PM

Answers

  • User1753414475 posted

     User instance login is only supported on express editions and SQL 2008 will not support

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, July 20, 2010 11:53 AM

All replies

  • User-2091578272 posted

    Nothing special I can see, but please check the field "attachdbfilename" as the exception clearly targetted it by saying "Invalid value for key 'attachdbfilename'"

    Wednesday, July 14, 2010 1:11 AM
  • User1753414475 posted

    Some more info: First starter club kit I am trying to deploy

    Other parts of error code not coping;

     1) SqlException was unhandled by user code

      2) The user instance login flag is not supported on this version of SQL Server. The connection will be closed.(Does option have to be turned on?)

    My deployment server is SQL 2008.

    After installing VS2010 I noticed SQL2008 R2 is now installed on my pc.(don't think this is relavent)

    Properties of Database are in VS2010 is .\SQLEXPRESS, NOT SURE OF WHAT VERSION(2005,2008)?

    Will keep prying to answer myself but any help much appreciated.

    P.S attachdbfilename is in the connection string in web config

     

     

     

     

     

     

    Wednesday, July 14, 2010 9:09 PM
  • User1753414475 posted

     After reading serveral post I come to the conculsion only sql express supports "User instance login " is this true?

    Wednesday, July 14, 2010 9:42 PM
  • User1753414475 posted

     User instance login is only supported on express editions and SQL 2008 will not support

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, July 20, 2010 11:53 AM