(c) 2002 Visual Studio Magazine 
Fawcette Technical Publications

Issue: October 2002
Section: Database Design
Author: Jeff Jones
Filename: vs0210dd

The code for this article includes a VB6 project using this articles code, a complete middleware VB6 project (ActiveX DLL) that supports disconnected hierarchical recordsets, a VB6 project for testing the middleware DLL, and a VB.NET Windows Forms project. 

You can find Listing 1 in the listing.txt file.

After extracting the files, do the following steps:
1.	Run the SQL code in NorthwindSPs.SQL to create 
	the stored procedures in Northwind these examples
	require.
2.	Download the freeware ARCrypt DLL from 
	http://sevillaonline.com/ActiveX/.  This is used
	by the middleware project, RSTx.vbp, for 
	encrypting and decrypting the login 
	passwords when storing them to the registry.
3.	Compile the RSTX.vbp project, or simply register 
	the RSTx.DLL provided.
4.	Run the SampleVB6App.vbp (or the SampleVB6App.exe) 
	to test the code.  This code gives more in-depth 
	information that could be provided in the space
	availabel for the article.
5.	If you are interested in how this works in .NET, 
	look at the Test.sln project.  While shape SQL
	can be used with the OLEDBClient in .NET, it is 
	not nearly as efficient as the SQLClient when using 
	SQL Server.  
6.	If you have any questions about the code supplied, 
	you can email me at jjones4@bellsouth.net. 
7.	Code that is based on others' work is duly noted.