ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Labview connect with Microsoft SQL 2019

How to solve that Labview takes time While make connection with Microsoft SQL server 2019 ?

0 Kudos
Message 1 of 8
(2,583 Views)
  • How to solve that Labview takes time While make connection with Microsoft SQL server 2019 ?
0 Kudos
Message 2 of 8
(2,580 Views)

Not exactly sure what your problem is, but to connect to SQL database with Labview you need Database Connectivity Toolkit.

0 Kudos
Message 3 of 8
(2,496 Views)

and the Open Connection VI of that toolkit has a default time-out setting of 15 seconds.

If that is not enough you probably never get connected 🤣

 

Kees

0 Kudos
Message 4 of 8
(2,474 Views)

I am using Labview 2019 version  to make connection with Microsoft SQL2019.i have make connection through ODBC.Labview 2019 takes time to make connection with Microsoft SQL 2019.how can i solve that  delay issue ?

0 Kudos
Message 5 of 8
(2,410 Views)

@duraik756 wrote:

I am using Labview 2019 version  to make connection with Microsoft SQL2019.i have make connection through ODBC.Labview 2019 takes time to make connection with Microsoft SQL 2019.how can i solve that  delay issue ?


How long is the delay? 

______________________________________________________________
Have a pleasant day and be sure to learn Python for success and prosperity.
0 Kudos
Message 6 of 8
(2,397 Views)

it takes 7-10 secs

0 Kudos
Message 7 of 8
(2,356 Views)

@duraik756 wrote:

it takes 7-10 secs


If I were you, the next thing I would do is look at Wireshark to see who is taking that much time, but that is me. Are you using the database connectivity kit or some other ODBC library? 

______________________________________________________________
Have a pleasant day and be sure to learn Python for success and prosperity.
0 Kudos
Message 8 of 8
(2,339 Views)