16.4.12

Windows Task Manager Displays without Menu, Title Bar, Tabs, and Close Button

Today, I've faced a peculiar issue in my Vista machine. While trying to kill the process in Task manager, I've faced a peculiar nature of task manager. Except process screen(below) everything is vanished and I've tried a lot to fix up this issue but ended with no clue... OOPS.. too peculiar issue.


How to reporduce :  Double click on the border (Gray portion) of the Task Manager, you are able to get the above peculiar window. 

Solution:
The Task Manager switches to “Tiny Footprint Mode” when you double-click the gray area in the border around the tabs. You can switch back just as easily by double clicking the gray area around the outside of the frame. Not very intuitive but at least there's nothing wrong with Windows or my machine.


Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech

15.4.12

550 Authentication is required for relay with Outlook

Your message did not reach some or all of the intended recipients.


Subject: RE: Password...
Sent: 16-04-2012 07:27
The following recipient(s) cannot be reached:
'shiva shiva' on 16-04-2012 07:27
550 Authentication is required for relay

The reason for this error is that your email server requires SMTP Authentication to send outgoing mail. In order to resolve this issue you will need to configure your email client (Outlook, Outlook Express, Eudora, Thunderbird, etc) so that you are an authenticated user.



For Outlook do the following:

Click on the Tools menu in Outlook
Click on Email Accounts
Click View or change existing e-mail accounts
Click Next
Highlight an email account
Click Change
Click More Settings
Click Outgoing Server tab
Check the My outgoing server (SMTP) requires authentication


Make sure that Use same setting as my incoming mail server is selected
Click OK
Click Next
Click Finish and you are done


For Outlook Express do the following:

Click on the Tools menu in Outlook Express
Click on Accounts
Hightlight an email account and click Properties
Click the Server tab
Under the Outgoing Mail Server, check the "My server requires authentication" check box
Click the Settings button
Make sure that "Use same setting as my incoming mail server' is selected
Click OK
Click Apply
Click OK
Click Close and you are done

Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech

8.4.12

Code Snippet for random key generation in C#

Code Snippet for random key generation in C#:

private string generateSerialNum()
{
     Random r = new Random();
     StringBuilder sb = new StringBuilder();
     int size = 14;
     string legalnums = "0123456789";
   for (int i=0; i<9;i++)
   {
        sb.Append(legalnums.Substring(r.Next(0,legalnums.Length-1)+1,1));
} return sb.ToString();
}

private void SaleOrder_Load(object sender, EventArgs e)
{
    txt_SalesID.Text = generateSerialNum();
}

Cheers,
Venkatesan Prabu .J

3.4.12

fix: Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server.


Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server.



The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.


(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Solution:

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

1. The issue may be due to firewall.
2. SQL browser service is not running
3. SQL Server is not configured to allow remote connection
4. Check whether tcp/ip protocol is enabled for communication in sql server configuration manager -> Client and server protocols
5. Check tcp/ip protocols are enabled and active.
6. check whether you sql server logins are properly created and provided necessary level of authentication.

Cheers,
Venkatesan Prabu .J
Head, KaaShiv Infotech

2.4.12

Interesting Facts about execute command in SQL Server

Possible Error :

 Procedure expects parameter '@handle' of type 'int'.
Reason for this error:  From the error, you are able to predict that, the issue is due to the datatype. This issue may occur, if you are trying to execute a dynamic sql.

Try to execute the sql with sp_executesql.
Two options of executing to your sql

exec(@sql)  or exec sp_executesql @sql
I've succeeded the above issue and caught up the below issue now,

Invalid use of side-effecting or time-dependent operator in 'EXECUTE STRING' within a function.

The reason is, I am trying to use the exec sp_execuesql method inside a function which is not accepted by SQL Server. Here is a fantastic guide for your apetite.

http://jimbojw.com/wiki/index.php?title=SQL_2005_-_Why_You_Can't_EXEC()_Inside_a_UDF


Cheers,
Venkatesan Prabu. J
Head, KaaShiv InfoTech,
http://www.kaashivinfotech.com/