Problem sa connection string-om

[ Valerij Zajcev @ 27.07.2008. 01:01 ] @

Pokusavam da se konektujem na bazu sledecim kodom o dobijam...

Code:

private string connectionString = @"Server=VLADA-PC\SQLEXPRESS;Database=SMSMessages;user id=sa;password=";

Code:

try
            {
                sqlConnection = new SqlConnection ();
                sqlConnection.ConnectionString = getConnectionString();
                sqlConnection.Open();
            }
            catch (Exception ex)
            {
                throw ex;
            }

Na liniji sqlConnection.Open(); mi izbaci:
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.

[ bags @ 27.07.2008. 09:26 ] @

Verovatno trebaš podesiti Authentication Mode u SQL Serveru na Mixed. ( a ne samo Windows)

[ Valerij Zajcev @ 27.07.2008. 09:57 ] @

Ima Windows authentication mode i SQL Server and Windows authentication mode. Ovo drugo mi je cekirano i dalje javlja isti problem?

[ Valerij Zajcev @ 27.07.2008. 10:36 ] @

Code:

@"Data Source=VLADA-PC\SQLEXPRESS;Initial Catalog=SMSMessages;Integrated Security=True; ";

Napravio sam novi connection string i sada radi :)

[ bags @ 27.07.2008. 10:43 ] @

Ja uvek preuzimam connection string sa http://www.connectionstrings.com/ , pa ga po potrebama prilagodim.

[ joca22 @ 20.08.2008. 12:05 ] @

Imam jedno pitanje, a gde se tacno pise kod za ConnectionString?

[ dava @ 20.08.2008. 15:00 ] @

recimo:

Code:

SqlConnection Conn = new SqlConnection(SQL_CONNECTION_STRING);

ili

Code:

SqlCommand Conn = new SqlCommand("Select * from Neka_Tabela", SQL_CONNECTION_STRING);

SQL_CONNECTION_STRING je u ovom slucaju konstanta koju smo predhodno definisali.

[ joca22 @ 20.08.2008. 17:50 ] @

Ma OK to, to znam, nego me interesuje u kom tacno sloju to treba da bude kodirano?

[ aleksandarpopov @ 20.08.2008. 19:14 ] @

Ne treba da je "hard coded", bolje ga je zapisati u neki konfiguracioni fajl i odatle iscitavati. Npr. web.config fajl

[ joca22 @ 20.08.2008. 20:30 ] @

Upravo me je to interesovalo.Hvala puno