代码之家  ›  专栏  ›  技术社区  ›  Dave Mateer

Log4Net数据库乐趣-连接字符串!

  •  3
  • Dave Mateer  · 技术社区  · 14 年前

     <connectionString name="asdf" value="Data Source=.\;Initial Catalog=fmwebapp1;Integrated Security=True" />
          <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    

    在实时(64位VPS)上,这不起作用:

    <connectionString value="CT210991\SQLEXPRESS;Initial Catalog=fmwebapp1;Integrated Security=True" />
          <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    

    log4net:ERROR [AdoNetAppender] Could not open database connection [CT210991\SQLEXPRESS;Initial Catalog=fmwebapp1;Integrated Security=True]
    System.ArgumentException: Keyword not supported: 'ct210991\sqlexpress;initial catalog'.
       at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
       at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
       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 log4net.Appender.AdoNetAppender.InitializeDatabaseConnection()
    

    大脑变得模糊。。64位问题?

    2 回复  |  直到 14 年前
        1
  •  3
  •   Chandam    14 年前

    connectionString值中的“CT210991\SQLEXPRESS”前面没有“Data Source=”。

        2
  •  2
  •   Mauricio Scheffer    14 年前

    <connectionString value="Data Source=CT210991\SQLEXPRESS;Initial Catalog=fmwebapp1;Integrated Security=True" />