Microsoft Visual Studio 2012 Update 3 Is Out!

Update 3 is provided as Knowledge Base item KB2835600.
Link: http://support.microsoft.com/kb/2835600

What’s in this update:
Improvements –
Team Foundation Server

    • Build settings can be preserved when you upgrade a TFS 2012 instance.
    • Improvements are made in the New Build Definition UI for the Continuous Integration (CI) build in Git-based team projects.

Issue Fixes in categories –

Windows 8.1 compatibility issues
Visual Studio 2012 and Visual Studio 2013 Preview roundtrip
Debugger
Visual Studio IDE
Windows Form
C++
LightSwitch
Visual Studio Test
F#
Team Foundation Server
Web Tools
Office Collaboration
Team Explorer
Windows and Connected Application Tools
Portable Library
Profiler
Help Viewer

Posted in Computers and Internet | Tagged , , , , | Leave a comment

Solutions To Two Microsoft Visual Studio 2012 Errors: (1) This version of SQL Server Data Tools is not compatible with the database runtime components installed on this computer. An incompatible DacFx version is installed. – and – (2) WebForms UnobtrusiveValidationMode requires a ScriptResourceMapping for ‘jquery’. Please add a ScriptResourceMapping named jquery(case-sensitive).

I wanted to share the solutions to two frequently encountered errors for ASP.Net developers using the Microsoft Visual Studio 2012 development environment:

Error 1:
This version of SQL Server Data Tools is not compatible with the database runtime components installed on this computer
[followed by]
An incompatible DacFx version is installed

Solution 1:
The only way I was able to resolve this was by upgrading to the latest version of both Sql Server Data Tools (SSDT) and DACFx via the following links (the main MSDN links didn’t fix it for me – same problem persisted):
SSDT: http://msdn.microsoft.com/en-us/data/hh297027
DacFx: http://www.microsoft.com/en-us/download/details.aspx?id=35756

Error 2:
WebForms UnobtrusiveValidationMode requires a ScriptResourceMapping for ‘jquery’. Please add a ScriptResourceMapping named jquery(case-sensitive).

Solution 2:
First, understand that  UnobtrusiveValidationMode means that the scripting logic for the validation controls is utilized from the server versus in-page scripting. This means you must have the server side script paths defined within your Web application.
However, there are two ways to fix this. Either add the server side script paths, or you can simply turn off unobtrusive validation and utilize the all-client-side in-page (obtrusive) validation scripting.
(1) Adding the jquery script path:
Add the following (Visual Basic .Net code) to your application’s Global.asax class/file (if missing, right-click your web project in Solution Explorer and select ADD>NEW ITEM>select WEB>select GLOBAL APPLICATION CLASS to add it) in the Application_Start event handler:
C#:
ScriptManager.ScriptResourceMapping.AddDefinition(“jquery”, new ScriptResourceDefinition
{
     Path = “~/scripts/jquery-1.7.2.min.js”,
     DebugPath = “~/scripts/jquery-1.7.2.min.js”,
     CdnPath = “http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.4.1.min.js”,
     CdnDebugPath = “http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.4.1.js”
});
VB:
Dim oSRD As New ScriptResourceDefinition
With oSRD
     .Path = “~/scripts/jquery-1.7.2.min.js”
     .DebugPath = “~/scripts/jquery-1.7.2.min.js”
     .CdnPath = “http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.4.1.min.js”
     .CdnDebugPath = “http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.4.1.js”
End With
ScriptManager.ScriptResourceMapping.AddDefinition(“jquery”, oSRD)

(2) Disable UnobtrusiveValidationMode –
Add the following to your application’s Web.Config file:
<add key=”ValidationSettings:UnobtrusiveValidationMode” value=”None” />

Happy coding!

Posted in Computers and Internet | Tagged , , , , , , , , , , | Leave a comment

Access & Format EXT2 or EXT3 File System From Windows (XP Vista 7 8) Directly – Free & WITHOUT Using a Boot Disc! (For USB Flash Drive On Asus RT-N56U)

Those of you utilizing Asus‘ fantastic RT-N56U wireless router for a file / media  server via the 2 USB ports and flash drives are aware that you have few options if your flash drives are >32gb and you run Windows 7 as your primary OS on your main PC or laptop.

While the Asus router does recognize the NTFS file system, I’ve found it to be a VERY buggy experience with files frequently becoming corrupt and the media server often failing to index newly added files. Windows 7 GUI does not provide the FAT32 file system as another drive format option, opting instead for the exFAT file format (enhanced / extended FAT file system not subject to the FAT32 32gb limitation). But the exFAT file system is apparently not supported or recognized by the Asus router as of firmware version 3.0.0.4.360.

So what to do? Well, since the kernel of the Asus router OS is a flavor of Unix, it will recognize the EXT2 and EXT3 file systems without a hitch. But Windows does not have built-in support for the file system, and cannot read, write or format the implementation. This is where 2 products come in to save the day!

The first – a free open-source EXT2 / EXT3 Windows driver for reading these file systems like any other NTFS or FAT drive you add to your Windows machine – EXT2FSD ( http://www.ext2fsd.com/ ). With this driver added, and after a reboot, you can plug in an EXT2 or EXT3 formatted flash drive and start reading / writing files straight away. However, the ability to format a flash drive – WITHOUT EXITING WINDOWS AND USING A BOOT DISC – comes from a second product. EaseUS‘s Partition Master software ( http://www.partition-tool.com/personal.htm ) performs the EXT2/3 formatting right from the Windows application, and the functionality exists in their Freeware version too!

Between these two free tools, you can quickly get your >32gb drives (or smaller too for that matter) formatted to the best file system for your Asus RT-N56U router. Good luck!

Posted in Computers and Internet, Electronics | Tagged , , , , , , , , , , , , , , , , | Leave a comment

Microsoft SQL Server 2008 SQL Quirk – When Using TOP 1 In Query With Correlated Subquery

I found this quirk in Microsoft SQL Server 2008 T-SQL tonight – thought I’d pass it along to spare you the grief it gave me for nearly 2 hours:

SELECT TOP 1 CAST(ad.id_acct_biztax_detail AS INTEGER) AS id_acct_biztax_detail

      ,ad.dte_due_taxes

      ,ad.dte_received

      ,(SELECT SUM((ad2.amt_due_regular_tax + ad2.amt_due_excess_tax) (ad2.amt_paid_regular_tax + ad2.amt_paid_excess_tax))

                  FROM tb_acct_biztax_detail ad2

                  WHERE ad.id_acct_biztax_detail IN(ad2.id_acct_biztax_detail, ad2.num_return)) AS amt_bal_tax1

FROM tb_acct_biztax_detail ad

WHERE ad.id_acct_biztax_detail = @id_acct_biztax_detail

I was expecting the inner subquery to return 600 (amt_bal_tax1) for ID 1027409, but it was returning 0.
What I found was the TOP 1 limiter on the outer query was also limiting the inner query by default.
To get around it, you can tack on your own arbitrary TOP [n] to the inner correlated subquery:
,(SELEC TOP 50 SUM((ad2.amt_due_regular_tax + ad2.amt_due_excess_tax) (ad2.amt_paid_regular_tax + ad2.amt_paid_excess_tax))

                  FROM tb_acct_biztax_detail ad2

                  WHERE ad.id_acct_biztax_detail IN(ad2.id_acct_biztax_detail, ad2.num_return)) AS amt_bal_tax1

There is probably a better way to approach the issue – maybe a server variable setting or something – but for the moment I’ve burned out on the issue and haven’t the energy to go through MSDN or Google right now.

Posted in Computers and Internet | Tagged , , , , , , , , | Leave a comment

Java Update 21 For Version 7 SE Breaks Palo Alto / Cisco Network Systems Net Connect / NetConnect & Global Desktop / GlobalDesktop VPN Products With Unknown Compatibility Issue | UPDATE: Fixed With Java 7 Update 25!

UPDATE 7/6/2013: This issue has been resolved with Java 7 update 25!

The recent Java 7 Update 21 has some form of change that interferes with the functioning of Palo Alto / Cisco Systems NetConnect & GlobalDesktop products.

I had uninstalled all previous versions of Java and also uninstalled NetConnect, which removes the PAN Service and the desktop shortcut. When I updated the Java Virtual Machine to version 7 Update 21 Build 11 ( B11 ), the installer .msi would no longer extract properly (would create the installer msi but with a file size of 0kb) and an error “could not extract installer msi: null” would pop up.

The only way around this was to remove update 21 and go back to the previous public Java 7 release of update 17, which Oracle foolishly removed from their website but is thankfully still available from OldApps.Com:

Java 7 update 17 32-bit (x86 / i586): http://www.oldapps.com/java.php?old_java=11930
Java 7 Update 17 64-bit (x64): http://www.oldapps.com/java.php?old_java=11931

Hopefully either Oracle or Palo Alto will identify what the compatibility issue is and get it resolved soon.

Posted in Computers and Internet | Tagged , , , , , , , , , , , , , , , , , , , | Leave a comment

Visual Source Safe VSS ‘ Show Differences ‘ Function Not Work – Says ” Binary Files Differ “

This “Binary Files Differ” error/message was annoying the heck out of me, but I had been able to fix it by checking out the the offending file, opening it in TEXTPAD and saving it as format PC / ANSI, then checking it back in.

Even this work-around, however, had failed to fix one file this past week so I had to dig further. I’ve finally located an answer / fix:

“Visual source safe doesn’t always recognize text file types properly. when checking-in files using ‘auto‘ type — it treats them as binary.

“So when you compare two .sql files you might see ‘binary files differ‘ — and nothing more. (that’s how vss treats binary files).

The binary file differ
“The solution is to change the file type using the properties context menu for the file in source safe. Change the type to text, you should be able to perform the visual comparison. You can also click on the ‘advanced’ option when checking-in the file, and manually change the selection to ‘text‘ then.

“To avoid in the future – you can add file type settings under the options menu in visual source safe, to set the default behavior for various file types there.”

Posted in Computers and Internet | Leave a comment

Motorola Droid Razr MAXX HD XT926 XT926M – Take / Tear Down Disassembly Repair Screen Camera Battery

ImageThe new Motorola Droid Razr MAXX HD XT926 XT926M is supposed to be nano-coated internally to avoid damage due to light liquid, but it is not very often that the liquid coming into contact with your phone is merely a splash or drizzle. Such was the case with mine. My phone sat in a dual cup-holder adjacent to a (unbeknownst to me) leaking Styrofoam soda cup. By the time I arrived at my destination, the top of my phone was submerged in over an inch of soda.

The phone worked still, although the camera had stopped functioning. By the next day, the phone had run out of battery and would no longer power up. So began my quest to crack it open and see what I could see…

DISASSEMBLING THE XT926M:

Tools:
– micro torx bits T3, T4 and/or T5 (my bits aren’t marked, but I believe these are the right classifications)
– micro screwdriver
– tough plastic prying tools
– [optional] ‘spudger’ too

STEPS:
(1) Removing the LCD Display – Touch Screen – Digitizer – Assembly
– we start by removing the only screws visible on the exterior of the phone – the two torx screws at the very bottom of the housingImage
– with the two screws removed, you can now carefully *SLIDE* (do not lift!)  the LCD-portion of the display *BACK* (towards top of phone) from the lower half of the housing to disengage it, BUT BE AWARE IT WILL STILL BE ATTACHED BY 2 RIBBON CABLES. The LCD assembly frame has slight hook tabs which make it only possible to remove it in this slide-back manner.Image
– carefully unplug the two ribbon cables from the main housing by sliding them FLATLY towards the center of the phone to disengage from the main-board.Image
– DONE! You have removed your LCD assembly! LCDAssy
To remove the front-camera, remove the two torx screws, remove the metal housing, and carefully slide the camera’s ribbon-plug UP from the LCD-board plug.
– to reinstall, just reverse the above directions.

(2) REMOVING THE PHONE MAIN-BOARD (to get to the battery):
– remove all the visible torx screws (10 total) INCLUDING those on the camera assembly (2), the ear-phone plug assembly (2) and the remaining six on the main-board itself.Image
– carefully unplug the small power/volume switches ribbon cable from the right side of the main-board by sliding it towards the right side
– remove the battery power cable from the bottom-left of the main-board by first removing the transparent gold protective sticker, then sliding the ribbon connector down towards the bottom of the phone.
– lastly, and most difficult, carefully dislodge the main-board from the back shell BUT also pry out the speaker from the top-left when you get room OR YOU RISK BREAKING THE SMALL CONNECTOR WIRES! You will hear a small pop as the speaker un-snaps from the housing – then it is OK to continue prying the main-board from the shell.
– Note the small vibration motor is on the back of the board near the speaker.

(3) BATTERY REMOVAL AND FLASH REMOVALImage
– The battery is merely glued to the back housing, but be careful in prying it out because it IS bendable, not rigid. Keep it from bending as much as you can.
– The flash module is removed by taking out the four miniscule torx bits that hold it in. Replace it in the same manner.

Posted in Computers and Internet, Electronics | Tagged , , , , , , , , , , , , | 5 Comments