how can i connect SQL(local server) to VB6??

Please give me the STEP BY STEP PROCEDURE..

i dont really have idea on how to connect SQl to Vb6

Create an ODBC DSN and test it to make sure it works.
Then use the Data Form Wizard with the ODBC option. You will find it under Add-Ins>Add-In Manager.
Run this wizard as many times as needed to create every combination of form type with code/class/control. Then save this project for future reference.

Then when you are ready to goto a DSN Less connection goto http://www.connectionstrings.com


Good Luck