LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

ODBC after close still open (using multiple connections)

Hello,

 

 

we face follwoing problem using database connectivity toolkit:

 

We're using two database connections via ODBC, one to a local ACCESS file, another to a SAPDB.

If both connections are opened and the second is closed, this connection keeps still open until the first connection also is closed.

This can be seen in the log file of the ODBC driver (Trace SQL commands).

 

Any idea?

 

Thanks, Thomas.

 

 

 

0 Kudos
Message 1 of 7
(2,767 Views)

Hello maximint

 

When you say close, are you referring to destroy/close the reference? Can you provide an screenshot of your code?

 

Regards

 

Mart G

0 Kudos
Message 2 of 7
(2,731 Views)

Hello,

 

attached the code. It's just a DB Tool Close Connection provided with the NI Connectivity Tool Kit.

 

Thanks, Thomas.

 

Clipboard-1.jpgClipboard-2.jpg

 

 

 

 

 

 

 

0 Kudos
Message 3 of 7
(2,719 Views)

Post your VI. It will be easy to debug (2011 format)

--------------------------------------------------------------------------------------------------------
Kudos are always welcome if you got solution to some extent.

I need my difficulties because they are necessary to enjoy my success.
--Ranjeet
0 Kudos
Message 4 of 7
(2,715 Views)

attached the code in LV 2011.

 

BR

Thomas.

 

 

0 Kudos
Message 5 of 7
(2,709 Views)

PLS provide the same in labview 2009

0 Kudos
Message 6 of 7
(2,642 Views)

Hi,

 

The attached code should work for 2009.

 

Regards,

 

Arham H
Applications Engineer
National Instruments
0 Kudos
Message 7 of 7
(2,627 Views)