StreetRite Connections: COM Object Toolkit

Home

Data Processing Software

Postal Coding Software

USA

StreetRite

StreetRite Add-Ons

StreetRite Connections: COM Object Toolkit

StreetRite: COM Object is designed to assist even the novice developer with the task of integrating the power of StreetRite address correction into a web or windows application.

[Discontinued. Suggested Alternative: AccuMail Gold]

What is COM?

The acronym COM stands for Component Object Model, a software architecture that allows the components made by different software vendors to be combined into a variety of applications. COM defines a standard for component interoperability, is not dependent on any particular programming language, is available on multiple platforms, and is extensible.

The COM Object connection solution is the easiest to use and is most often used in conjunction with the following development environments:

VBScript, JScript, JavaScript or CGI scripting for internet or intranet applications
Microsoft SQL Server 2000 (Transact SQL)
Microsoft Visual Basic
Microsoft Visual C++
Visual Basic for Applications (VBA) (MS Access, MS Word, etc...)
Visual FoxPro

The COM Object toolkit can be integrated into many other development environments as well as the ones listed above. Virtually any language that allows the creation of a COM object can be used with the StreetRite: COM Object.

Examples of Use:

Thanks to the design of the COM standard, the COM Object can be used in a number of different development environments. Most common is the integration of StreetRite's address correction functionality on company websites that capture addresses from visitors for the purposes of shipping an order or registering a user. The COM Object can also be used with database programs such as SQL Server 2000, Microsoft Access and Microsoft FoxPro and even word processing programs such as Microsoft Word and WordPerfect.

Implementation

The COM Object toolkit is very simple to use and can be implemented into the simplest of environments in as little as an hour or two. Below is an example of how easy it is to implement the StreetRite COM Object into to a typical ASP web page using VBScript:

    'Step One: Object Instantiation (Creation)
    Set SrgObj = CreateObject("SRGold.SRObject")

    'Step Two: Initialize the StreetRite database
    ReturnValue = SrgObj.Initialize()

    'Step Three: Clear buffers
    ReturnValue = SrgObj.ClearBuffers()

    'Step Four: Set your address input
    ReturnValue = SrgObj.SetField("COMPANY", "DSmart, Inc.")
    ReturnValue = SrgObj.SetField("STREET", "3868 State St")
    ReturnValue = SrgObj.SetField("SUITE", "Suite 100")
    ReturnValue = SrgObj.SetField("CITY", "Santa Barbara")
    ReturnValue = SrgObj.SetField("STATE", "ca")
    ReturnValue = SrgObj.SetField("ZIP", "93105")

    'Step Five: Perform Lookup
    ReturnValue = SrgObj.Lookup()

    'Step Six: Get Corrected and Extra Address Information
    company = SrgObj.GetField("COMPANY")
    street = SrgObj.GetField("STREET")
    street2 = SrgObj.GetField("STREET2")
    suite = SrgObj.GetField("SUITE")
    city = SrgObj.GetField("CITY")
    Urb = SrgObj.GetField("URB")
    state = SrgObj.GetField("STATE")
    zip = SrgObj.GetField("ZIP")
    zip4 = SrgObj.GetField("PLUS4")
    ErrorMsg = SrgObj.GetField("ERRORMSG")
    LastLine = SrgObj.GetField("LASTLINE")
    CongDist = SrgObj.GetField("CONGRESSIONALDISTRICT")
    CountyCode = SrgObj.GetField("COUNTYCODE")
    CountyName = SrgObj.GetField("COUNTYNAME")
    HouseNum = SrgObj.GetField("HOUSENUMBER")
    PreDir = SrgObj.GetField("PREDIR")
    StreetName = SrgObj.GetField("STREETNAME")
    StreetSuffix = SrgObj.GetField("STREETSUFFIX")
    PostDir = SrgObj.GetField("POSTDIR")
    SUD = SrgObj.GetField("SUD")
    UnitNum = SrgObj.GetField("UNITNUM")
    ResultCode = SrgObj.GetField("ERRORCODE")
    Corrections = SrgObj.GetField("CORRECTIONS")
    Leftovers = SrgObj.GetField("Leftovers")

    'Step Seven: Finalize (Close) the object
    ReturnValue = SrgObj.Finalize()

That is all there is to it! More examples like these are included with the COM Object documentation and program samples.

Requirements

Minimum	Recommended
Pentium or AMD class processor at 166 MHZ 32 MB RAM 100 MB Free Disk Space Windows 95 or higher operating system (Required by StreetRite database) Microsoft IIS 4.0 or higher for ASP page samples	Pentium or AMD class processor at 500 MHZ or higher 128 MB RAM 400 MB Free Disk Space Windows 98 or higher operating system (Required by StreetRite database) Microsoft IIS 4.0 or higher for ASP page samples

Toolkit Includes:

StreetRite COM Object API (Application Programming Interface) documentation
Sample program and source code for the following development environments:
- Microsoft Access 97
- Microsoft Access 2000
- Microsoft Access XP
- Microsoft SQL Server 2000 Using Visual Basic and ADO
- Microsoft SQL Server 2000 Using Transact SQL Language
- ASP Web Page using VBScript
- ASP Web Page using JScript
- Visual Basic 6.0 Test Application