dewaMediashort . informative
Securing Zip File
Challenge: We have a SQL database backup and we move this database from one server to another with a different network. For the security, we need to do the password protected prior moving the files. Solution: 7-zip has a command line that can be utilised. Download the 7-zip from: http://www.7-zip.org Examples how to use: http://dotnetperls.com/7-zip-examples
How do I add .jad file into my Blackberry device?
Challenge: Spent few minutes to hook up the device and using the Desktop Manager to download the .jad file and find out is not working. Solution: Apparently, the .jad file is loaded via Blackberry browser. So all you have to do just go the browser and go the link and it will automatically download and [...]
Pivoting using STUFF and XML Path in SQL
Challenge: I have these 3 simple tables 1) Users: UserID INT, Username VARCHAR(32) 2) UserInRoles: UserID INT, RoleID INT 3) Roles: RoleID INT, RoleName VARCHAR(32) So if I joinining these 3 tables I might end up with for instance: UserID, Username; RoleName: 1; ‘test’; ‘Administrators’ 1; ‘test’; ‘Mobile Users’ 2; ‘test1′; ‘Administrators’ As you can [...]
Linksys WAP4400N and Windows Vista Issue after Firmware Upgrade
Challenge: We’ve done the firmware upgrade for the Linksys WAP4400N and after that all clients can’t connect especially Windows Vista machine. The interesting is that the IPhone device can connect no problem. Solution: What we found that the current configuration that we have on the Vista is no longer working. It needs to reset as [...]
File too large for the destination file system
Challenge: I experienced an issue with external USB drives when I transfered 10GB from my laptop to external harddrive. Solution: The reason for this is going to be the file system of the USB or destination that you are copying the file to. The file that you are trying to transfer or extract is greater [...]
Sharepoint in General
Solution: Application Templates for Windows Sharepoint Services 3.0 http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb407286.aspx To install this download: Note: To complete the following installation, you must have Administrator rights to both the Windows SharePoint Services site on which it is to be installed. Download the file by clicking the Download button (above) and saving the file to your server. Pull [...]
.NET ReportViewer Control and Export to CSV
Challenge: As you know that by default, the ReportViewer control can only support Excel and PDF. As far as know it’s not even support the native Excel 2007. Solution: At this stage, I have no concrete solution yet but I have some hints that might help which are: 1) There is a method called .LocalReport.Render() [...]
.NET ProfileCommon in App_Code
Challenge: In the inherited aspx page of my base class page, the following code works great: ProfileCommon pc = Profile.GetProfile(tmp_username) But then if you put into in a class which states in the App_Code won’t work ?!?! Solution: From App_Code you would do this: ProfileCommon p = (ProfileCommon)ProfileBase.Create(tmp_username,true); System.Web.Profile.ProfileBase is the ASP.NET type that underlies [...]
Loading up Issue on FireFox 3.0
Challenge: For some reason when I open up Firefox 3.0 even on the safe mode, the following error come up: Firefox is already running but it’s not responding. To open a new window, you must first close the existing Firefox process, or restart your system. Solution: What I found is that it’s relating to the [...]
CutePDF and Ms Excel Printing Issue
Challenge: Client raised the issue that everytime he’s printing this Excel workbook into PDF using CutePDF, turns out that is only few sheet that he can print. Where is the rest? Solution: Reducing the number of sheet didn’t work. Moving around the sheet didn’t work either. Almost give up, finally the client is finding the [...]
