Go Back | KitCAD 1.1x Help Index

Office - MS Query - Advanced users help.

KitCAD2F.zip users do not need to setup DSN or DCom files.

This section requires KitCAD 1.18 users before 2002 to add the following DSN files to the ODBC data source location for Microsoft users to connect to the databases or servers.

Extract the files from SQL.zip To their locations
... KitCAD 1.20.dsn , KitchenPages.dsn
At: ..\..\Program Files\Common Files\ODBC\Data Sources


Using the 2 files included here, can allow users to create SQL's and DGY's files. Data may be acquired from the examples Named: KitCAD.qrt and KitCAD.dgy

The following applies to all KitCAD users. You can use a SQL to connect with the data produced by KitCAD after the user exports the plan data to the reporter, a simple query could be:

SELECT KitCad.PAGE, KitCad.NAME, KitCad.DIM_Y, KitCad.DIM_X, KitCad.ROTATION, KitCad.POS_Y, KitCad.POS_X, KitCad.HEIGHT, KitCad.HEIGHT_FRO, KitCad.VISIBLE, KitCad.COMMENTS, KitCad.LINK, KitCad.STYLE
FROM KitCad KitCad
ORDER BY KitCad.HEIGHT DESC, KitCad.NAME, KitCad.PAGE

Users now have the option of printing the report via a page preview, most kitchens are generated on one page. DCOM.ZIP is included for advanced users with server/client environments to allow KitCAD to interact with other application/s even if they are on another machine/s.

WARNING: NO UNINSTALL IS AVAILABLE AT THIS TIME FOR ADDON'S LIKE THIS THE DCOM.ZIP AND THE SQL.ZIP FOR OR WITH ANY KITCAD/KP PRODUCT/SERVICE.

KitCAD.exe can be set-up to use other applications:

The reason for separating 'KitCAD' came down to updating it and allowing users to write scripts, macro's, batches, and other file types to allow KitCAD.exe to interact with other applications which are not made by Kitchen Pages, or Mr. Jason Robinson. See the 'Extra Notes' below for more information.

Extra notes about KitCAD.exe or Render.exe:

For more information please see the HTML help file under the 'Advanced users' section about using DCOM for networks or enabling the registry entries on for KitCAD.

The SQL's are designed for use with Office97 and MS Query 8.0 and may require upgrading and resaving.

See Tables and exporting data for more information.
See BDE for ODBC connection information.

©Copyright 1999-2004, all rights reserved.

Updated on the 27th of June, 2004.