Posts

Log4net in windows service

Hi, Log4net not working in windows service although working same project as Windows Application. I just put [assembly: log4net.Config.XmlConfigurator(Watch = true)] into AssemblyInfo.cs and magically solved.

set Timeout ,Max Recieve Package size and no credential in WCF

1 - to increase Timeout in client; Open Web.config add parameter(s) into binding element as TimeSpan openTimeout= "12:00:00" receiveTimeout="12:00:00" closeTimeout="12:00:00" sendTimeout="12:00:00" 2 - to increase limiting Package Size in client; Open Web.config add below into Binding element as integer maxReceivedMessageSize="2147483647" 3 - to set non-security connection in service; Open Web.config add below into binding element as child element             good luck,

I am thinking...:)

                     Traditionally,systems such as databases and logic-programming systems have tended to support closed worlds and unique names, whereas knowledge representation systems and theorem provers support open worlds and non-unique names.

Retrieve User Settings such as Time Zone code or Localize Id in MSCRM 2011

Hi, You may need connected user settings or any user that you have ID. Please follow below;  var currentUserSettings = _serviceProxy.RetrieveMultiple(                 new QueryExpression(UserSettings.EntityLogicalName)                 {                     ColumnSet = new ColumnSet("localeid", "timezonecode"),                     Criteria = new FilterExpression                     {                         Conditions =                         {                             new ConditionExpression("systemuserid", ConditionOperator.Equal,UserID)                         }                     }                 }).Entities[0].ToEntity ();             //currentUserSettings.LocaleId;             currentUserSettings.TimeZoneCode.Value; //get TimeZoneCode good luck,

CRM Explorer/Tools missing from Visual Studio 2010

Image
if you ever find the Dynamics CRM 2011 Explorer / Tools options missing from within Visual Studio 2010 .... ... check prerequisites are installed:- 1. Visual Studio 2010 SP1 2. Silverlight 4 3. Windows Identity Foundation 4. CRM Developer Tools (found within the CRM SDK, Tools folder) Then check that the following is mentioned in your solution file (if you open the .sln file in a text editor): Save and reload the solution in Visual Studio 2010.  Do not append 'SolutionIsBoundToCrm = True' line to the below if you meet in your solution file. GlobalSection(SolutionProperties) = preSolution HideSolutionNode = FALSE EndGlobalSection good luck,

Exception caught instantiating TERADATA report server extension SQL Reporting Services

Hi, If you face an error in Reporting Services Log File (C:\Program Files\Microsoft SQL Server\MSRSxx_xx.MSSQLSERVER\Reporting Services\LogFiles) such as : extensionfactory!ReportServer_0-1!ea4!03/26/2013-08:20:15:: e ERROR: Exception caught instantiating TERADATA report server extension:  System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.  ---> System.IO.FileNotFoundException: Could not load file or assembly 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c' or one of its dependencies. The system cannot find the file specified. File name: 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c'    at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)    at System.Refl

flip rows to column in SQL Server

Below is a table that i use in the example; AttendeeName GroupName QuestionName AnswerName QuestionId Value Result Order SurveyId AnswerId Ahmet Ege Kisisel Bilgiler Askerlik Yaptiniz mi? (Q1) Evet (A1) 1 1 5 1 11 4 Ahmet Ege Kisisel Bilgiler Evli misiniz? (Q2) Hayır (A2) 2 1 6 3 11 5 Ahmet Ege Kisisel Bilgiler Is ariyor musunuz? (Q3) Evet (A3) 3 1 1 2 11 7 and the result expectation is;