Archive

Archive for the ‘Issues’ Category

Issue in accessing blogger site with live writer

January 1, 2015 Leave a comment

Today I installed live writer 2012 into my PC but I couldn’t access Blogger sites with live writer. But it worked with WordPress and other sites. I searched and found that Google has changed their security policy and remove access to blogger with external tools like live writer.I could overcome this issue with following steps:

Go to https://myaccount.google.com/ or simply account settings. Under Signing in title it has option Access for less secure apps set to Blocked. Just click on this option and set to enable. And another thing if you don’t have blogger account this option might not visible.

Categories: Issues Tags: , ,

Solution for problem with starting MSDTC and Missing Local DTC in Windows 7

June 28, 2012 2 comments

When I tried to execute one of C# application that is using transaction scope, I found that i couldn’t start MSDTC service( I was using windows 7(64bit)).I tried following link and solved that problem.

link:http://social.technet.microsoft.com/Forums/en-ZA/winserverhyperv/thread/d3de5460-fb42-4af0-ac75-27c22741c7e9 .

Then I found that there are no Local DTC in MSDTC.(I checked with component services ( start->type component services)).I tried following steps too.But still no luck.(But hope sometimes it works).

msdtc

1) Stop the Distributed Transaction Coordinator service in the Services Control Panel

2) At a command prompt run "msdtc -uninstall" without quotes. This removes the MSDTC service from the Services Control Panel and the associated service hive along with the CIDs and CID.Locals from the registry:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSDTC
HKEY_CLASSES_ROOT\CID
HKEY_CLASSES_ROOT\CID.Local

3) Skip this step if you want to preserve existing configuration, such as network transactions and other MSDTC security settings. Otherwise manually delete the following registry keys if they exist:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSDTC
HKEY_CLASSES_ROOT\CID
HKEY_CLASSES_ROOT\CID.Local
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC

4) At a command prompt run "msdtc -install" without quotes. This reinstalls the MSDTC service and the 4 registry hives above.

5) At a command prompt run “msdtc –resetlog” without quotes

Then I browsed to C:\windows\System32\MSDTC folder but I couldn’t access that one.Next I reboot machine and logged in safe mode and deleted that folder and create new MSDTC folder.

Still I couldn’t found Local DTC.Then I stopped windows firewall service in services.msc and virus guard firewall service.Then I tried above steps.Eureka now it works fine. I found that it was happen due to some Microsoft updates.It’s not fair to forget the key factors in solving this.Thanks Dilshan and Kavinda bro’s.

Hope this one help you to solve your MSDTC problem.Until next post cheers..!!!

Categories: Issues Tags: , , ,

MSSQL useful tips

March 13, 2012 Leave a comment
  • MSSQL set null when value is not numeric in select query
SELECT CASE ISNUMERIC(column1) WHEN 1 THEN column1 ELSE NULL END FROM table1
  • SQL Server Error Messages – Msg 8152 – String or binary data would be truncated.  The statement has been terminated.

This error message is occurred when I tried to insert data to values from another table.It’s due to one column in the table that im inserting data have lesser length than other table column.(varchar(25) – varchar(max)).It couldn’t found previously because second table column I have used max length but when inserting data it filled with strings that contains more than 25 characters.

I found another command to skip that error and continue but its like a try catch statement without catch part(thanks yasindu bro for nice example).

SET ANSI_WARNINGS OFF

Need to use above command before inserting records.but sometimes it’s not working

  • Inserting multiple records to a table

This isn’t simple thing but I previously work with MySQL and that is different and we can’t use

INSERT INTO tblName (column1,column2)
VALUES
('Value1','value11'),
('Value2','value22'),
('Value3','value33')
INSERT INTO tblName (column1,column2)
select ‘Value1′,’Value11’
UNION ALL
select ‘Value2′,’Value22’
UNION ALL
select ‘Value3′,’Value33’
Categories: Issues, Programming, TSQL Tags: , ,

How to share internet connection from laptop in Windows 7

May 25, 2011 Leave a comment

First need to setup adhoc network for that follow below steps

1)go to Network and Sharing Center

Control Panel->Network and Internet->Network and Sharing Center

or click on the network icon in the tray image or image then open Network and Sharing Center

2)choose manage wireless network 

or Control Panel\Network and Internet\Manage Wireless Networks

3)Add->create an adhoc network->next->set network name and set security type (for open connection select no authentication option)->next

Then need to share internet connection

1)right click on internet connection->properties->sharing->set allow and click ok

check whether wifi is on

Categories: Issues Tags: , , , ,

Installing Zend Server with WAMP Server

May 13, 2011 Leave a comment

I have tried to install zend server after installing wamp server but zend server wasn’t working properly.The reason was both wamp and zend servers were using the same port 80 you can check it by leftclick on wamp icon->apache->test port 80 it gives message like it is used.So have to do is change zend server port to 81 or if wamp run on port 81 then turn it to 82 or something.

Categories: Issues Tags: , , ,

Problem with WAMP Server

May 12, 2011 Leave a comment

I have developed many sites with PHP with WAMP Server.So I thought I had some experience in WAMP.But after installing new WAMP Server I doubt about that.Because it was always offline.WAMP icon shows yellow it means some working but not all.Actually I could use MySQL but not PHP.I tried MySQL by left click Wamp icon->MySQL –>MySQL console it works.I search many blogs and most of says it might be due to Skype or IIS server but I didn’t have installed IIS and I checked by uninstalling Skype,still I got offline color.

Then I tried to stop some other related services in Control Panel\All Control Panel Items\Administrative Tools\Services or you can get that window  by right click MyComputer icon –>manage->Services and Application->Services if you are an administrator of that machine you can start or stop services on that list.But it doesn’t work for me.

I searched it again.Then I found one video with editing some code but it’s boring and so long to edit so I kept that away.after I found a article how to do that simply.just go to WAMP icon & left click->apache->services->test port 80  then I found “your port 80 is actually used by server microsoft-httpapi 2.0” so I found at last it was taken by some other process.So I did change the port no 80 to 81 it works for me.you can edit that one from editing httpd.conf in  WAMP icon & left click->apache->httpd.conf search listen 80 and edit that to 81.

Categories: Issues Tags: , ,