SQL server connection time out

How to increase Connection time out in Sql server?

Connection time out can be defined in SQL server in two ways.

1)  Connection timeout in Connection string property: which determines how long it should take to open a connection. It is affected by Network i.e. If network is slow. If a connection is opened the connection time out property is not longer used. Its is just used before opening a connection.

2) Connection timeout in Command object : It is used after opening a connection, when used with Command object’s property “CommandTimeout” it becomes effective. You can increase connection time here and its effective after opening a connection.

I Wan to share this post:
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • kick.ie
  • Live
  • MyShare
  • IndianPad
  • Reddit
  • StumbleUpon
  • Technorati
  • YahooMyWeb
  • DotNetKicks
  • DZone
  • TwitThis

Few jquery errors , Attention J Query Gurus, invalid label

Attention J Query Gurus J Query gurus can you put some light on this matter please?

I am using J Query method for Ajax calls in my asp.net projects

$.ajax({
type:”POST”,
url:”WebService/WsCountry.asmx/getCountryList”,
data:”{optionvalue:’”+checkedValue+”‘}”,
contentType:”application/json; charset=utf-8″,
datatype:”json”,
success:function(response)

In above I am using “datatype”  as small characters, its working 100%  for me in one project  also i am not uisng “response.d” when I am using eval() method to convert it from json string to array. i was using var myObject= eval(“(”+ eval(response)+ “)”);

I creatd a second project and used same i.e (“datatype” as small characters) but it started throwing errors.

Then I switched back to proper syntax ie. “dataType” using “T” as caps and this line started throwing errors var myObject= eval(“(”+ eval(response)+ “)”);

“invalid label” after speding sometime i came to know that I need to use var myObject= eval(“(”+ response.d+ “)”); when i used response.d it started working.

Does anyone else experienced this type of problem in J query.


I Wan to share this post:
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • kick.ie
  • Live
  • MyShare
  • IndianPad
  • Reddit
  • StumbleUpon
  • Technorati
  • YahooMyWeb
  • DotNetKicks
  • DZone
  • TwitThis
|