From the February 2002 issue of MSDN Magazine

MSDN Magazine

Resources for Your Developer Toolbox
Theresa W. Carey

RAD Tools for Visual Basic, ASP, and SQL


Lockwood       Lockwood Technical Services Inc. has announced the availability of a collection of rapid application development tools for developers using Visual Basic®, ASP, and SQL. The SQL Developer Pack includes Proc-Blaster, Auto-Audit, SQLClean, and Auto-Inserts. Proc-Blaster rapidly creates SQL stored procedures and the Visual Basic, ASP, and ADO code to process them.
      Auto-Audit automatically generates triggers to create a SQL Server™ 7.0 audit log and ships with a reporting utility. SQLClean detects and removes unused stored procedures, views, and tables in your SQL Server database. Auto-Inserts scripts SQL Server data into inserts scripts, allowing data reloads without causing referential integrity errors.
      The VB Developer Pack includes Proc-Blaster (as just described), Query-Blaster, and Auto-Error. Query-Blaster creates Access parameter queries and the Visual Basic, ASP, and ADO code to process them. Auto-Error adds error handling and line numbers to your Visual Basic project.
Lockwood Technical Services Inc.
8 Medway Branch Road
Norfolk, MA 02056
206-723-0887
https://www.lockwoodtech.com

Just the FAQs

      GT Technologies recently announced the availability of FAQ Factory, an editor and publisher for frequently asked questions (FAQ) Web pages. FAQ Factory runs on all desktop versions of Windows® from Windows 95 through Windows XP and generates a single output file, which can contain JavaScript, Cascade Style Sheet tags, XHTML and DHTML and can be placed on any platform. FAQ Factory comes with a number of different XSL style sheets, and you can create others to your specifications. FAQ Factory includes features such as unlimited topic levels, a mini HTML editor, a preview option, and site template support. The program allows you to maintain the UI of your Web site by allowing you to insert your FAQ into a Web page with a single comment tag.
GT Technologies
1375 NE Elk Court, #139
Bend, OR 97701
541-389-6628
https://www.faqfactory.com

XML-based Charting


IntraSight       Active Interface Inc. recently announced IntraSight, its interactive graphical reporting software for use in Web portals and dashboards. IntraSight is based on a lightweight ActiveX® or JavaBean component, and provides XML-based charting, graphics, and data visualization. IntraSight is targeted at specialized business intelligence, decision support, and enterprise performance reporting applications. Dozens of 2D and 3D templates are available for both traditional business charts and also for specialized reporting. IntraSight can request data from Active Server Pages that generate XML, or by using the Microsoft XML for Analysis SDK or XMLHTTP, and it can query SQL tables and OLAP cubes directly from the browser. Update periods can be defined for near-real-time reporting of continuously changing data sources pertaining to business or IT processes. IntraSight requires Microsoft Internet Explorer 5.x browsers and integrates with Microsoft SharePoint™ and SQL Server 2000.
Active Interface Inc.
P.O. Box 38475
Pittsburgh, PA 15238
412-901-1184
https://www.intrasight.com

Code Generation Engine

Palmersoft       Palmersoft has released The Palmersoft Generator, a power tool that uses a template-driven approach designed to provide overall control over type and style to programmers. With the Palmersoft Generator, users can create reusable Data Definitions to drive the code generation process. Data Definitions are lists of field attributes that the user can employ inside an application.
      The Palmersoft Generator combines Data Definitions with Models to produce code that is tailored to your specific needs. Data Definitions allow you to implement the same database functionality across several platforms, simultaneously generating source code for Visual Basic, SQL, C++, and HTML. Alternatively, with numerous modules in a Visual Basic project that refer to the same data, the Palmersoft Generator can author code for each of them by combining different Models with the same Data Definition.
      PalmerSoft Generator Models contain code in the language of your choice combined with intelligent keywords. During generation, the Models control what is generated and how that code is formatted. Keywords can be used to insert the names of variables from your database, intelligently enclose code, loop through the different types of fields in a table, and create legal variable names from field names.
PalmerSoft
10601 Tierrasanta Boulevard, #245
San Diego, CA 92124
https://www.PalmerSoft.com

Driver Development Tools


Jungo       Version 5.03 of WinDriver / KernelDriver / Hardware Debugger, and CompactPCI Hot Swap software (GO-HotSwap) is now available from Jungo Software Technologies Inc. The new release of these driver development tools includes WinDriver, KernelDriver and Hardware Debugger support for Windows XP (RC1), and WinDriver support for Windows CE 3.0. Based on Jungo's cross-platform technology, drivers developed using WinDriver or KernelDriver (current or previous versions) may be ported to the newly supported operating systems without additional code modification.
      WinDriver is a driver development toolkit for creating monolithic device drivers for custom hardware. It includes a graphical development environment, APIs, diagnostic and debug utilities and samples, which enable development of drivers under all versions of Windows from Windows 95 through Windows XP. WinDriver supports USB/PCI/CompactPCI/ISA/ISAPnP and EISA hardware.
      KernelDriver is a driver development toolkit that enables the creation of kernel-mode drivers, especially Layered (Filter and Miniport) and Standard drivers, providing tools for hardware debugging, driver code generation, and driver debugging. KernelDriver supports USB/PCI/CompactPCI/ISA/ISAPnP and EISA hardware. KernelDriver is a set of C++ classes that encapsulate long and complicated DDK tasks on Windows NT and Windows 2000. Hardware Debugger allows detection of USB/PCI/CompactPCI/ISA/ISAPnP/EISA hardware and its resources, without having to develop a driver. Hardware Debugger enables engineers to diagnose and verify untested hardware under all desktop versions of Windows since Windows 95. Hardware Debugger for PCI enables accessing memory and I/O ranges, listening to interrupts and defining and accessing registers. Hardware Debugger for USB allows monitoring and transferring of data through pipes.
      GO-HotSwap is a PICMG-compliant, cross-platform, Full Hot Swap software infrastructure for Windows 95, Windows 98, Windows NT®, and Windows 2000. It plugs into the operating system and adds all the necessary software modules required to support CompactPCI Hot Swap, such as Hot Swap events detection, dynamic resource allocation (while the system is running), PCI registers initialization, reenumeration and automatic initiation of software connection/disconnection processes.
Jungo Software Technologies
6 Hagavish Street
P.O. Box 8493
Netanya, 42504, Israel
877-514-0537, +972-9-885-8611
https://www.jungo.com

Enterprise Modeling Software


Popkin       Popkin Software has released System Architect V8.5. The product integrates business goals and processes, objects, components and data into a single conceptual framework that distills information down to the IT systems level for shared development. Features include UML 1.4 compatibility, XML integration, database-model synchronization, and a cross-reference editor.
      System Architect V8.5 enables businesses to develop a blueprint for an organization's information structure. A common, multi-user repository offers team collaboration, centralized information management, and data reuse. System Architect V8.5 supports design, development, testing, and deployment of an enterprise-wide architectural framework for the full development lifecycle, regardless of the methodology or the language.
      The product includes an XML modeling module, designed to facilitate sharing and reuse of XML components and schema standards for a deployed architecture. System Architect also supports UML 1.4 extensibility mechanisms with user-defined images including Web Application Extensions (WAE).
      The DB Synchronize feature can identify and help correct discrepancies between a model and database to keep developers and database administrators in sync, and supports SQL Server 7.0. The cross-reference matrix editor allows users to add, cross-reference, and update definitions across the repository. A multi-user repository enhances consistency and accuracy across workgroup development, allowing users to interact.
      System Architect supports various languages and databases, offers reporting and documenting systems, and provides HTML generation for model publishing over an Internet/extranet.
Popkin Software
11 Park Place
New York, NY 10007
800-732-5227, 212-571-3434
https://www.popkin.com

SQL Tools with Visual Basic

Perfect Sync       Perfect Sync Software has announced the release of Version 2.00 of its SQL Tools package, which has been upgraded to allow complete compatibility with Visual Basic. SQL Tools Version 2 gives developers a way to access databases using Visual Basic. The product is compatible with more than 50 databases, including Microsoft Access, SQL Server, Oracle, Excel spreadsheets, dBase, and MySQL.
      SQL Tools Version 2 allows developers to access SQL-compatible databases using Visual Basic with functions such as SQL_OpenDatabase, SQL_Statement, and SQL_FetchResult, avoiding the complexities of ADO, DAO, RDO, and OLE DB. SQL Tools works with any version of MDAC, including the versions that are preinstalled on Windows 98 SE, Windows Me, Windows NT 4.0, Windows 2000, and Windows XP. It is not usually necessary to distribute database drivers with a Visual Basic-based program when you use SQL Tools.
      SQL Tools is available in two versions. SQL Tools Standard Version 2.00 provides all of the basic database functions that most small to medium projects will require. SQL Tools Pro Version 2.00 adds a wide range of features for medium to large projects.
Perfect Sync Software
8121 Hendrie Boulevard, Suite B
Huntington Woods, MI 48070
248-546-5300
https://www.perfectsync.com

Change URLs on the Fly

Qwerksoft       Qwerksoft recently announced the availability of IISRewrite 1.2, a URL rewriting filter for Microsoft Internet Information Services (IIS) that allows requested URLs to be changed on the fly. This ISAPI filter offers Webmasters greater control over the URL as seen by the client. With IISRewrite, URLs that look static to a browser can actually be rewritten dynamically by the server (such as /catalog/128/index.htm to /catalog.asp?id=128). Static URLs allow greater portions of dynamically generated sites to be indexed by search engines and increases Web site visibility on the Internet.
      IISRewrite has a flexible URL rewriting engine based on regular expressions. URLs that match a regular expression can be rewritten into another URL, redirected to another location, or forbidden entirely. It can also rewrite URLs based on variables (such as the User Agent or the Server Port) and has logging capabilities. IISRewrite can be used to catch IIS vulnerabilities for logging and reporting, protect Web sites from "deep linking" of images and files, and is able to rewrite download links to work around browser bugs.
Qwerksoft
1648 Willow Drive
Kaysville, UT 84037
888-282-5887
https://www.qwerksoft.com

Catch and Kill Bugs


Excel       Excel Software is shipping QuickBugs, a tool for reporting, tracking, and resolving the bugs, issues, changes, and new features involved in product development. Key attributes include a shared repository accessible to multiple users, multiple projects with assigned responsibilities, and configurable access and privileges for users on each project. Most features in QuickBugs are configurable to the organization and specific user needs including data collection fields, workflow, views, queries, reports, security, and access control. QuickBugs is a single exe that implements cooperative clients of a shared repository of XML-based data. Given its XML-based foundation, all bugs, views, queries, reports, and configuration data are completely accessible to third-party tools.
      Developers can investigate and resolve problems that are categorized, prioritized, and sorted to their specific needs. Testers can generate bug reports and verify corrected problems while evaluating the efficiency of bug detection methods. QuickBugs maintains the workflow, access control, and history of each bug during its lifecycle. It runs on Windows 95, Windows 98, Windows NT, Windows 2000, and Windows XP.
Excel Software
19 Misty Mesa Court
Placitas, NM 87043
505-771-3719
https://www.excelsoftware.com

Web Site Performance Analysis

eIQnetworks       eIQnetworks Inc. has introduced eIQ LogAnalyzer 2.0 and eIQ Professional Suite 2.0, which include features such as FTP server analysis, proxy server analysis, streaming media analysis, monitoring, and alerting. eIQ Analytics Series 2.0 solutions provide Web-analysis data such as what content visitors are looking at, which paths they are following to reach key information, what sites they're coming from, which external sites intranet users are visiting, and which streaming media clips are most popular.
      eIQ LogAnalyzer is the entry-level Web and FTP log analysis and reporting solution for businesses looking to improve site performance by analyzing visitor behavior and site activity.
      Targeted for single-server Web sites, LogAnalyzer produces up to 80 essential reports on Web and FTP site visitor patterns, site usage, referring sites, visitor paths, demographics, and more. The built-in scheduler allows for automated delivery of reports in many formats to multiple users within an enterprise.
      eIQ Professional Suite is targeted at small and medium-sized businesses operating multiple Web or FTP servers, offering Web and FTP log analysis, proxy server analysis, streaming media analysis, monitoring, and alerting features.
eIQnetworks Inc.
2 Old Weston Road
Wayland, MA 01778
508-358-7601
https://www.eiqnetworks.com

Build Thin Client Applications

MicroOLAP       MicroOLAP Technologies has announced the release of MySQL Direct Access Components (MySQLDAC), a library of native VCL components for direct access to MySQL database server. MySQL Direct Access Components provides direct access to MySQL server from Borland Delphi/C++Builder applications, without requiring BDE/ODBC on the client side. It supports all MySQL-specific features (Show, Transaction, Ping, Kill Process, Check and Repair Table, and more) and simplifies client/server application development. Features include Insert, Update, Delete and Refresh, support of BLOB fields, and the ability to speed up record fetch from the database. The library also includes the TDBImageEx component for JPEG images. The interface of MySQLDAC is BDE-compatible, so this component set allows migration of existing projects from the BDE/ODBC scheme to the native one. MySQLDAC supports MySQL 3.23.xx-stable versions for all existing platforms.
microOLAP Technologies LLC
208 West State Street
Trenton, NJ 08608
https://www.microolap.com
Send your New Stuff to Theresa at newstuff@microsoft.com.
Theresa W. Carey is a freelance writer who lives in California. Her byline has appeared in Barron's and PC World.