From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

python or mssql in labview

Solved!
Go to solution

 

Can I write everything in LABVIEW instead of python or SQL?

for example. 

 

the python code 

 

conn = _mssql.connect(server='****',
database= 'mydatabase')

 

 

can that be translated to LABVIEW?

Best regards,
Krispiekream
0 Kudos
Message 1 of 3
(2,458 Views)

I'm not a python user, but it looks like you're opening a connection to a database there.  You can do that in LabVIEW using the Database Connectivity Toolkit or some ADO drivers that Mike Porter posted here: http://forums.ni.com/t5/LabVIEW/Extracting-one-column-from-Database/m-p/544341/highlight/true#M25632...

Message 2 of 3
(2,440 Views)
Solution
Accepted by topic author krispiekream

This is what it looks like with the Database Connectivity toolkit.

 

Example_VI_BD.png

 

I use connectionstrings.com to get the connection strings for various data sources.

Jim
You're entirely bonkers. But I'll tell you a secret. All the best people are. ~ Alice
For he does not know what will happen; So who can tell him when it will occur? Eccl. 8:7

Message 3 of 3
(2,415 Views)