Visual Basic

10-Nov-08 18:30

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................. Confused | :confused:

Anoop Brijmohun10-Nov-08 22:23

10-Nov-08 22:23

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

pravimarrs10-Nov-08 23:15

10-Nov-08 23:15

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.

Anoop Brijmohun11-Nov-08 0:01

11-Nov-08 0:01

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

pravimarrs11-Nov-08 19:02

11-Nov-08 19:02

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.......

Re: deploying applications in client machines [modified]

Dave Kreskowiak11-Nov-08 3:23

Dave Kreskowiak

11-Nov-08 3:23

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??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

pravimarrs11-Nov-08 18:53

11-Nov-08 18:53

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

Anoop Brijmohun11-Nov-08 19:27

11-Nov-08 19:27

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

pravimarrs11-Nov-08 21:25

11-Nov-08 21:25

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.......

Anoop Brijmohun12-Nov-08 2:31

How to pass discrete parameters to stored procedure from crystal report

12-Nov-08 2:31

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

thiru_586210-Nov-08 18:03

thiru_5862

10-Nov-08 18:03

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 .......

arraylist issue

Tauseef A10-Nov-08 17:54

Tauseef A

10-Nov-08 17:54

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

Re: arraylist issue

Guffa10-Nov-08 21:02

Guffa

10-Nov-08 21:02

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.

Re: arraylist issue

Tauseef A10-Nov-08 23:56

Tauseef A

10-Nov-08 23:56

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

need help.

faradgi10-Nov-08 9:47

faradgi

10-Nov-08 9:47

hello Friends,
i need simple accounting software source code in VB for learn more about accounting software projects . Please help me if possible

Thanx

[Cross Post]Re: need help.

Thomas Stockwell10-Nov-08 9:49

Thomas Stockwell

10-Nov-08 9:49

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.

Scott Dorman10-Nov-08 9:58

Scott Dorman

10-Nov-08 9:58

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

STOP SPAMMING THE FORUMS

leckey10-Nov-08 11:07

leckey

10-Nov-08 11:07

and do your own work!

Blog link to be reinstated at a later date.

Paul Conrad10-Nov-08 12:27

Paul Conrad

10-Nov-08 12:27

Don't cross post or spam the forums.

faradgi wrote:
Please help me

No. I don't help cross posters Hmmm | :|

"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

leckey10-Nov-08 14:50

leckey

10-Nov-08 14:50

I also avoid helping cross-dressers. Poke tongue | ;-P

Blog link to be reinstated at a later date.