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 <labsql@jeffreytravis.com>
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!
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
经颅磁治疗仪控制,SQL存储.zip源码Labview个人项目资料程序资源下载经颅磁治疗仪控制,SQL存储.zip源码Labview个人项目资料程序资源下载经颅磁治疗仪控制,SQL存储.zip源码Labview个人项目资料程序资源下载经颅磁治疗仪控制,SQL存储.zip源码Labview个人项目资料程序资源下载 1.合个人学习技术做项目参考合个人学习技术做项目参考 2.适合学生做毕业设计项目参考适合学生做毕业设计项目参考 3.适合小团队开发项目模型参考适合小团队开发项目模型参考
资源推荐
资源详情
资源评论
收起资源包目录
经颅磁治疗仪控制,SQL存储.zip (81个子文件)
经颅磁治疗仪控制,SQL存储
经颅磁20170516
经颅磁治疗仪V1.0.aliases 32B
main.vi 195KB
Key
用户输入.ctl 4KB
退出.ctl 64KB
震动.ctl 4KB
flash.ctl 4.27MB
倒计时.ctl 4KB
变频.ctl 4KB
定频.ctl 4KB
Buffer.lvlib 2KB
登录.ctl 59KB
暂停.ctl 4KB
输出.ctl 4KB
档位.ctl 4KB
定时.ctl 4KB
停止.ctl 4KB
SubVIs
PatManage.vi 311KB
adduser.vi 82KB
Jump.vi 814KB
login.vi 157KB
Library
reference.lvlib 3KB
Variable.lvlib 20KB
Boolean.lvlib 2KB
数据源设定.png 20KB
LabSQL
ADO210.CHM 752KB
Examples
Example- One Record at a Time.vi 44KB
Example - Insert into a Table.vi 32KB
SampleDatabase.mdb 124KB
Example - Fetch a Table.vi 31KB
LabSQL ADO functions
SQL Fetch Data.vi 73KB
SQL Fetch Data (GetString).vi 19KB
Recordset
ADO Fields Item.vi 27KB
ADO Recordset Destroy.vi 12KB
ADO Recordset RecordCount.vi 25KB
ADO Recordset EOF.vi 26KB
ADO Recordset MoveNext.vi 24KB
ADO Recordset Move.vi 26KB
ADO Fields Get Count.vi 25KB
ADO Recordset Get Fields.vi 25KB
ADO Recordset GetString.vi 17KB
ADO Recordset BOF.vi 25KB
ADO Recordset Close.vi 24KB
dir.mnu 3KB
ADO Recordset MoveFirst.vi 24KB
ADO Item Value.vi 27KB
ADO Recordset Create.vi 23KB
ADO Recordset Open.vi 34KB
ADO Recordset Cache Size.vi 25KB
ADO Recordset MoveLast.vi 24KB
SQL Execute.vi 20KB
Command
ADO Command Execute.vi 27KB
ADO Command Set Stored Procedure Text.vi 31KB
ADO Command Get Integer Parameter Value.vi 32KB
ADO Command Set String Parameter Value.vi 29KB
ADO Command Create.vi 23KB
dir.mnu 3KB
ADO Command Destroy.vi 20KB
ADO Command Set Paramter Value.vi 29KB
ADO Command Set Active Connection.vi 25KB
ADO Command Set Command Text.vi 30KB
ADO Command Get Parameters.vi 25KB
Connection
ADO Connection Destroy.vi 21KB
ADO Connection Rollback Transaction.vi 23KB
ADO Connection Close.vi 13KB
ADO Connection Set Mode.vi 25KB
ADO Connection Open.vi 14KB
ADO Connection Set Timeout.vi 25KB
ADO Connection Create.vi 12KB
dir.mnu 3KB
ADO Connection Commit Transaction.vi 23KB
ADO Connection Begin Transaction.vi 25KB
ADO Connection Execute.vi 14KB
README_FIRST.txt 4KB
经颅磁.lvlps 449B
经颅磁.aliases 40B
经颅磁.lvproj 17KB
Data
LogInfor.txt 67B
MyDB.accdb 508KB
~$Test.doc 162B
Test.doc 0B
HosInfor.txt 42B
共 81 条
- 1
资源评论
yxkfw
- 粉丝: 81
- 资源: 2万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功