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!
没有合适的资源?快使用搜索试试~ 我知道了~
《LabVIEW 8.20程序设计从入门到精通》实例8.20版本
共178个文件
vi:152个
ctl:3个
mnu:3个
需积分: 10 5 下载量 157 浏览量
2009-04-20
22:05:32
上传
评论
收藏 5.15MB RAR 举报
温馨提示
本压缩文件为《LabVIEW 8.20程序设计从入门到精通》基础篇部分的源代码,以方便以此书参考使用,方便实践练习。
资源推荐
资源详情
资源评论
收起资源包目录
《LabVIEW 8.20程序设计从入门到精通》实例8.20版本 (178个子文件)
条件使能结构.aliases 48B
ADO210.CHM 752KB
Picture Ctl.ctl 22KB
泵.ctl 12KB
汽车控制面板Type Def示例.ctl 8KB
Thumbs.db 7KB
Thumbs.db 6KB
Bump_green.GIF 933B
Bump_red.GIF 933B
sound.htm 619B
CT03239273431.jpg 70KB
CT13239273431.jpg 68KB
sound.lvm 459KB
条件使能结构.lvproj 1KB
MathScript_example.m 439B
MyDB.mdb 196KB
SampleDatabase.mdb 128KB
dir.mnu 3KB
dir.mnu 3KB
dir.mnu 3KB
发生源文件.rar 97KB
自定义菜单.rtm 492B
README_FIRST.txt 4KB
声音信号处理示例.vi 286KB
TDM File.vi 268KB
3D Graph.vi 253KB
MathScript_Node举例.vi 229KB
数学脚本节点_Fractal.vi 204KB
概率与统计举例.vi 189KB
TDM Streaming File.vi 148KB
Text Measurement File.vi 148KB
动态数据类型.vi 112KB
简单的滤波器.vi 108KB
XY Graph示例.vi 105KB
逐点分析_火车车轮检测.vi 78KB
SQL Fetch Data.vi 73KB
字符串_表格和树形控件.vi 54KB
数组_基本数组函数示例.vi 53KB
贝塞尔函数_薄膜振动模拟.vi 53KB
Generalized Fourier Spectrum.vi 52KB
对话框示例.vi 51KB
滤波器举例.vi 51KB
仿真信号采集.vi 50KB
一维插值.vi 49KB
Chart图表.vi 43KB
逐点分析_滤波举例.vi 43KB
Configuration File.vi 41KB
信号调理举例.vi 40KB
Waveform Graph 波形图.vi 39KB
Text File.vi 39KB
Picture控件示例.vi 36KB
动态创建菜单示例.vi 36KB
ADO Recordset Open.vi 34KB
ADO Command Get Integer Parameter Value.vi 32KB
ADO Command Set Stored Procedure Text.vi 31KB
SQL Execute.vi 30KB
ADO Command Set Command Text.vi 30KB
IVI示波器示例.vi 30KB
极坐标曲线示例.vi 30KB
自定义控件和自定义数据类型示例.vi 30KB
Picture控件_Waveform and XY Graph.vi 29KB
ADO Command Set String Parameter Value.vi 29KB
ADO Command Set Paramter Value.vi 29KB
Waveform and XY Plots.vi 29KB
SQL Fetch Data (GetString).vi 28KB
树形控件编程示例.vi 27KB
数值积分与数值微分.vi 27KB
ADO Item Value.vi 27KB
ADO Command Execute.vi 27KB
ADO Fields Item.vi 27KB
Waveforms File.vi 26KB
ADO Recordset GetString.vi 26KB
波形数据示例.vi 26KB
ADO Recordset Move.vi 26KB
频域分析_单边傅立叶变换.vi 26KB
信号发生举例.vi 26KB
曲线拟合_最小二乘法拟合.vi 26KB
波形测量举例.vi 26KB
Ring控件和Enum控件编程示例.vi 25KB
ADO Connection Set Mode.vi 25KB
ADO Recordset Get Fields.vi 25KB
ADO Command Set Active Connection.vi 25KB
实例_模拟温度采集监测系统.vi 25KB
ADO Connection Begin Transaction.vi 25KB
ADO Recordset Cache Size.vi 25KB
动态创建右键快捷菜单示例.vi 25KB
窗函数_谱泄漏举例.vi 25KB
ADO Command Get Parameters.vi 25KB
ADO Recordset RecordCount.vi 25KB
频域分析_双边傅立叶变换.vi 25KB
Chart自动图例示例.vi 25KB
ADO Recordset BOF.vi 25KB
ADO Connection Set Timeout.vi 25KB
带时间轴的实时曲线.vi 25KB
ADO Fields Get Count.vi 25KB
时域分析_自相关函数举例.vi 24KB
常微分方程举例.vi 24KB
窗函数_信号分辨举例.vi 24KB
ADO Recordset MoveFirst.vi 24KB
ADO Recordset MoveNext.vi 24KB
共 178 条
- 1
- 2
资源评论
xyzhch
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- foldcraftlauncher_262944.apk
- 珍藏多年的基于matlab实现潮流计算程序源代码集合,包含多个潮流计算程序.rar
- 使用FPGA实现串-并型乘法器
- 基于matlab实现针对基于双曲线定位的DV-Hop算法中误差误差出一种基于加权双曲线定位的DV-Hop改进算法.rar
- 基于matlab实现由遗传算法开发的整数规划,车辆调度问题.rar
- 电视家7.0(对电视配置要求高).apk
- 免费计算机毕业设计-基于JavaEE的医院病历管理系统设计与实现(包含论文+源码)
- 手机端 我的世界融合植物大战僵尸版.apk
- 植物大战僵尸 · 戴夫的老年生活 手机版.apk
- Runcraft · 我的世界跑酷游戏 手机端.apk
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功