Equisoft is proud to present:

ESP for Visual Basic and SQL Server 2000

ESP has Won an Honorable Mention in the 

Innovative Product Competition Conducted by

SQL Server Magazine

This is a Visual Basic add-in that will save you hours of tedious programming if your project uses Visual Basic to manipulate a SQL Server 2000 database.

Download this trial version (good for 50 executions) and give it a try.

The retail per seat price is $200 US.

Customization is available to alter the systems form output and class methods.

Download and Install ESP for Visual Basic and SQL Server 2000

Download the Sample Project for ESP for Visual Basic and SQL Server 2000

Download the Documentation for ESP for Visual Basic and SQL Server 2000 NOTE! This file has been updated on 10/07/2002 with extended documentation!

 

The ESP add-in creates forms, class modules, and stored procedures that work "out of the box"  that you may then modify to suit your specific requirements.

Equisoft Home Page

What is ESP for VB?

This application is an Add-in for Visual Basic 6.0. It assists a developer by creating stored procedures in MS SQL Server Database and class modules and forms in VB that manage data in a SQL Server Database. 

In some cases, the developer is forced to create tables with many fields in order to satisfy the requirements of an application. These tables make it difficult to manage data without resorting to SQL statements that are executed directly (without the use of stored procedures). A data entry form may only be updating a few fields in a record and the developer is faced with either creating a stored procedure for each form, or executing SQL statements directly through a connection. Most database administrators will discourage the use of this method because security is compromised when users are allowed to execute SQL statements that are built in the “front end” application. The use of stored procedures and class modules is the preferred method for a two tiered application and is almost a requirement for an ‘n’ tiered application. A COM object that uses class modules is very efficient in terms of code maintenance. Stored procedures also simplify database security implementation because users only need permission to run the stored procedure, not the underlying tables. The drawback to using stored procedures for updating current records in the database occurs when the user needs to update a few fields in the row. Each input screen would need a different stored procedure, one for each set of input parameters. This is time consuming to write that many stored procedures and maintaining a large number of them can be a real problem.

 

Why not use the Visual Basic Form Wizard? The VB form wizard uses the ADO bound data control to do its work. In a multi-user application with many forms, the bound data controls use up many connections to the database, one connection for each bound control. This will cause you major problems down the road.

 

The ESP solution, makes use of one stored procedure for each class module that takes care of updating existing records, one stored procedure that retrieves data, and one other stored procedure to add new records. One class module and five stored procedures that can be used by any input form. The VB class module uses one ADO connection to communicate with the database and execute the stored procedures.