IETester: Test multiple Internet Explorer versions

I got my new laptop recently and after I did the Windows Update, IE 9 appeared in my laptop. I wanted to keep IE 9, but I couldn't because our projects need to use IE 8 all the time.  It is easy to uninstall IE 9 and roll back to IE 8.

Go to Programs and Features.

Click View installed updates.

Right click Windows Internet Explorer 9 and you can uninstall it.

After rebooting machine, IE 8 is back.

If you would like to test web pages on multiple Internet Explorer versions at the same time, IETester is a good tool.

Data source name for Oracle 11g in Visual Studio is host name and service name

Before I worked on this project, I talked to my colleagues to provide the data source for Oracle 11g database because I wanted to use Visual Studio 2010 to connect to Oracle 11g and wrote a simple unit test.

They didn’t know what data source name looked like in Oracle 11g.  They showed me the configuration in Oracle SQL Developer. I talked to them: In SQL Server, you can use server name\instance name (ie. Test1\sst01) as a data source name. How about Oracle?  They felt so confused.

I can see host name and service name in Oracle SQL Developer. But what the data source name looks like in Oracle 11g ?

After several attempts, I found data source name = host name/ service name  and connection name can be anything else.

The interest part is that SQL Server uses “\”, but Oracle uses “/” as a data source name.

Next time if you like to connect to Oracle 11g via Visual Studio, you can try this way.

Fixed the MSTR Desktop issue-ActiveX component can't create object

Today I got a new laptop (Windows 7 x64) and I needed to install a lot of software to make my multiple projects work smoothly. After I installed MicroStrategy Desktop and double clicked desktop icon, I got the  following error : ActiveX component can't create object

After doing some research, it is easy to fix the issue via the following command lines.

cd \windows\syswow64

regsvr32 /u regobj.dll   

regsvr32 regobj.dll  

Next time if you have the same issue, this trick should work for you.

Use Telerik Test Studio to do MicroStrategy Web Test Automation successfully

Currently I am working on MicroStrategy Project where the authenticated users need to login to MicroStrategy Web report via their credentials and they can view Business Intelligence (BI) report and dashboard from our Oracle database 11g.  Therefore , the data accuracy is more important.

The current situation is that we need to create the report in MicroStrategy desktop and then compare the data visually between the desktop report and the web report. It is really time consuming. Our manager would like to know if it is possible to do MicroStrategy Web Test Automation.

That being said, I need to do the following things :

Get the value from Oracle 11g via Visual Studio 2010 (ODP.NET) based on SQL query

Login to MicroStrategy Web (Version 9.3) and view the report (http , https or proxy)

The value in each cell can be extracted.

Compare the values in DB and the ones in MicroStrategy web report

After several attempts, I find using Visual Studio Web Performance Test to extract the value in different cell from MicroStrategy Web report is not possible, but using Telerik Test Studio to extract the value is very easy.

The interesting part is that when I run my tests in Windows Server 2008 R2 SP1 machine using Internet Explorer 8, the report can't appear in MicroStrategy Web, but it is working fine in Chrome and Firefox. Therefore, I choose Chrome to run my automation in Windows Server 2008 R2 . I would say it is a MicroStrategy Product bug in IE 8 in Windows Server 2008 R2.

Next time if you would like to do MicroStrategy Web Test Automation, you can use Telerik Test Studio easily.

C# Unit Test: Put Negative Number in Bracket

Currently I use VSTS 2010 to write some unit tests to get the data from Oracle 11g and then do UI automation. I need to validate the value between the site and Oracle DB. However, the challenge part is that the value from DB has 3 or 4 decimal points, but the UI always shows 2 decimal points for numbers and 1 decimal point for percentage.

For example, I need to get the value from Oracle DB and then use percentage to display the value. If the value is negative such as -0.5%, the value needs to show (0.5%). 

Here is what I do:

Get the value from Oracle DB: “-0.005”

Convert string to double: -0.005

Format it to Percentage: "-0.5%"

If the value contains "-" sign, use ( ) to do the string format and then remove "-"

Get the value from the site and then compare the data between DB and the site.

I validate the data successfully. One interesting part is that the data is always correct in DB, but sometimes the value has the rounding error on the UI. I don’t feel surprised.