Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

C# Desktop aplikacija i problem povezivanja sa sql bazom

[es] :: .NET :: C# Desktop aplikacija i problem povezivanja sa sql bazom

[ Pregleda: 4090 | Odgovora: 8 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

midgard
Beograd, Vozdovac

Član broj: 59016
Poruke: 127
*.routotelecom.com.



+1 Profil

icon C# Desktop aplikacija i problem povezivanja sa sql bazom28.06.2011. u 21:51 - pre 155 meseci
Nov sam u Microsoft razvojnim okruzenjima pa ce ovo izgledati kao pocetnicki problem, ali sta je tu je, ne mogu da ga resim vec ceo dan, a Google resenja ne pomazu.

Napravio sam malu C# aplikaciju i VS 2008 koja se povezuje sa SQL Server 2005 i radi neke osnovne operacije sa bazom. Na racunaru gde imam instalirane alate, konkretno Visual Studio 2008 i SQL Server 2005 sve radi bez problema. Problem se javlja kada tu istu aplikaciju kopiram na neki drugi racunar gde nemam te alate i na kojima je instaliran .NET Framework 3.5.

Greska koju dobijam je:

Code:
System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)


Ono sto mogu da procitam je da ne moze da ostvari konekciju sa SQL Serverom, ali poprilicno mi je nelogicno da moram da instaliram i ceo SQL Server zajedno sa aplikacijom. Koliko mogu da se setim stiva sa fakulteta, ovakve stvari su radile bez problema sa Access bazom.

Nije problem do putanje, jer sam probao sve moguce varijante, cak sam kompalirao da sve bude na C: i problem i dalje postoji.

Da li je mozda potrebno da se instalira jos neki dodatak pored .NET Framework-a?

Molim za pomoc,
Hvala
 
Odgovor na temu

Dejan Carić
Oslo, Norway

Član broj: 230976
Poruke: 232
*.dynamic.isp.telekom.rs.

Sajt: www.dcaric.com


+26 Profil

icon Re: C# Desktop aplikacija i problem povezivanja sa sql bazom28.06.2011. u 23:23 - pre 155 meseci
Na tom drugom računaru moraš imati instaliran SQL Server.
Drugo rešenje ti je da umesto SQL Server-a koristiš neku embedded bazu:
SQL CE
SQlite
VistaDB
SharpHSQL
Blackfish SQL
itd.



[Ovu poruku je menjao Dejan Carić dana 29.06.2011. u 00:36 GMT+1]
 
Odgovor na temu

midgard
Beograd, Vozdovac

Član broj: 59016
Poruke: 127
*.neobee.net.



+1 Profil

icon Re: C# Desktop aplikacija i problem povezivanja sa sql bazom29.06.2011. u 00:26 - pre 155 meseci
Hvala na odgovoru, verovatno cu da probam sa SQLite.

Pozdrav
 
Odgovor na temu

sallle
Sasa Ninkovic
GTECH
Beograd

Član broj: 146
Poruke: 480
..106.109.adsl.dyn.beotel.net.

ICQ: 20785904


+4 Profil

icon Re: C# Desktop aplikacija i problem povezivanja sa sql bazom29.06.2011. u 01:18 - pre 155 meseci
ako su u racunari u mrezi ne moras da instaliras ponovo sql server , dovoljno je da samo promenis konekcioni string.
Ako nisu u mrezi moraces na nekoj masini da instaliras neku ediciju sql servera (za ove pobrojane baze proveri prvo dal postoje konektori za .net)
cini mi se da ima opcija u visual studiu da napravis embeded bazu unutar aplikacije (to je verovatno neka acess baza...)

 
Odgovor na temu

gvasic
RS

Član broj: 279391
Poruke: 16
*.teol.net.



Profil

icon Re: C# Desktop aplikacija i problem povezivanja sa sql bazom17.11.2011. u 21:41 - pre 150 meseci
Pozdrav, imam slican problem, tako da necu otvarati novu temu.

Radim sa prijateljem servisni nalog za vozila. Aplikacija se radi u Visual Studio 2010 a baza u Sql Server 2008 R2. Prijatelj je zaduzen za aplikaciju, a ja za bazu. Kada je zavrsio sa aplikaciom, testirao je program i radi super na njegovom racunaru.

(Ganjam to vec par dana po netu, instaliram par puta Visual Studio 2010 kao i net.framework 4.0 ali opet ista stvar??)
U naslovu greske opet vidim Microsoft .NET Framework?

Problem je sledeci, kod mene aplikacija moze da upise/cita samo vlasnika i proizvodjaca (mislim na tabele), a ostale tabele npr. model vozila, servisni nalog itd. izbacuje gresku:



Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or war not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network interfaces, error:26 – Error Location Server/Instance Specified).

Ovo su detalji greske:


See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
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 System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user)
at System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe()
at System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode()
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.Table`1.GetEnumerator()
at System.Data.Linq.Table`1.System.Collections.Generic.IEnumerable<TEntity>.GetEnumerator()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at RadniNalog.FrmAutomobil..ctor()
at RadniNalog.FrmMain.automobiliToolStripMenuItem_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
RadniNalog
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Documents%20and%20Settings/xp/Desktop/autoservis/RadniNalog.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
System.Data.Linq
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Linq.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

U svakom slucaju hvala na bilo kakvoj pomoci.
Pozdrav

 
Odgovor na temu

wex-alpha
Sarajevo

Član broj: 7580
Poruke: 845
*.dynamic.telemach.ba.



+13 Profil

icon Re: C# Desktop aplikacija i problem povezivanja sa sql bazom18.11.2011. u 15:24 - pre 150 meseci
Na kompjuteru provjeri korisnike. Sta koji moze da radi nad bazom.

Jedan od problema sa friskom instalacijom Servera 2008 je ta da je TCP/IP iskljucen po defaultu. Naravno buduci da si se vec spojio sa bazom, to nije tvoj problem... ali mozda je korisniku sa prvog posta.


 
Odgovor na temu

gvasic
RS

Član broj: 279391
Poruke: 16
*.teol.net.



Profil

icon Re: C# Desktop aplikacija i problem povezivanja sa sql bazom18.11.2011. u 20:11 - pre 150 meseci

Moze mala pomoc, na koji nacin da provjerim mogucnost korisnika?

Logovan sam kao administrator ako sta znaci.

Hvala
 
Odgovor na temu

escape...
student
Bg

Član broj: 163295
Poruke: 37
188.120.100.*



+1 Profil

icon Re: C# Desktop aplikacija i problem povezivanja sa sql bazom19.11.2011. u 14:16 - pre 150 meseci
Na prvu mi je delovalo kao da su u pitanju privilegije nad određenim tabelama, međutim, poruka o grešci govori da je problem u uspostavljanju konekcije sa bazom, što je, dakle, pre pokušaja izvršavanja SQL upita nad spornim tabelama. Zato mislim da je problem pre u aplikaciji, nego u bazi.

Ne bi škodilo da imamo još informacija. Npr.:
Da li se aplikacija uvek povezuje na bazu kao jedan isti user ili, pak, user sa kojim se povezuje na bazu zavisi od toga ko koristi aplikaciju?
Da li je možda prijatelj za rad sa svakom tabelom iznova definisao konekcioni string?
Da li se baza nalazi na prijateljevom računaru?

 
Odgovor na temu

gvasic
RS

Član broj: 279391
Poruke: 16
*.teol.net.



Profil

icon Re: C# Desktop aplikacija i problem povezivanja sa sql bazom22.11.2011. u 18:45 - pre 150 meseci
Sve ok, radi kako treba.

Problem je bio do "koda" u aplikaciji.

Hvala svima u svakom slucaju.

Pozdrav
 
Odgovor na temu

[es] :: .NET :: C# Desktop aplikacija i problem povezivanja sa sql bazom

[ Pregleda: 4090 | Odgovora: 8 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.