LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Labview 2013 are closing when I try read table from database.

Solved!
Go to solution

Labview 2013 are closing when I try read table from database.
I don't get error message, Labview just crashes. I'm use Labview x32 and Database Connectivity Toolkit connective on Windows 7 x64. I connect to PostgreSQL with ODBC driver, connection is stable.
In my database I have many tables, I can read all them without one.
When I try read bad table I get data and then labview crash. When I restart Labview I don't have any message about error.
Also I try use LabSQL-1.1a. But it has same result.

Download All
0 Kudos
Message 1 of 7
(2,702 Views)

When LabVIEW crashes it generates a Error Log File, can you post this file to see what's going on?

This article shows where to find the error log file.

 

Chris S.
0 Kudos
Message 2 of 7
(2,671 Views)

Try connecting using UDL file. What operation you are doing with database

 

You can create the same.. Do this Tools --> Create Data link..

 

Then go to http://www.ni.com/pdf/manuals/371525a.pdf link and see page 3-5. It will help

--------------------------------------------------------------------------------------------------------
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 3 of 7
(2,665 Views)

I didn't have error message or crash message. Labview just closed and when I start Labview again I don't have any message about saving an error log the previous time. It's like I simple close Labview and start again.

 

0 Kudos
Message 4 of 7
(2,657 Views)

Close only application or complete LV closes?

 

Try using udl file as suggested

--------------------------------------------------------------------------------------------------------
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 5 of 7
(2,654 Views)

Complete LV closes

0 Kudos
Message 6 of 7
(2,650 Views)
Solution
Accepted by topic author slavadubrov

I found the solution.

I think problem was that I have very big array in my database.

Early I got data from table with next quiry:

SELECT column1, column2  FROM "table";

 

But when I write next:

SELECT column1, array_to_string(column2,',') FROM "table";

all worked! 

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