Is it possible for VB6 to establish a direct remote sql connection and make a query in the remote sql database? If possible what are the reference do I need to add to make it working?

Somebody please give a me a good example... from establishing a connection, query in database upto closing the connection... sorry for the trouble I may give to those who can answer my question. I'm just a newbie and I'm really not good in database programming...

Please help me!


Thanks in advance.