ArgmentException was unhandled by user code RSS

• • Reply
  

  daaaon

  Member

  1 Points

  21 Posts

  ArgmentException was unhandled by user code

  Jul 14, 2010 12:35 AM|LINK

  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:
  

• • Reply
  

  antoops

  Member

  181 Points

  45 Posts

  Re: ArgmentException was unhandled by user code

  Jul 14, 2010 05:11 AM|LINK

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

  thanks
  Anto
  
  
  Please remember to click "Mark as Answer", If this post help you.
  This can be very beneficial to all Asp.net members to get rid of their problem(s)
• • Reply
  

  daaaon

  Member

  1 Points

  21 Posts

  Re: ArgmentException was unhandled by user code

  Jul 15, 2010 01:09 AM|LINK

  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

   

   

   

   

   

   

• • Reply
  

  daaaon

  Member

  1 Points

  21 Posts

  Re: ArgmentException was unhandled by user code

  Jul 15, 2010 01:42 AM|LINK

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

• • Reply
  

  daaaon

  Member

  1 Points

  21 Posts

  Re: ArgmentException was unhandled by user code

  Jul 20, 2010 03:53 PM|LINK

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

  • Marked as answer by daaaon on Jul 20, 2010 03:53 PM