文件列表:

虚拟电子秤_陈锡辉\data.xls (668, 2007-05-06)
虚拟电子秤_陈锡辉\用户信息.mdb (143360, 2007-05-06)
虚拟电子秤_陈锡辉\虚拟电子秤_陈锡辉.aliases (47, 2007-05-08)
虚拟电子秤_陈锡辉\虚拟电子秤_陈锡辉.lvproj (8758, 2007-05-08)
虚拟电子秤_陈锡辉\虚拟电子秤_陈锡辉.vi (166188, 2007-05-08)
虚拟电子秤_陈锡辉\SubVIs\SQL_Execution.vi (21812, 2007-05-08)
虚拟电子秤_陈锡辉\SubVIs\修改密码.vi (20388, 2007-05-04)
虚拟电子秤_陈锡辉\SubVIs\模拟数据发生.vi (20108, 2007-05-04)
虚拟电子秤_陈锡辉\SubVIs\用户登录.vi (28740, 2007-05-08)
虚拟电子秤_陈锡辉\SubVIs\用户管理.vi (116316, 2007-05-06)
虚拟电子秤_陈锡辉\SubVIs\自定义错误对话框.vi (9956, 2007-05-04)
虚拟电子秤_陈锡辉\SubVIs (0, 2007-06-29)
虚拟电子秤_陈锡辉\LabSQL\ADO210.CHM (769740, 1999-05-31)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\SQL Execute.vi (30628, 2007-05-04)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\SQL Fetch Data (GetString).vi (28624, 2007-05-04)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\SQL Fetch Data.vi (74594, 2001-02-27)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Fields Get Count.vi (25116, 2001-02-27)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Fields Item.vi (27395, 2001-02-27)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Item Value.vi (27494, 2001-02-27)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset BOF.vi (25473, 2002-11-18)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset Cache Size.vi (25716, 2002-11-18)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset Close.vi (24187, 2001-02-27)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset Create.vi (23084, 2002-11-18)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset Destroy.vi (14920, 2007-05-04)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset EOF.vi (26225, 2002-11-18)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset Get Fields.vi (25868, 2001-02-27)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset GetString.vi (26748, 2007-05-04)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset Move.vi (26586, 2002-11-18)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset MoveFirst.vi (24211, 2001-02-27)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset MoveLast.vi (24174, 2002-11-18)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset MoveNext.vi (24194, 2001-02-27)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset Open.vi (35222, 2002-11-18)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\ADO Recordset RecordCount.vi (25601, 2002-11-18)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset\dir.mnu (3296, 2001-04-20)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Recordset (0, 2007-06-29)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Connection\ADO Connection Begin Transaction.vi (25776, 2002-11-18)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Connection\ADO Connection Close.vi (16524, 2007-05-04)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Connection\ADO Connection Commit Transaction.vi (23993, 2002-11-18)
虚拟电子秤_陈锡辉\LabSQL\LabSQL ADO functions\Connection\ADO Connection Create.vi (15776, 2007-05-04)
... ...

LabSQL release 1.1a (c) 2002 Jeffrey Travis (Jeffrey Travis Studios) Version 1.1a - Nov 17 2002 - some VIs in version 1.1 were indavertently saved under LabVIEW 6.1. In order to preserve compatibility with LabVIEW 6.0, all LabSQL VIs are now 6.0-compatible. Version 1.1 - Sep. 2002- fixes a rare bug where text with special characters like tabs (\t) that were part of a database record could produce buggy behavior. 0. INTRODUCTION ---------------- LabSQL is the beginning of an open source project to provide free, multi-database, multi-platform database connectivity support for LabVIEW. In this first release, we have used the Microsoft ADO object to provide connectivity in LabVIEW for Windows for any ODBC-compliant database, including Access, SQL Server, Oracle, Pervasive, Sybase, etc. Future versions may include JDBC suport for DB connectivity on other LabVIEW platforms, but there are no immediate plans to add this. Using LabSQL assumes you have at least a basic knowledge of SQL commands and database terminology such as tables, rows, fields, DSN. It also will help for you to familiarize yourself well with the ADO methods and properties. You can peruse the ADO help file included with this release, or visit http://www.microsoft.com/ado A trivial sample Access database and 3 examples are included with this LabSQL utility. 1. INSTALLATION --------------- 1a. System Requirements: ----------------------- Because this version of LabSQL relies on an ActiveX component (ADO), it will only run on LabVIEW for Windows (version 6.0 or higher). Although the database you connect to can be theoretically on any platform and on a remote machine, it must have an ODBC driver for Windows installed on your local machine. In addition to LabVIEW, you need to have the latest version of the MDAC (Microsoft Data Access Components) ActiveX components, which includes ADO, installed on your machine. You may already have it installed, but if you don't, you can download it at http://microsoft.com/data 1b. Setup ---------------- 1. To install LabSQL, simply place the "LabSQL ADO VIs" in any convenient directory. For ease of use, we suggest you create a custom palette under the "User Libraries" LabVIEW palette that links to this directory, so you will have easy access to the ADO VIs. See the LabVIEW documentation if you need to know how to create a custom palette. 2. As with any database application on Windows, you'll need to create a DSN (Data Source Name) in the ODBC control panel. This DSN is used in your LabVIEW application to connect to the appropriate database. If you want to set up the example database, do the following: a.Go to your Windows Control Panels, and open "ODBC Data Sources" b.Click on the "System DSN" tab c.Click on the "Add..." button. d. From the list of drivers, choose "Microsoft Access Driver" e.At the dialog box, type in "myDB" for the Data Source Name. Then click on "Select..." button, and find the file "Sample Database.mdb" included with the LabSQL examples. Leave everything else as it is, and hit OK. f. Close the ODBC control panel g. Test the connection by running one of the examples provided. 2. Using LabSQL ----------------- Using LabSQL is mainly a matter of understanding how SQL statements work and how the ADO object work: the Command object, the Connection object, and the Recordset object. You can use the top-level "easy" VI called "SQL Execute.vi" to directly execute a SQL statement. The three simple examples provided show you how to retrieve data, insert a row, and use recordsets to move through one row of data at a time. 4. TECHNICAL SUPPORT -------------------- No formal technical support is offered on LabSQL. It's free for you to use at your own peril. While I can't promise I will have time to look into any issues, you may contact me with bugs or comments at: Jeffrey Travis Also, if you enhance or add onto LabSQL, please let me know so I we can keep the LabVIEW community informed with up-to-date versions! Enjoy!

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：