Archive for the 'Code' Category

Multiple ASP.NET Virtual Directories on One Web Site Server

Keep Reading ...

I have made a discovery this morning while attempting to configure two ASP.NET Virtual Directories on one Web Site Server.
The server houses IIS6 and is hosting several web applications for our QA group. IIS is responsible for hosting our ScrewTurn Wiki and an internal metrics gathering tool. The Wiki was built using the .NET Framework [...]

Divx Files on Zune

Keep Reading ...

I was recently looking for a way to enjoy Divx-encoded videos on my Zune — you know for road trips and such. Apparently some work has been done in this field, yet I have had little success in duplicating the effort.
The folks over at Techmixer.com have suggested the following steps:

Copy and paste the following [...]

My Blog’s Graph

Keep Reading ...

I was reading Griner’s Blog over at TheSocialPath.com and his latest post had an interesting image of a graph the blog. Of course, I got curious and decided to graph out my blog using this cool web page graphing site:
Webpages as Graphs

I am not sure what exactly it all means, but it sure looks purty.

Updating ActiveX Datagrids in QTP

Keep Reading ...

In my recent testing efforts, I have comes across a desktop windows form (written in VB6) involving updating a data grid and then calculating another field’s value based on those updates. In order to achieve this functionality, the development staffs implemented two events (AfterColUpdate and LostFocus) that, when triggered, would fire off the calculation method.
None [...]

Using QTP to Connect to an Oracle Database with Instant Client

Keep Reading ...

Need a light-weight ODBC connection to an Oracle database for you QTP scripts? Oracle Instant Client is just the ticket, assuming you have Oracle version 10g for your database. Please read the information provided by Oracle to make sure Instant Client is right for your needs.

Description Objects

Keep Reading ...

When creating reusable actions in QuickTest Pro, there are times you may come across the need to dynamically access an object within your application that may or may not exist within your Object Repository. One approach to handling this opportunity is through the use of Description Objects.
I could spend a lot of time attempting [...]

Selecting “SQL_Latin1_General_CP1_CI_AS” Collation in SQL Server

Keep Reading ...

Recently, I have had to install a named instance of SQL Server 2005 along side a default instance of SQL Server 2000. The 2000 server had the following collation configured: SQL_Latin1_General_CP1_CI_AS. For testing purposes, we had to make sure the new instance had the same collation setting.

Determine SQL Database Collation Setting

Keep Reading ...

If you want to determine the Collation setting for a particular database in SQL Server:

Open Query Analyzer (or SQL Management Studio)
Select your database
Execute the following query:

SELECT DATABASEPROPERTYEX(db_name(), ‘Collation’) SQLCollation;
Hope this helps.

Check SQL Collation Setting

Keep Reading ...

I have needed to check my SQL Server Collation settings recently. Here is a SQL Query to find your server’s collation setting.
SELECT SERVERPROPERTY(‘Collation’) AS ‘Collation’
Hope this helps.

Programmatically Create User Groups

Keep Reading ...

I have recently come across the need to create user groups on my local machine for a current project. I have researched and come up with a straightforward VBScript file that I can use as my basis for creating many user groups on each fresh testing installation.