Had anyone successed in using ADO to connect to SQL Server2000？

[YING WEI]

I have looked through the Building ActiveX Servers
in LabWindows/CVI.pdf.And the ActiveX Controller also have been created.But I have no experience on ADO programming.If you have such experience,I wonder if you can give me some examples on ADO programming.Simplely I need the process such as connect、select、update，and so on.I just want to know how to Implement the database handle.Appreciate your help.Thanks!

[Aaron B.]

Hello,

A very useful document to help you get started would be the LabWindows/CVI SQL Toolkit Reference Manual. It explains many of the common database procedures and shows sample code to help with syntax. You should find answers to all of your questions in this document. It can be found at our website, www.ni.com/support. In option 3, click on "Product Manuals". Then select "LabWindows/CVI" in the Product Line field and "database" in the Additional Keywords field. I will also add a link to the manual here:

http://www.ni.com/pdf/manuals/370502a.pdf

I hope that you find this document helpful. Take care and have a great day!

Aaron B.
National Instruments