I can connect to our local Oracle database, read data from and existing table, but when I try to create a table and insert data, no success 😞 Please see the attachments for full error code and a picture of the block diagram.

Yes that is the error I was referring to in the post above. It says that not all providers support default database and it apears that Oracle is one that does not. Here is the connection info cluster for my system with the database name blurred out. Yours is showing that provider and default database are blank. If you are feeling adventurous you can modify the Get Properties VI as follows. The Insert Data VI still works on my system like this but I am not sure what it will break. Delete the wires from DefaultDatabase and Provider and remove those elements from the property node by resizing it. Then wire ConnectionString to the bottom two terminals of the bundle. This is not the right way to fix it though and is only a troubleshooting step! You should not save the VI with those modifications. I know this toolkit has to work with Oracle!

LabVIEW

DB Connectivity Toolkit Insert Data: Error -2147352567

Solved!

I will try the latest post you made to this chain. But my work has prioritized other tasks it may be a week before I am able to post the results.

The package you have uploaded appear to fulfill the needs I have. So thanks in advance.

Message 31 of 31

(838 Views)

LabVIEW

DB Connectivity Toolkit Insert Data: Error -2147352567

Re: DB Connectivity Toolkit Insert Data&colon; Error -2147352567