IT Knowledge Support Centre
Timeout expired 
Thursday, November 12, 2009, 05:08 PM - SQL
Posted by Administrator
The timeout period elapsed prior to completion of the operation or the server is not responding.

This error occured very often in Asp.net Application. There are many solutions to resolve this problem. Lets Try these solutions one by one.
Solutions 1
Try adding a Connect Timeout in the web.config
<add key="DBConnection" value="server=LocalHost;uid=sa;pwd=;database=DataBaseName;Connect Timeout=200; pooling='true'; Max Pool Size=200"/>


Solutions 2
The solution is simple, change the CommandTimeout property of your SqlCommand object.
The Connect Timeout attribute of a connection string determines how long a SqlConnection Object runs before it stops attempting to connect to a server.

Sample Code

Dim myCommand As New SqlCommand(sql, myConnection, myTrans)
myCommand.CommandType = CommandType.StoredProcedure
myCommand.CommandTimeout = 0

When 0 is for no limit.
Solution 3
The "Timeout expired" error commonly occurs when an instance of the SQL Server Database Engine is not running, when the server name was typed incorrectly, or when there are network problems or firewalls.

Following are the cause and their solutions
A- Server name was typed incorrectly.
Try again with the correct server name.
B- The SQL Server service on the server is not running.
Start the instance of SQL Server Database Engine.
C- The TCP/IP port for the Database Engine instance is blocked by a firewall.
Configure the firewall to permit access to the Database Engine.
D- Database Engine is not listening on port 1433 because it has been changed, or because it is not the default instance, and the SQL Server Browser service is not running.
Either start the SQL Server Browser service, or connect specifying the TCP/IP port number.
F- The SQL Server Browser service is running but UDP port 1434 is blocked by a firewall.
Either configure the firewall to permit access to the UPD port 1434 on the server, or connect specifying the TCP/IP port number.
G- The client and server are not configured to use the same network protocol.
Using SQL Server Configuration Manager, confirm that both the server and the client computers have at least one enabled protocol in common.
H- The network cannot resolve the server name to an IP address. This can be tested using the PING program.
Fix the computer name resolution problem on your network or connect using the IP address of the server. This is not a SQL Server problem. For assistance, see your Windows documentation or your network administrator.
I- The network cannot connect using the IP address. This can be tested using the PING program.
Fix the TCP/IP problem on your network. This is not a SQL Server problem. For assistance, see your Windows documentation or your network administrator.

1 comment ( 13 views )   |  permalink   |   ( 3 / 371 )
Cyclomatic Complexity 
Friday, October 30, 2009, 02:19 PM - General
Posted by Administrator
Cyclomatic complexity measures the amount of decision logic in a single software module. It is used for two related purposes in the structured testing methodology.First, it gives the number of recommended tests for software. Second, it is used during all phases of the software lifecycle, beginning with design, to keep software reliable, testable, and manageable. Cyclomatic complexity is based entirely on the structure of software's control flow graph.
add comment ( 11 views )   |  permalink   |   ( 3 / 316 )
Cluster 
Thursday, October 22, 2009, 05:37 PM - General
Posted by Administrator
A set of computers that work together to provide a service. The use of a cluster enhances both the availability and scalability of the service. Network Load Balancing provides a software solution for clustering multiple computers running networked client/server applications.
add comment ( 6 views )   |  permalink   |   ( 3.2 / 367 )
Comega 
Thursday, October 22, 2009, 05:28 PM - .Net
Posted by Administrator
Comega :Microsoft bridging relational, object, XML data models.

Comega is programming technology, which is intended to bridge the gap between relational, object, and XML data models.

Comega, is described by Microsoft as a strongly typed, data-oriented programming language to bridge semi-structured hierarchical data (XML), relational data (SQL) and the .Net CTS (Common Type System). Additionally, Comega extends C# with asynchronous concurrency abstractions.

Comega tackles the issue of having to write repetitive code based on Microsoft’s ADO (ActiveX Data Objects) .Net technology

ADO.Net is great but it's a lot of repetitive code that you have to write again and again, and Comega provides a direct way to put SQL queries in your code base without the repetitive code
add comment ( 5 views )   |  permalink   |   ( 2.8 / 305 )
Imperative vs Declarative languages 
Wednesday, October 21, 2009, 04:59 PM - General
Posted by Administrator
The imperative language model requires the user to determine what the end result should be and also tell the computer step by step how to achieve that result.
It is analogous to asking a cab driver to drive you to the airport and then giving him turn by turn directions to get there.
SQL is different from many common programming languages such as c++ and visual basic because it is a declarative language. Languages such as c++, visual basic, c# and even assembler are imperative languages.

Declarative languages such as SQL, on the other hand let you frame problems in terms of the end result. All you have to do is describe what you want from SQL
Server via a query and trust the database engine to deliver the correct result as efficiently as possible. To continue the cab driver analogy from earlier, in a declarative language you would tell the cab driver to take you to the airport and then trust that he knows the best route.
add comment ( 1 view )   |  permalink   |   ( 3.1 / 298 )
Scaling Up & Scaling Out  
Tuesday, October 13, 2009, 10:07 PM - SQL
Posted by Administrator
Scaling Up Versus Scaling Out Database Server?

Scaling Up Vs. Scaling Out. When web application traffic grows there are two ways to handle it. Either Scaling Up or Scale out, what is it specially in case of Database server?

The most common approach to scaling applications is to scale them up. In essence, scaling-up simply means to keep increasing the resources (hardware) available on the server, allowing it to handle more load and user requests. The reason that this approach is so common is because it requires no change to the actual application and all of the data is in one place, which certainly helps reduce complexity and maintenance.

The second and more complex approach is scaling-out. The basic idea is to partition data across several database servers and therefore splitting the load of the application across multiple servers.

While scaling out web servers can be done quite easily, properly scaling out database servers is far more challenging.


add comment ( 1 view )   |  permalink   |   ( 3.1 / 309 )
Strong type vs Weak typing 
Tuesday, October 13, 2009, 09:57 PM - .Net
Posted by Administrator
What is strong-typing versus weak-typing? Which is preferred? Why?

Strong type is checking the types of variables as soon as possible, usually at compile time. While weak typing is delaying checking the types of the system as late as possible, usually to run-time. Which is preferred depends on what you want. For scripts & quick stuff you’ll usually want weak typing, because you want to write as much less code as possible. In big programs, strong typing can reduce errors at compile time.

Weak typing is where a language allows you to treat blocks of memory defined as one type as another (casting). Languages like C and C++, although statically typed, are weakly typed.

Languages like Perl and PHP are weakly typed because you can do things like adding numbers to strings and the language will do an implicit coercion for you.
Languages like Java, C# and Python are strongly typed - there is no way you can add a number to a string without doing an explicit conversion.

add comment ( 1 view )   |  permalink   |   ( 3.1 / 368 )
3G-Clear your doubts 
Saturday, October 10, 2009, 03:42 PM - General
Posted by Administrator
3G is a short term for third-generation wireless, and refers to near-future developments in personal and business wireless technology, especially mobile communications.

3G is include features such as:
·Enhanced multimedia (voice, data, video, and remote control)
·Usability on all popular modes (cellular telephone, e-mail, paging, fax, videoconferencing, and Web browsing)
·Broad bandwidth and high speed (upwards of 2 Mbps)
·Routing flexibility (repeater, satellite, LAN)
·Operation at approximately 2 GHz transmit and receive frequencies

3.5G is better than the much touted `3G' or third generation mobile networks where high speed data, voice and video can be exchanged.
The zippy new technology, is known as HSDPA — High Speed Data Downlink Packet Access — industry jargon which means the download speeds at which video or data can be sucked into a mobile phone could theoretically be as high as 10 mega bits per second (MBPS) — but in practice would be around a half to one-third this speed. It is the next evolutionary step in speeding up today's GSM or Global Services Mobile networks after it has upgraded to EDGE — Enhanced Data Rate for GSM and WCDMA — Wide Band Code Division Multiple Access.

some of famous 3.5g mobiles are nokia n95,nokia 6110 classic

What does the acronym UMTS stand for?
Universal Mobile Telephone System.

What is UMTS?
UMTS is one of the Third Generation (3G) mobile systems being developed within the ITU's IMT-2000 framework.
add comment ( 14 views )   |  permalink   |   ( 3 / 303 )
FullTrust 
Saturday, October 10, 2009, 03:41 PM - .Net
Posted by Administrator
Before the .NET Framework existed, Windows had two levels of trust for downloaded code. This old model was a binary trust model. You only had two choices: Full Trust, and No Trust. The code could either do anything you could do, or it wouldn’t run at all.

The permission sets in .NET include FullTrust, SkipVerification, Execution, Nothing, LocalIntranet, Internet and Everything. Full Trust Grants unrestricted permissions to system resources. Fully trusted code run by a normal, nonprivileged user cannot do administrative tasks, but can access any resources the user can access, and do anything the user can do. From a security standpoint, you can think of fully trusted code as being similar to native, unmanaged code, like a traditional ActiveX control.

GAC assemblies are granted FullTrust. In v1.0 and 1.1, the fact that assemblies in the GAC seem to always get a FullTrust grant is actually a side effect of the fact that the GAC lives on the local machine. If anyone were to lock down the security policy by changing the grant set of the local machine to something less than FullTrust, and if your assembly did not get extra permission from some other code group, it would no longer have FullTrust even though it lives in the GAC.

add comment ( 4 views )   |  permalink   |   ( 2.9 / 350 )

<Back | 1 |