10-23-2017 04:18 AM
hi everyone,
i have a Data Base created with Microsoft SQL Server, i want to create a connection with labview. The Data base have an .mdf extension , can u guys help me with an example to connect and to read & write data using labview
thnks
Solved! Go to Solution.
10-23-2017 07:26 AM
Everything you want to know about connection string (and a lot you don't want to know) can be found here:
https://www.connectionstrings.com/sql-server/
As for an example, what toolkit are you using?
10-23-2017 08:50 AM
Hi,
Follow the below two steps to read / write between MSSQL Server and LabVIEW.
1. Create ODBC connection.
2. Use LabVIEW Database Connectivity Toolkit to Read / Write (Refer Example code).
10-23-2017 10:43 AM
thnks for the answers, i tried to create an UDL, Select "Tools" and "Create Data Link", but when i select the provider which is SQL Server Native Client 10.0 and after that i click "refresh" i don't find the server. Any explanation for that??
PS : the statut of my server is "connected" Microsoft SQL Management Studio
10-23-2017 12:02 PM
Type it manually. That happens to me also. Just type the name of the server, as it appears when you open SQL Management Studio. Then
proceed filling up the rest of the fields. If the server is read correctly, tables should appear on the field.
10-24-2017 02:21 AM
hi JLuna,
i tried to type it manually but nothing changed 😞 , the DATABASE didn't appear on the field . what should I do???
10-24-2017 02:28 AM - edited 10-24-2017 02:28 AM
He mend (I think) to open an example, and manually edit the connection string in the VI.
10-24-2017 02:45 AM
hi wiebe@CARYA
no i don't think so, he mend to type the server manually in the fields of getting the UDL file in the tools
10-24-2017 03:37 AM
Well, since that's not working, you might try the other way.
10-24-2017 03:44 AM
i don't unterstand , the server is connected in sql management studio but it doesn't appear in labview when i want to create the UDL link, i tried to type it manually but nothing changed . i'm blocked :'(