ADO without SQL Tollkit

[wolf4124]

Hello

i need the way for read and write a value into a Access database.

I have the activex ADO 2.8 but i didn't know the way from oben to close.

I created a new object with "New_Connection (NULL, 1, LOCALE_NEUTRAL, 0, &objHandle_SQL);".

Then i open this with "ConnectionOpen (objHandle_SQL, NULL, "DSN=TEST_CVI;", "", "", -1);".

Then i do "ConnectionExecute (objHandle_SQL, NULL,

"Select * from Test", &RESULT, -1, &objHandle_SQL_RECORDSET);"

If after the last Commando the data into the Recordset?

I have a error then i will read the numbers of line in the recordset with

"RecordsetGetRecordCount (objHandle_SQL_RECORDSET, NULL, &LONGPTR);"

But he give me a error after the last one.

I think i have a generally Problem with my way.

Thanks for your answer.

[Carsten_Sprung]

Dear Wolf,

unfortunately we at NI don't have any experiences with this ActiveX interface you described. Maybe the documentation of the ActiveX interface can provide you the requested information.

Best regards,

Carsten Sprung
Applications Engineer
NI Germany