下载中心

NI LabVIEW 8.6 Database Connectivity Toolkit Win32Eng LV8.6数据库连接工具包DCT1.0.2 

LabVIEW Database Connectivity工具包
LabVIEW Database Connectivity工具包可以帮助您连接到本地和远程数据库，并执行常见的数据库操作。
LabVIEW Database Connectivity工具包是LabVIEW的一款附加软件，可帮助您执行许多数据库操作，而且无需使用结构化查询语言(SQL)编程。该工具包可方便连接各种常用数据库，如Microsoft Access、SQL Server和Oracle。如果需要高级数据库功能和灵活性，LabVIEW Database Connectivity工具包还提供了完整的SQL功能。

DCT数据库工具包，自32位LabVIEW2014专业版/64位LabVIEW2016专业版开始，在安装包中已经集成，可以在安装时直接选择安装数据库连接工具包，不需要再单独下载安装。其他完整版、学生版或部分套件则未集成。又或者是早期LabVIEW版本没有包含数据库工具包，则可以下载独立版本的DCT。DCT自2019版开始，提供64位版本，之前仅32位版本。DCT自2024Q1版本开始，不再提供独立安装包，直接包含在LabVIEW安装包中。也可以使用第三方的免费的LabSQL工具包。

Windows系统下（Linux和MAC系统下请自行了解清楚）NI的各种软件、模块、工具包、驱动程序，使用NI许可证管理器来激活的，绝大部分的都可以使用NI Lincense Activator来激活：NI序列号Serial Number生成激活工具NI License Activator，LabVIEW/VBAI/VDM/VAS等软件模块工具包破解工具不限版本http://visionbbs.com/thread-490-1-1.html

视觉论坛的各种NI资源，除了视觉相关的模块有使用外，大部分的都不会使用，仅提供资源不提供技术支持。资源的下载地址一般会同时提供NI官方和百度网盘的地址。某些工具包NI地址失效或没有NI地址，只能使用百度网盘地址；如果百度网盘地址失效过期，可联系论坛客服更新。NI的服务器在美国，有时候速度很慢或下载容易出错，这样会造成安装时各种错误而无法安装。建议在下载完成后，对下载资源做校验和(NI一般会提供MD5或SHA256等)验证，与官方或视觉论坛提供的校验和对比，一致就可以安装；如不一致，则需要重新下载。视觉论坛早期下载上传的资源，基本上都是正常下载的资源；2019后下载的资源，都与NI的正确校验和对比过，保证是正确的资源才上传到百度网盘。校验和工具下载地址：文件Hash计算器FHash，文件校验和验证下载文件正确性验证，MD5值计算、SHA1值计算、SHA256值计算、CRC32值计算http://visionbbs.com/thread-26524-1-1.html

LabVIEW 8.6 Database Connectivity Toolkit 1.0.2
发布日期：2008/6/16
包含的版本：For LabVIEW 8.6，版本号1.0.2
受支持的操作系统：
Windows 2000
Windows Vista
Windows XP
语言：English
校验和：
文件大小: 30457709 字节 (29.05 MB)
修改日期: 2016-05-06 17:34
MD5: 930eb141f0e1cdf2c3d008a04a43f913
SHA1: cc784cbebeae1262c4e11e28bf4a8d35cdf230e7
SHA256: 92929ffe642d82805a30e849c2d5c657ee09e0fff78cc99348e63adfbb2815df
SHA512: 7bd918c51feadeb916fa832e817d7c094c7bbcd93c118231400a553c23863f15da0c98e66cf2344618fcdd7a458853309b59879025b4c5f063eba19b594f0bcc

百度网盘下载链接：
请注册视觉论坛会员登录后购买附件下载查看

NI LabVIEW 8.6 Database Connectivity Toolkit Win32Eng LV8.6数据库连接工具包DCT1.0.2

http://visionbbs.com/thread-22412-1-1.html

(出处: 石鑫华视觉论坛)

LabVIEW Database Connectivity Toolkit 1.0.2 Readme

June 2008

This file contains important last-minute information about the LabVIEW Database Connectivity Toolkit 1.0.2, including installation issues.

Refer to the National Instruments Web site for the latest information about the Database Connectivity Toolkit. Refer to the LabVIEW Database Connectivity Toolkit User Manual and the LabVIEW Help for more information about using the Database Connectivity Toolkit.

System Requirements

Installation Instructions

Recommended Database Client Software

Accessing the Help

Finding Examples

Known Issues

System Requirements

The computer you are using must meet the following minimum system requirements to run the Database Connectivity Toolkit:

• Windows Vista/XP/2000

• A minimum of 40 MB free disk space

• LabVIEW 8.6
  

Installation Instructions

Before installing the Database Connectivity Toolkit, uninstall any previous versions of the SQL Toolkit for G that you have installed. The Database Connectivity Toolkit and the SQL Toolkit for G use different methods of communicating with databases. Sharing VIs between toolkits can result in errors.

You can install all of your LabVIEW products—including LabVIEW and the Database Connectivity Toolkit—using the LabVIEW 8.6 Platform DVDs. Refer to the LabVIEW DVD Installation Instructions or the LabVIEW Release Notes, which are available in your LabVIEW box, for information about the LabVIEW Platform DVDs.

Complete the following steps to install the Database Connectivity Toolkit 1.0.2 from the LabVIEW Database Connectivity Toolkit installation CD.

Note  Some virus detection programs interfere with the installer. Disable any automatic virus detection programs before you install. After installation, check your computer for viruses and enable any virus detection programs you disabled.

• Log on as an administrator or as a user with administrator privileges.

• Insert the LabVIEW Database Connectivity Toolkit 1.0.2 installation CD and follow the instructions that appear on the screen.

• Activate your LabVIEW products using the NI License Manager.
  

Note  Due to differences between the ActiveX interface of different versions of the Microsoft ADO driver, National Instruments recommends that you mass compile the Database Connectivity VIs after installation to improve performance.

Version 1.0.1 for LabVIEW 6.x, 7.x, or 8.x

You must install the LabVIEW Database Connectivity Toolkit 1.0.1 to work with LabVIEW versions 6.0 through 8.5.

Caution  Do not install the Database Connectivity Toolkit 1.0.1 under LabVIEW 8.6.

Complete the following steps to install the Database Connectivity Toolkit 1.0.1.

Note  Some virus detection programs interfere with the installer. Disable any automatic virus detection programs before you install. After installation, check your computer for viruses and enable any virus detection programs you disabled.

• Log on as an administrator or as a user with administrator privileges.

• Insert the LabVIEW Database Connectivity Toolkit 1.0.2 installation CD and browse to the LabVIEW_6.0-8.5 directory.

• Double-click setup.exe and follow the instructions that appear on the screen.
  

Recommended Database Client Software

The Database Connectivity Toolkit works with any database or data source that has ODBC or OLE DB drivers. The following list describes issues and recommendations for which database client software to use. Refer to the Known Issues section of this readme for database-specific issues.

• Microsoft Access— National Instruments recommends that you use the Microsoft Jet 4.0 or later OLE DB Provider.

• Microsoft SQL Server—National Instruments recommends that you use the Microsoft OLE DB Provider for SQL Server.

• Oracle 7 and 8—You must install Oracle Client software on the machine to which you install the Database Connectivity Toolkit. National Instruments recommends that you use the Oracle Provider for OLE DB 8.1.6.2.0 or later. You can download the Oracle Provider from the Oracle Web site at www.oracle.com.
  

Accessing the Help

The LabVIEW Database Connectivity Toolkit User Manual contains conceptual information about using the Database Connectivity Toolkit. Open this manual by selecting Start» Programs»National Instruments»LabVIEW 8.6»LabVIEW Manuals and opening DCT_User_Manual.pdf or by navigating to the labviewmanuals directory and opening DCT_User_Manual.pdf.

The LabVIEW Database Connectivity Toolkit VI and Function Help contains reference information about Database VIs and functions. Complete the following steps to access the LabVIEW Database Connectivity Toolkit VI and Function Help.

• Launch LabVIEW.

• Select Help»Search the LabVIEW Help from the pull-down menu to launch the LabVIEW Help.

• Click the Contents tab.

• Navigate to Toolkits»Database VIs and Function.
  

Finding Examples

LabVIEW examples for the Database Connectivity Toolkit are located in the labviewexamplesdatabase folder. You can modify an example VI to fit an application, or you can copy and paste from one or more examples into a VI that you create.

You also can find example VIs using the NI Example Finder. Select Help»Find Examples to launch the NI Example Finder. You also can click the arrow on the Open button on the LabVIEW dialog box and select Examples from the shortcut menu to launch the NI Example Finder.

Use the Browse or Search page of the NI Example Finder to find an example VI. In the Browse page, the Database Connectivity Toolkit examples are located in the Toolkits and Modules»Database Connectivity folder.

Known Issues

The following sections describe known issues at the time of release. Refer to the Knowledge Base at ni.com for the most recent information about known issues.

• The Microsoft ODBC driver for Oracle and the Microsoft OLE DB Provider for Oracle do not support BLOB, or binary, data types. You cannot use Oracle with the Database Connectivity Toolkit for binary data with these drivers. Use the OLE DB Provider and ODBC driver that Oracle provides instead. You can download the Oracle DB Provider and ODBC driver from the Oracle Web site at www.oracle.com.

• When you read data from an Oracle database, data types of NUMBER do not show up in the variant indicator. This data is available but not visible. To see NUMBER data, use the Database Variant To Data function to convert the NUMBER to a string or to any numeric data type in LabVIEW.

• If the Microsoft Access ODBC driver and Jet Provider return the error Operation canceled, verify that the ODBC data source and/or data link connection string reference a valid .mdb file.

• The Microsoft Jet 4.0 OLE DB Provider and ODBC Driver might return the following error message when two executions attempt to gain write access to the same table.
  
  Native error code -2147467259 0x80004005
  Microsoft JET Database Engine:
  Could not update; currently locked by user 'Admin' on machine 'XXX'.
  
  This problem occurs if each execution or thread opens a unique connection to the database or opens unique statements to a table. In other words, this problem occurs if the executions or threads do not share handles. The Microsoft Access drivers use a lazy file access method that can cause this error. If this error occurs while you are accessing a Microsoft Access database from multiple processes or different computers, you must attempt to recover from this error and retry the failing database action.

• Inserting BLOB data into dBASE databases does not work if you use the OLE DB Provider for ODBC with an ODBC Data Source that points to a dBASE DSN. Refer to the Microsoft KnowledgeBase article Q264242 for a workaround.

• Asking for a dynamic cursor using the Microsoft Jet 4.0 OLE DB Provider gives a static cursor that is not quite correctly implemented. This bug has been reported to Microsoft.

• The Microsoft FindFast utility sometimes prevents writing to files. This problem results in an Access Denied error message. Disable FindFast by removing it from the startup group in the Program Files menu and reboot the computer.

• You might experience slow performance when reading the entire contents of a large database table into LabVIEW. National Instruments does not recommend that you work with very large recordsets because doing so is inefficient and uses a large amount of computer resources. However, the Database Connectivity Toolkit does provide the Read All Data example VI that demonstrates how to return a large amount of table data into a 2D array of strings in the most efficient method ADO provides.
  
  The Read All Data example VI uses few resources to return recordset data. However, this VI also has some limitations because the data format is a 2D array of strings. You must convert these strings into the LabVIEW data types that are most useful for displaying that data. Binary data such as arrays and clusters must be unflattened or type cast to their original format.
  
  The Read All Data example VI also is unable to read recordsets that contain a NULL value anywhere in the resulting recordset. LabVIEW returns no data and generates an error.

• The Database Connectivity Toolkit demo, available by selecting Start» Programs»National Instruments»LabVIEW Database Connectivity Toolkit»Database Connectivity Demo or by navigating to the labviewexamplesdatabaseTelecommunications Parametric Testing.llb, does not work with the LabVIEW Base Package because some of the testing VIs use advanced analysis functions available only in the LabVIEW Full and Professional Development Systems.
  

Copyright

© 2008 National Instruments Corporation. All rights reserved.

Under the copyright laws, this publication may not be reproduced or transmitted in any form, electronic or mechanical, including photocopying, recording, storing in an information retrieval system, or translating, in whole or in part, without the prior written consent of National Instruments Corporation.

Trademarks

National Instruments, NI, ni.com, and LabVIEW are trademarks of National Instruments Corporation. Refer to the Terms of Use section on ni.com/legal for more information about National Instruments trademarks.

Patents

For patents covering the National Instruments products, refer to the appropriate location: Help» Patents in your software, the patents.txt file on your CD, or ni.com/patents.