Welcome to the show... Opps, old song rolling around in the head but still let me introduce you to your new best friends (yahoo, google, ask, answers, bing) and here is some hints on what you should be searching for...
vb6 ado turorial
Then, once you have that digested, see
http://www.connectionstrings.com for more information on DSN Less connections...
Good Luck