MS ACCESS OK -- SAME VI NO WORK FOR ORACLE?? USING LV8.6 AND DB TOOLKIT

[Yamaeda]

What is Get Task Information.vi used for? I usually use Execute query -> Fetch all(/attribute) -> Close Query

I also had the issue of not getting any attribute for the number of rows recieved, which i solved by by doing a Select count(*) query instead. Not optimal since it's an extra query, but general enough to work against both my access and sql server and through odbc. 🙂

/Y

[Hueter]

Yamaeda,

This post is specificly about fixxing Error -2147217887. If you have other questions about database functions start a new thread.

[BRIANA123]

I have moved on from this problem and am just using the Advanced Tools and SQL, INSERT CMD -- mostly to enter the Test DATA, which we parse out of the Test results. For what I need to do, this works fine. I am working the Oracle people @ our company to develop the specific Table info and Database design so the data can be easily accessed with their designed forms etc, and be applied to other product etc.