ODBC DRIVER

How to add a new ODBC driver to a system. I want to make a project in VB using SQL as database. I have made SQL Database and connected to VB using ODBC driver. Now I need to make a setup. If I make a setup file and if I install it in any other system without SQL server or connection to the network, will it work? How can I run this project in a network without SQL Server installed in the system? If I make file DSN connection, How will I install the same Driver in other PC outside the Domain?