AddNew ADO Help

[BadAzzS10]

Hi Ladies and Gentleman,

I've been playing around using Labview 2009 and ADO objects for a upcoming project I will be working on. I have a test database set up to where I want to add records to my test database, just to see how the flow works. I have successfully referenced the database and opened the recordset, but when I get to the AddNew Method, I'm stuck. I'm not sure what to wire to the FieldList or Values sections.

I've read the ADO 2.5 documentation, but I'm still lost.

Any info is greatly appreciated.

[Davidek]

Hi DadAzzS10

I don't know if this is the same definition you have in the ADO 2.5 documentation, but I find this pretty clear. Please post back if anything is still unclear.

Best Regards

David

NISW

[PhillipBrooks]

Whenever I have an ADO related issue, I start at devguru.com

See this link:

http://www.devguru.com/technologies/ado/quickref/ado_index.html

[BadAzzS10]

Phillip,

Thanks for the link, I'll have to save that site.

I'm thinking that a string array is the best way to go, since I have two columns with two values, but when I set up my 1D array for each array, I can't enter any information. It appers grayed out.

[BadAzzS10]

OK, got a little farther, but I still can't understand why I'm getting a error. It looks correct to me.

Error: -2146825023 - Item cannot be found in the collection corresponding to the requested name or ordinal.

[Dennis_Knutson]

If you do not want to use the NI Database Connectivity Toolkit (ADO based) I would suggest you look at the free LabSQL (also ADO based). It sounds like you might be trying to reinvent the wheel.

[Davidek]

Hi again

It's like Dennis says, using the toolkit would save you a lot of time and effort. It's the route I would recommend.

The error you are getting is documented in this KB.

Best Regards

David