How do I access a database via ODBC from a console app?

2004-09-20 09:19:27 AM
Question: I've written a console app that needs to modify a record in a
table. Is there an easy way to:
Open up an ODBC connection (using a system DSN, username & password)
Send an SQL Query/Statement to locate record
Send an SQL Statement to update said record
Close the ODBC connection
If someone has sample code, that would really really help.
Thank you.
- Yves