|
Hello everyone...
I have developed a windows application using vb.net in visual studio2005.The backend was sql server2000.Now when i try to run the exe file of the project in another machine which has .net framework installed in it, i am getting the following error.
'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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)'
Even though there is SQL server2005 packaged with visual studio 2005, i created the database in sqlserver 2000.I tried changing the prerequisities of the project deployment by including sqlserver2005 in prerequisities list...but that too isn't working....Now what should i do to run the project in other machine...........plz could anyone help me out.................
|
|
|
|
|
Hi
you seem to be having connection issue, your app cannot access the sql db.
1.
you connectionstring property may be incorrect....
2.
check to see if sql server accepts incomming connections
use the sql2005 connection manager and enable the various options...
hope this helps
Anoop Brijmohun
|
|
|
|
|
There is no problem with connection string bcoz the application has no problems in execution in visual studio ide. the problem happens wen the exe file of the application is executed in another machine. i have tried enabling remote connections of sqlserver2005 in configuration manager. one thing to be noted is that the datatbase is being created in sqlserver2000.
|
|
|
|
|
The sql2000 db should not be the cause of the error.
i have used applications that was created in sql2000 and attached it to sql2005 and works fine from other pcs.
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)'
once again make sure you named pipe protocol is enabled
ps. did you restart the sql 2005 service after enabling all protocols?
thanks
|
|
|
|
|
Sir
I have restarted sqlservice after enabling the protocols but the same result again.I have made connection only to sqlserver 2000,i didn't use sql2005 then why is that the error related to remote connection setting of sql2005.
thanks.......
|
|
|
|
|
pravimarrs wrote: There is no problem with connection string bcoz the application has no problems in execution in visual studio ide.
That doesn't mean anything. The connection string can still work for you on your machine and fail on others because of the connection string. This has to do with most people blindly using the Trusted Connection option without knowing how it works.
Is SQL Server 2005 installed on the same machine as the one the application is installed?? Is SQL Server 2005 configured to accept connections on something other than just Named Pipes??
|
|
|
|
|
Sir
I have installed MicrosoftVisualStudio2005 and SQLServer2000 on my machine.I created a windowsapplication and using server explorer i made a new sql server database in sqlserver2000. now when i run the exe file in the bin\release folder on another machine i get that error.I have made connection only to sqlserver 2000,i didn't use sql2005 then why is that the error related to remote connection setting of sql2005.
plz give me solution..............
thanks for the reply.....
modified on Wednesday, November 12, 2008 1:04 AM
|
|
|
|
|
Hi,
it could also probably be a port conflict between sql200/5, the default tcp/ip (IPAll) port is set to 1433,
you might have to change this to 1434 or something and specify this on you connectionstring .
ps. lets have a look at you connectionstring!
thanks
|
|
|
|
|
connectionstring: Data Source=hari;Initial Catalog=apollodb;Integrated Security=True;Pooling=False
provider: .NET Framework Data Provider for SQL Server
state :open
thanks for the reply.......
|
|
|
|
|
try this,
Data Source=192.168.0.1;Initial Catalog=YourDB;Persist Security Info=True;User ID=YourUser;Password=YourPwd;Connect Timeout=10000;Asynchronous Processing=True;MultipleActiveResultSets=True;Encrypt=False;TrustServerCertificate=True;Packet Size=32768
ALT,
Data Source=192.168.0.1:1433;Initial Catalog=YourDB;Persist Security Info=True;User ID=YourUser;Password=YourPwd;Connect Timeout=10000;Asynchronous Processing=True;MultipleActiveResultSets=True;Encrypt=False;TrustServerCertificate=True;Packet Size=32768
use the ip adress of the machine instead,
you could also prob try using ODBC connection to sql.....
thanks
|
|
|
|
|
Hi,
am using crystal report in my application.Am binding a stored procedure to populate the data on to the crystal report. These days i used to pass only one parameter to stored procedure and i get the data accordingly. But now i need to pass two discrete parameters, based on which the data has to be populated.
I posted the old code below which i use now. In that i send MONTH(@month) to the stored procedure and i get the corresponding data. but now i want to send both month and year to stored procedure and get the crystal report populated..
Dim crParameterDiscreteValue As ParameterDiscreteValue
Dim crParameterFieldDefinitions As ParameterFieldDefinitions
Dim crParameterFieldLocation As ParameterFieldDefinition
Dim crParameterValues As ParameterValues
crParameterFieldDefinitions = rptDocument.DataDefinition.ParameterFields
crParameterFieldLocation = crParameterFieldDefinitions.Item("@month")
crParameterValues = crParameterFieldLocation.CurrentValues
crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue
crParameterDiscreteValue.Value = month
crParameterValues.Add(crParameterDiscreteValue)
crParameterFieldLocation.ApplyCurrentValues(crParameterValues)
Please help me out .......
|
|
|
|
|
hi guy
can any body plesse let me know the difference betweeen
synclock myobj
end synclock
and
synclock myarray.syncroot
end synclock
thanks in advance
hello
|
|
|
|
|
Unless you are stuck with framework 1, don't use the ArrayList class at all.
You should not use the reference of the actual data in the SyncLock statement, you should create a private Object that is only used for synchronising. That way there is no risk of a deadlock because you are exposing the data as a public member, and code outside of your class is also using the data object for locking.
The ArrayList class provides an object for synchronisation as the SyncRoot property, but for a generic list you have to create an object yourself.
Example:
Public Class SynchronisedList(Of T)
Private _list As List(Of T)
Private _sync As Object
Public Sub New()
_list = New List(Of T)()
_sync = New Object()
End Sub
Public Sub Add(value As T)
SyncLock _sync
_list.Add(value);
End SyncLock
End Sub
Public ReadOnly Property Count As Integer
Get
SyncLock _sync
Return _list.Count
End SyncLock
End Get
End Property
Public Function Get(index As Integer) As T
SyncLock _sync
Return _list(index)
End SyncLock
End Function
End Class
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
That way there is no risk of a deadlock because you are exposing the data as a public member, and code outside of your class is also using the data object for locking.
i could not get it i m sorry.
and i have one another issue
why generic lists dont have syncroot property though it implements the icollection like arraylist.
thanks in advance .
hello
|
|
|
|
|
hello Friends,
i need simple accounting software source code in VB for learn more about accounting software projects . Please help me if possible
Thanx
|
|
|
|
|
I doubt you will find any simple accounting software that is open source. If you have specific questions regarding accounting software I might be able to help. I have created full accounting software that won me 4th place in a national programming competition, but I can not share the whole source code.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my Blog
|
|
|
|
|
Don't cross post; it's considered rude and isn't going to help you get an answer to your question any faster. Original post is here[^].
Scott Dorman Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA
[ Blog][ Articles][ Forum Guidelines] Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
|
|
|
|
|
and do your own work!
Blog link to be reinstated at a later date.
|
|
|
|
|
Don't cross post or spam the forums.
faradgi wrote: Please help me
No. I don't help cross posters
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I also avoid helping cross-dressers.
Blog link to be reinstated at a later date.
|
|
|
|
|
|
I don't mind helping cross-dressers, as long as it's only with their programming...
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
yeah, but I'm a girl. They're always stealing my make-up!
Blog link to be reinstated at a later date.
|
|
|
|
|
Buy a book, take a course, you can't just get source like this for free, that's why people pay for it.
Christian Graus
Driven to the arms of OSX by Vista.
"Iam doing the browsing center project in vb.net using c# coding" - this is why I don't answer questions much anymore. Oh, and Microsoft doesn't want me to.
|
|
|
|
|
Christian Graus wrote: Buy a book, take a course
Perhaps a couple of both. Programming books, books on the basics of accounting, and courses in both programming and accounting. At least the OP will then have some foggiest idea what to do.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|