Inserting Database Entries With Write Only Privilages

[Steve_Block]

I have the NI database tool kit and I'm trying to post data to a database where I have write-only privilages. The list tables vi appears to work, however, the list columns vi errors out. The DB tools insert data vi also errors out without posting data. A program written in .net is able to post data to this database, is there a way to do so using LabView?  Note: We only have 2009 so cannot read later examples.

[MarcoMauri]

Hi!

Can you post the VI sending the data to the DB (or only the relevant part of the vi)?

Marco

[Steve_Block]

DB tools insert data.vi is part of the database connectivity tool kit. The vi works for databases that I have read access to but not ones that I have write only access to. It is the internal get properties vi where the error flag is being set.

[MarcoMauri]

If I'm not mistaken "get properties" is executed only if "autodetect parameters" is enabled.

Is this your case?

Hope it helps,

Marco

[Steve_Block]

I don't see any reference to an autodetect anywhere?

[MarcoMauri]

To check if something is wrong you could also use the "database insert.vi" provided with Labview examples.

It lets you execute in no-time a SQL command without any request of parameters.

Marco

[Steve_Block]

I took a look at that example, but don't know how to corelate the "device name" and "parameters" fields to a table and column.

[Steve_Block]

The example also calls Create Parameterized Query which calls a get properties as the first action.

[MarcoMauri]

In the "Database Insert.vi" example if you select the tab "SQL Query" there will be no call of "Create Parameterized Query".

Regards,

Marco