Posts Tagged ‘Java Programming’

SQL Server Express 2008: Timeout and Pre-login Errors

Sunday, March 15th, 2009

If you are getting Timeout or Pre-login Errors when trying to access MS SQL Server Express 2008 from a Windows Vista based client then read on!

Some of the reasons behind these errors (and the solutions) are given here:

http://technet.microsoft.com/en-us/library/ms190181.aspx

If the above does NOT resolve the error (as in my case) then before you start cursing Microsoft try this:

Go to the Network and Internet –> Network Connections

Right click on the connection being used (WiFi or LAN or any other).

I found IPv6 and and Link-Layer Topology protocols enabled which I disabled.

This partially resolved the issues. Database access was quite stable and I was able to do some of the work. But still things were not 100% normal. I was loosing the wireless connection and it was showing me connected to an ‘unidentified network’. Even the internet stopped working if the computer went into standby.

This it seems is a very common problem and more info can be found on the Microsoft site.

This problem results from

A) Issues with DHCP implementation difference between Vista and XP.

Read for solution: http://support.microsoft.com/kb/928233

B) Issues with power management profiles and WiFi networks

Read for solution: http://support.microsoft.com/kb/928152

[SQLServer JDBC Driver]Character set 437 not found in …

Monday, February 16th, 2009

If you face the following error message when you try and connect with Microsoft SQL Server:

[SQLServer JDBC Driver]Character set 437 not found in <PATH OF SQL SERVER LIBRARY e.g. com.microsoft.util >

1) Locate the jar file: msutil.jar – search for it or look in the MS SQL Server Drivers directory.

2) Unjar the file using WinRar or 7zip and extract all the files.

3) Go to the util folder (if msutil is the main directory then the path to the util folder is:msutil\com\microsoft\util)

4) Within the util folder locate a file called: transliteration.properties

5) Open the file in notepade or similar text editor program and add the following:

translit.type.437=VM
translit.name.437=Cp437

6) Save the file and either redirect the class path to the unjared folder with the edited transliteration.properties file or jar the msutil and replace the old msutil.jar with the new msutil.jar containing the edited file.