How To Specify the User Name and Password To My Database Using the SQL Toolkit

Primary Software: LabVIEW Toolkits>>Enterprise Connectivity Toolset
Primary Software Version: 3.0
Primary Software Fixed Version: N/A
Secondary Software: N/A

Problem: How do I specify the user name and password to my database using the SQL Toolkit?

Solution: One of the input parameters of the "Connect.vi" is "connection parameters". You use this parameter to specify the user name and password to your database. You create a string control to that input and type the username and password information using the following format.


UID=admin;PWD=welcome

The word UID and PWD are part of the syntax that you have to use. Also, be sure to include the semicolon ";" as it is an essential part of the syntax.

National Instruments now offers a Database Connectivity Toolkit that provides high-level, easy-to-use functions for common database operations within LabVIEW without SQL programming. See related link below.

Related Links: LabVIEW Enterprise Connectivity Toolset (includes Database Connectivity Toolkit)

LabVIEW Support Homepage

Attachments:

Report Date: 09/15/2000
Last Updated: 11/30/2004
Document ID: 21E8RKOP

Your Feedback!

Poor | Excellent

Yes

Document Quality?

Answered Your Question?

Please Contact NI for all product and support inquiries.