[ finderetf @ 02.11.2008. 15:19 ] @
Zasto ovo ne radi???

konekcija = new SqlConnection(@"Data Source=(local);Integrated Security=SSPI; " + "Initial Catalog=northwind;User ID=root;Password=0");
konekcija.Open();

Ova greska se javlja:
Baza je na MySQL serveru.User name ROOT, Pass : 0;
Mozda i treba u web konfigurisanju da se nesto uradi,ali ja to ne znam.Tamo nista nisam podesavao,pa molim da napisete gde se to i nalazi.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Ukljucio sam i remote connections. U cemu je problem, verovatno connection string, pa mi pomozite! Hvala


Mnogo biste mi pomogili kada bi bilo reci i pristupu bazi na nekom drugom racunaru (troslojna arhitektura – soket...)
[ la_bomba @ 02.11.2008. 20:00 ] @
Probaj da umjesto (local) napises imeRacunara\SQLEXPRESS
[ finderetf @ 02.11.2008. 21:18 ] @
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

Line 28: {
Line 29: konekcija = new SqlConnection(@"Data Source=gajic\SQLEXPRESS;Integrated Security=SSPI; " + "Initial Catalog=northwind;User ID=root;Password=0");
Line 30: konekcija.Open();


Preprevio sam ali opet isto. Probao sam preko System.Data.Odbc sve savrseno radi, cak menjam i masine koje su kao MySQL server i sve radi super.
Hocu da mi proradi i kao System.Data.SqlClient; samo da proradi ovaj connstring.

Hvala
[ vujkev @ 03.11.2008. 01:40 ] @
Citat:

Line 29: konekcija = new SqlConnection(@"Data Source=gajic\SQLEXPRESS;Integrated Security=SSPI; " + "Initial Catalog=northwind;User ID=root;Password=0");

Citat:

Preprevio sam ali opet isto. Probao sam preko System.Data.Odbc sve savrseno radi, cak menjam i masine koje su kao MySQL server i sve radi super.


Jel je u pitanju MySQL server ili MSSQL server?
[ Prokleta_Nedelja @ 03.11.2008. 13:08 ] @
ako je MySQL server evo connstringa
"server=localhost;database=moja_baza;uid=root;pwd=moja_sifra;"

Takodje ne mozes koristiti SqlConnection objekt ako radis sa MySQL nego moras skinuti MySql.NET konektor (www.mysql.com) i koristiti MySqlConnection objekt