Academic Company Events NI Developer Zone Support Solutions Products & Services Contact NI MyNI
This Document is not yet Rated  Rate this Document

Compatibility between the SQL Toolkit for G and the Database Connectivity Toolkit

Primary Software: LabVIEW Toolkits>>Database Connectivity Toolset
Primary Software Version: 1.0
Primary Software Fixed Version: N/A
Secondary Software: N/A

Problem: Which VIs are compatible between the SQL Toolkit for G and the LabVIEW Database Connectivity Toolkit?

Solution:

The LabVIEW Database Connectivity Toolkit uses Microsoft ADO (ActiveX Data Objects) technology for Universal Data Access. ADO is a thin ActiveX wrapper to OLE DB, an updated version of the ODBC standard. Because ADO is an ActiveX interface, you can automate it from LabVIEW using the Invoke and Property Nodes. Therefore, you can use the Database Connectivity Toolkit to communicate between LabVIEW and any database that has an OLE DB or ODBC driver.

A library of compatibility VIs is included with the Database Connectivity Toolkit so users of the SQL Toolkit for G can convert their applications to the ADO technology. These compatibility VIs install into the labview\vi.lib\addons\_SQL directory in the same directory and VI library structure used by the SQL Toolkit. VIs with the same names and connectors are included for most of the SQL Toolkit. However, ADO does not provide all the functionality of the SQL Toolkit.

The following VIs were unable to be reproduced in the compatibility VIs using ADO:

  • Get Column Information
  • Get Database Information
  • Get DSN Information
  • Get Procedure Col Information
  • Get References
  • Get Table Information
  • Get Type Information
  • Get Column Alias
  • Get Column Attributes
  • Get Column Expression
  • Get Column Width
  • Request Column Information
  • Request Database Information
  • Request DSN Information
  • Request Procedure Col Information
  • Request Table Information
  • Request Type Information
  • Clear SQL Parameter
  • Close Fetch Log File
  • Get Statement Options
  • Set Statement Options
  • Get Supported Isolation Levels

Although these VIs do not exist as SQL compatibility VIs, some of the Database Connectivity Toolkit VIs can perform similar operations.



Related Links:

Attachments:





Report Date: 05/29/2008
Last Updated: 08/21/2008
Document ID: 4LSECVDR

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
  1 2 3 4 5
Please Contact NI for all product and support inquiries.submit