January 6, 2009 at 3:42 am
Hello All,:)
While running a .net application i m getting the following error:
An error has occured while estabishing connection to server. When Connecting to SQL server 2005,this failure may be caused by the fact that under the pipes provider, Error:40-Could not open connection to SQL server.
The application is copying online excel data in SQL server table.
The data gets copied after each 5 seconds.
This error is not coming continuously.
Means after copying the data e.g. 2 times for the 3rd time the error occurs.
Plz help.Thank you..
January 6, 2009 at 10:46 pm
This may be due to TCP /IP load on SQL server connection. You may need to check that your SQL is up and running efficiently. You also have the option of checking the performance of this SQL server from analysing database logs.
One possible reason may be windows network congestion. That you can't help with. Check with Your windows support group.
I hope this may help you. 🙂
January 7, 2009 at 12:05 am
Thanks for the reply.:)
Can the error occur due to the firewall settings? The OS firewall is OFF on my PC.
How to check which firewall is ON and how to add exceptional ports in that?
With the above error Meanwhile I m getting the following error:
The provider could not determine the string value for example the row was just created the default for the string column was not available , and the consumer had not yet set a new string value..
Please Help..:crying:
Any Help will be greatly appreciated..
Thank you...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply