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,582 Views)
  • How to solve that Labview takes time While make connection with Microsoft SQL server 2019 ?
0 Kudos
Message 2 of 8
(2,579 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,495 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,473 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,409 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,396 Views)

it takes 7-10 secs

0 Kudos
Message 7 of 8
(2,355 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,338 Views)