I do not know if you have solved your problem as posted in this question but I can offer some input I think.
I had the best luck using ADO and SQL to access my databases. Mine were all on the same pc as the LV program so I do not know what networking issues you might run into.
Second make sure you go into the ODBC Datasources on your control panel to configure the appropriate ODBC data source and give it a DSN name. There is not much info on the many aspects of this screen but the help function should get you through.
Third thing to do is make sure you have MDAC2.5 or later installed. I am unsure why this rev is so important but it helped me. You can get it from the MS website.
Hope this input helps.