tag:blogger.com,1999:blog-39790593128294993782024-03-13T08:41:11.073-07:00My Knowledge BaseHakan Turanhttp://www.blogger.com/profile/16758109915115618604noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-3979059312829499378.post-28804329769051885412018-09-13T03:28:00.002-07:002018-09-13T03:28:38.967-07:00Windows 10 64bit slow disk performance. Disk %100 SolutionI had very slow performance on new laptop. Installations took ages and the machine is almost unusable during setups. Disk usage is at %100 . It's a Core i7 Asus X556UQ laptop. It was very slow.<br />
I had installed following intel driver from Asus website and problem solved. I think this driver works on all 6th gen an newer CPU laptops not matter what model it's.<br />
<br />
<a href="https://dlcdnets.asus.com/pub/ASUS/nb/DriversForWin10/IRST/IRST_Intel_Skylake_Win10_64_VER14811043.zip">https://dlcdnets.asus.com/pub/ASUS/nb/DriversForWin10/IRST/IRST_Intel_Skylake_Win10_64_VER14811043.zip</a><br />
<br />Hakan Turanhttp://www.blogger.com/profile/16758109915115618604noreply@blogger.com0tag:blogger.com,1999:blog-3979059312829499378.post-44840606618157081522018-09-12T04:21:00.001-07:002018-09-27T05:11:37.141-07:00Visual Web Gui Latest DownloadsThose in need of Visual Web Gui (VWG) releases, here's the link to download. Link is not mine, I'm not sharing or maintaining it.<br />
<br />
<a href="https://mega.nz/#!TYt0iJzQ!3zAaA-lySGzumLkndCnoIT_CaW1gPsFxpmynJ2ttKJ4">https://mega.nz/#!TYt0iJzQ!3zAaA-lySGzumLkndCnoIT_CaW1gPsFxpmynJ2ttKJ4</a><br />
<br />
The link has following files:<br />
<br />
VWG_Catalog_Sample_10.0.4_NET2.0.msi<br />
VWG_Catalog_Sample_10.0.4_NET3.5.msi<br />
VWG_Catalog_Sample_10.0.4_NET4.0.msi<br />
VWG_Catalog_Sample_10.0.4_NET4.5.1.msi<br />
VWG_Catalog_Sample_10.0.4_NET4.5.msi<br />
<br />
VWG_Professional_Studio_10.0.4_NET2.0.msi<br />
VWG_Professional_Studio_10.0.4_NET3.5.msi<br />
VWG_Professional_Studio_10.0.4_NET4.0.msi<br />
VWG_Professional_Studio_10.0.4_NET4.5.1.msi<br />
VWG_Professional_Studio_10.0.4_NET4.5.msi<br />
<br />
VWG_Professional_Studio_with_Sources_10.0.4_NET2.0.msi<br />
VWG_Professional_Studio_with_Sources_10.0.4_NET3.5.msi<br />
VWG_Professional_Studio_with_Sources_10.0.4_NET4.0.msi<br />
VWG_Professional_Studio_with_Sources_10.0.4_NET4.5.1.msi<br />
VWG_Professional_Studio_with_Sources_10.0.4_NET4.5.msi<br />
<br />
VWG_Catalog_Sample_10.0.5_b_NET2.0.msi<br />
VWG_Catalog_Sample_10.0.5_b_NET3.5.msi<br />
VWG_Catalog_Sample_10.0.5_b_NET4.0.msi<br />
VWG_Catalog_Sample_10.0.5_b_NET4.5.1.msi<br />
VWG_Catalog_Sample_10.0.5_b_NET4.5.2.msi<br />
VWG_Catalog_Sample_10.0.5_b_NET4.5.msi<br />
VWG_Catalog_Sample_10.0.5_b_NET4.6.msi<br />
<br />
VWG_Professional_Studio_10.0.5_b_NET2.0.msi<br />
VWG_Professional_Studio_10.0.5_b_NET3.5.msi<br />
VWG_Professional_Studio_10.0.5_b_NET4.0.msi<br />
VWG_Professional_Studio_10.0.5_b_NET4.5.1.msi<br />
VWG_Professional_Studio_10.0.5_b_NET4.5.2.msi<br />
VWG_Professional_Studio_10.0.5_b_NET4.5.msi<br />
VWG_Professional_Studio_10.0.5_b_NET4.6.msi<br />
<br />
VWG_Professional_Studio_with_Sources_10.0.5_b_NET2.0.msi<br />
VWG_Professional_Studio_with_Sources_10.0.5_b_NET3.5.msi<br />
VWG_Professional_Studio_with_Sources_10.0.5_b_NET4.0.msi<br />
VWG_Professional_Studio_with_Sources_10.0.5_b_NET4.5.1.msi<br />
VWG_Professional_Studio_with_Sources_10.0.5_b_NET4.5.2.msi<br />
VWG_Professional_Studio_with_Sources_10.0.5_b_NET4.5.msi<br />
VWG_Professional_Studio_with_Sources_10.0.5_b_NET4.6.msiHakan Turanhttp://www.blogger.com/profile/16758109915115618604noreply@blogger.com1tag:blogger.com,1999:blog-3979059312829499378.post-29565902347047354232015-10-19T05:02:00.002-07:002015-10-19T05:02:22.013-07:00Epias webservisine C# client'dan erişimEpias servisleri Java ile yazılmış ve bu servislere C# ile doğrudan erişirken sıkıntı yaşanıyor.<br />
Benim yaptığım adımlar şu şekilde.<br />
<br />
1. Epias'ın test sistemi olan <span style="font-family: Courier New, Courier, monospace; font-size: x-small;">http://95.0.37.186/dgpys/services/EVDServis?wsdl</span> adresinden WSDL dosyasını indirin. Bunu mesela EVDServis.wsdl olarak kaydedin.<br />
2. Bu WSDL'in en sonundaki URL farklı bir yeri gösteriyor olabilir, onu düzeltin<br />
En son satırlar şu şekilde olmalı<br />
<br />
<span style="font-family: Courier New, Courier, monospace; font-size: xx-small;"> <wsdl:service name="EVDServis"></span><br />
<span style="font-family: Courier New, Courier, monospace; font-size: xx-small;"> <wsdl:port name="EVDServisSOAP11port_http" binding="dgp:EVDServisSOAP11Binding"></span><br />
<span style="font-family: Courier New, Courier, monospace; font-size: xx-small;"> <soap:address location="<b><span style="color: blue;">http://95.0.37.186/dgpys/services/EVDServis</span></b>"/></span><br />
<span style="font-family: Courier New, Courier, monospace; font-size: xx-small;"> </wsdl:port></span><br />
<span style="font-family: Courier New, Courier, monospace; font-size: xx-small;"> <wsdl:port name="EVDServisSOAP12port_http" binding="dgp:EVDServisSOAP12Binding"></span><br />
<span style="font-family: Courier New, Courier, monospace; font-size: xx-small;"> <soap12:address location="<b><span style="color: blue;">http://95.0.37.186/dgpys/services/EVDServis</span></b>"/></span><br />
<span style="font-family: Courier New, Courier, monospace; font-size: xx-small;"> </wsdl:port></span><br />
<span style="font-family: Courier New, Courier, monospace; font-size: xx-small;"> </wsdl:service></span><br />
<br />
3. Command prompt açıp aşağıdaki komutu çalıştırın.<br />
<br />
<span style="font-size: x-small;"> <span style="font-family: Courier New, Courier, monospace;"> svcutil EVDServis.wsdl /wrapped</span></span><br />
<br />
SVCutil'i bulamazsa çalıştırmadan önce şu satırı path'e ekleyin. (Visual Studio 2013 kullandığınızı varsayıyorum, farklı bir versiyon kullanıyorsanız, svcutil'in yerini bulup PATH'i ona göre editleyin)<br />
<span style="font-family: Courier New, Courier, monospace; font-size: x-small;">set path=%path%;"c:\Program Files (x86)\Microsoft SDKs\Windows\v8.1A\bin\NETFX 4.5.1 Tools"</span><br />
<br />
4. EVDServis.cs isimde bir dosya oluşacak. Bu dosyayı .Net projenize ekleyin<br />
<br />
5. EVDServis.cs dosyasını açın ve StringValue[][] şeklindeki kısımları silip StringValue[] yapın<br />
<br />
6. Client'dan bir login çağırmayı deneyin, dönen nesne null ise, şu değişiklikleri yapın.<br />
EVDServis.cs dosyasını açın,<br />
<br />
Aşağıdaki satırı bulun, kırmızı ile işaretli kısmı silin. Yani Namespace="" (boş string) olsun.<br />
<br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;">public partial class loginResponse</span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;">{</span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"> </span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"> [System.ServiceModel.MessageBodyMemberAttribute(Namespace="</span><span style="background-color: red; font-family: Courier New, Courier, monospace; font-size: xx-small;"><b>http://ws.dgpys.deloitte.com</b></span><span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;">", Order=0)]</span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"> public LoginReport LoginReport;</span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"> </span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"> public loginResponse()</span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"> {</span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"> }</span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"> </span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"> public loginResponse(LoginReport LoginReport)</span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"> {</span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"> this.LoginReport = LoginReport;</span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"> }</span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;">}</span><br />
<span style="background-color: white; font-family: Courier New, Courier, monospace; font-size: xx-small;"><br /></span>
7. Login'i deneyin, başarılı ise bunu kullanmak istediğiniz bütün methodların Response class'ları için yapmalısınız.<br />
<br />
Kolay gelsinHakan Turanhttp://www.blogger.com/profile/16758109915115618604noreply@blogger.com1tag:blogger.com,1999:blog-3979059312829499378.post-4082552436144893542015-05-27T05:03:00.001-07:002015-05-27T05:03:50.375-07:00Visual webgui visual studio click twice problemWhen I first run a VWG application within visual studio, sometimes my first events are not fired. For example I click a button, the form tries to load itself.
This happens only on first run.
I disable "Just my code" debugger option in Visual Studio nad problem is fixed.Hakan Turanhttp://www.blogger.com/profile/16758109915115618604noreply@blogger.com0tag:blogger.com,1999:blog-3979059312829499378.post-88456956128150301812015-03-15T15:06:00.000-07:002015-03-15T15:06:35.033-07:00sql server 2005 701 insufficient memory errorWe receive 701 insufficient memory error every 2-3 days. Memory clerk report gives no clue. I've found the problem was related to Database Mail. Open your management studio and check for Database mail logs. If there's any problem with the configuration of one of the mail definitions like a changed SMTP ip etc, these errors are causing a memory leak. Fix the configuration and problem is solved.Hakan Turanhttp://www.blogger.com/profile/16758109915115618604noreply@blogger.com0tag:blogger.com,1999:blog-3979059312829499378.post-63816800920185723442014-10-24T01:04:00.001-07:002014-10-24T01:05:20.899-07:00String or binary data would be truncated.When running an update in SQL Server 2005, I receive String or binary data would be truncated error. It's strange because it's a simple update and there's no varchar field involved.
There's a update trigger in the table.
<b>Solution:</b> I receive this error when I login to management studio with Windows Authentication. If I login with a sql server user, I can succesfully execute the update statement.Hakan Turanhttp://www.blogger.com/profile/16758109915115618604noreply@blogger.com0tag:blogger.com,1999:blog-3979059312829499378.post-35982109918550747222014-06-13T05:59:00.000-07:002014-06-13T05:59:23.765-07:00mscorsvw.exe High CPU and disk activityAfter updating Visual Studio 2013, I observed high disk and cpu activity on process mscorsvw.exe
The folder under c:\windows\temp has many log files like MSIc4905.LOG, MSIc0dff.LOG totaling a few gigabytes.
When I checked those log files I've seen the following line
******* Product: {9C593464-7F2F-37B3-89F8-7E894E3B09EA}
Reinstalling VS 2013 is recommended but it didn't work for me. This is a key for a component of Visual Studio which I don't need.
I've searched the registry for {9C593464-7F2F-37B3-89F8-7E894E3B09EA}
Deleted every key matching and CPU restored back to normal, Visual Studio is running fine.Hakan Turanhttp://www.blogger.com/profile/16758109915115618604noreply@blogger.com0tag:blogger.com,1999:blog-3979059312829499378.post-6852945933959634362014-06-05T11:13:00.001-07:002014-06-05T11:13:15.552-07:00sql5005n: Unable to init API envWhen I try to import a DB2 catalog to Toad for db2 4.7, I got sql5005n: Unable to init API env error. Database alias combo is not populated.
This happens with 64 bit toad whereas 32 bit version is working fine. I had this problem under windows 8.1.
Solution: Forget catalog import on toad.
Run all below steps with administrator right
1. Install db2 64 bit client to windows.
2. Install Toad 64 bit
3. Edit registry , change HKLM\Software\Wow6432Node\QuestSoftware\Toad For DB2\4.7\DB2COPY key to DB2COPY1 (initial repository for IBM client)
4. Run IBM DB2 configuration assistant
5. Import catalog by using configuration assistant
6. Run toad, database alias combo is populated.
Hakan Turanhttp://www.blogger.com/profile/16758109915115618604noreply@blogger.com0tag:blogger.com,1999:blog-3979059312829499378.post-66645412283784892832014-05-19T03:12:00.002-07:002014-05-19T03:12:23.153-07:00Visual WebGUI undefined errorAfter you have developed your visual webgui form and pressed run, if all you get is "undefined" on the internet browser; Your new form class is not in the same namespace as your original application.
Hakan Turanhttp://www.blogger.com/profile/16758109915115618604noreply@blogger.com0tag:blogger.com,1999:blog-3979059312829499378.post-87602268525933769292014-05-18T11:05:00.000-07:002014-05-18T11:05:04.971-07:00SQL Server Management Studio Performance IssuesI work on VMWare Workstation 9.0 hosted Windows 2008 R2 Server. When I open Sql Server Management Studio, I experience sluggish performance while editing stored procedures. At that times I observe ssms.exe is hogging the cpu. Even a simple screen scroll causes %50 cpu spikes.
I've tried patching SQL Server and VMWare but no avail. I also tried suggested solutions like disabling SVGA driver etc.
As a solution, I logoff VMWare console and connect to server instance with remote desktop. No performance issue...
Hakan Turanhttp://www.blogger.com/profile/16758109915115618604noreply@blogger.com0tag:blogger.com,1999:blog-3979059312829499378.post-86813509651542157652013-10-10T03:54:00.002-07:002013-10-10T03:54:36.349-07:00Google mail IMAP ErrorHi, This is my first post.<br />
My employer uses gmail as corporate email. I access to gmail IMAP servers from my PC and mobile. In the last a few days I started getting <span class="GJHYW0UCKXB" id="t-t"><strong>Too many simultaneous IMAP connections</strong></span> error from both devices.<br />
Gmail IMAP server has a limitation like max. 10 connections. But how come my email clients can open so many connections?<br />
I first suspected that someone hacked my email account and changed my email password. No solution. Then I've searched the web and found this useful post<br />
<a href="http://productforums.google.com/forum/#!topic/gmail/0bRLzEjec-M">http://productforums.google.com/forum/#!topic/gmail/0bRLzEjec-M</a><br />
<br />
Checked my gmail with web browser and seen that my mobile device email client has created multiple sessions. How come? My cell phone connects to internet with wifi or 3g whichever is available. In the last a few days the wifi had some problems. So the cell phone keeps changing the IP address between 3g and wifi. For each new IP, email client creates a new connection so the limit of IMAP is reached.<br />
<strong>The solution:</strong> I have disabled the wifi on the mobile until it's permanently fixed.<br />
<br />
<br />
Hakan Turanhttp://www.blogger.com/profile/16758109915115618604noreply@blogger.com0