Using SQL Management Studio in Windows 7
If you happen to be using SQL Management Studio in Windows 7 and need to connect to a SQL 2005 instance not running on the standard port of 1433, you might be having some problems connecting. For some reason this mix seems to require the SQL port to be manually defined when connecting to any named instance.
The fix is to specify the port in the server name used in the Connection prompt. So if your SQL instance was called SQL02 and running on port 3433, you’d use “MySql2005Server,3433 \SQL02″.
If you don’t know the port that SQL server is running on (maybe you have an external vendor supporting SQL), you can connect to the server from a Windows XP machine and run,
netstat -a | find /i "mysqlserver"
This will show you the network connection from your machine to the SQL server and the port being used.
Beware the leading zero in Javascript parseInt()!
Exhibit A,
parseInt('01'); //equals 1
parseInt('02'); //equals 2
parseInt('03'); //equals 3
parseInt('04'); //equals 4
parseInt('05'); //equals 5
parseInt('06'); //equals 6
parseInt('07'); //equals 7
parseInt('08'); //equals 0 !!
parseInt('09'); //equals 0 !!
When Javascript encounters a leading zero it assumes an octal number. So when it sees 08 or 09 then there are problems.
The fix is to add the radix to the function call,
myInt = parseInt('08',10); //equals 8Blog Categories
Recent Stuff
Similar Posts
Twitter Updates
- Working on 3G this morning via tethered ICS. Thank goodness for VPN and RDP among other acronyms
- RT @rmi: Competition is something that happens to people who can't afford to buy government. It doesn't affect telcos.
- We're new in the "Glen" but just found the local chippy is great. And downpour waited until we were driving home from picnic dinner. Nice
- @daihenwood I've got an older Nexus S with ICS. iPhone seems criplled now. Recommend a Google native experience cmpd to Galaxy S2,etc
- RT @AnonyOps: #Germany protests, #Greece burns, #Syria bleeds. #America watches the #Grammys.