connect error using SQL connect

[dave2]

Hi, I am unable to connect to the data source name I have created. Each time I get a -4 error connection error with a hex code of xFFFC. Any help with this or an explanation on how to add values to a Access database using SQL would be appreciated.

[chrisger]

hi there,

please post some code.

in the meantime: visit http://jeffreytravis.com/lost/labsql.html

there you can download a well working ADO - interface for ODBC datasources which allows you to execute SQL - statements (examples are provided). the interface is written in LabVIEW using the MS-ADO ActiveX automation.

best regards
chris

[dave2]

Thanks a lot the website you put helped me out.