Bonjour,

Je n'arrive pas a me connecter avec ce code à ma base sql server 2005 :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
 //myConn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings.Get("connString");
        //string database = "C:\\Documents and Settings\\Polo\\Mes documents\\Visual Studio 2005\\WebSites\\Addon\\App_Data\\Database.mdf";
       // string connString = "Data Source=.\\SQLEXPRESS;AttachDbFilename='"+"C:\\Documents/and/Settings\\Polo\\Mes/documents\\Visual/Studio/2005\\WebSites\\Addon\\App_Data\\Database.mdf"+"';Integrated Security=True;Connect Timeout=30;User Instance=True";
        string connString = "Data Source=.\\SQLExpress;Integrated Security=true;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;Pooling=False";
 
        SqlConnection myConn = new SqlConnection(connString);
 
        try
        {
            //Ouverture de sla connexion à la base de données Addon1.dbo (MS SQL)
            myConn.Open();
le message d'erreur suivant est renvoyé :

Erreur SQL : System.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Login failed for user 'PAUL\Polo'. 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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Login.LoginButton_Click1(Object sender, EventArgs e) in c:\Documents and Settings\Polo\Mes documents\Visual Studio 2005\WebSites\Addon\Login.aspx.cs:line 35

Savez vous ou ca coince ?
Merci