Yes and yes. <P>I've written many VB apps (to display and/or manipulate data) that connect to a SQL Server via ODBC. It's actually pretty simple once you figure it out.

How to Connect to SQL From VB6. If your business does any programming in Windows, then a basic knowledge of VB6 programming concepts is essential. Windows provides a set of objects and functions ...