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
(1,547 Views)
  • How to solve that Labview takes time While make connection with Microsoft SQL server 2019 ?
0 Kudos
Message 2 of 8
(1,544 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
(1,460 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
(1,438 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
(1,374 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
(1,361 Views)

it takes 7-10 secs

0 Kudos
Message 7 of 8
(1,320 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
(1,303 Views)