Hi! Amy,
Hope you have installed Microsoft ODBC for .NET. This is must to enable VS.NET to work with ODBC drivers.
The connection string can look like,
For Access:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"
For any DSN:
"DSN=myDsn;Uid=username;Pwd=;"
Hope, this will help you and this is what you want.
Bye!
Ritesh.
If you are courageous, listen to your heart. If you are coward, listen to your head.