Using VB 6 app access database on a Sq1 server 7 from Workstations

[giyer555]

Having developed an application in VB 6 using MS sql server 7.00 as backend how do i access the database from different workstations.
The application folder & database is on a server & i am using odbc to connect to the database.

I need to share the application & allow users on a network to access the database from the server..

If possible please give a detail explanation.

I connect to the database in the following way using ODBC dsn

set myconn = new adodb.connection
myconn.open ("dsn=xyz;uid=sa;pwd=&quot
set rs = new adodb.recordset
rs.open "select .... from abc",myconn,adoOpenkeyset

All the workstation on a domain & i have not yet tried to install my application on the workstations.

Should i install sql server in all workstations.
if i install MS sql in all workstations whether the main server will be available when i create a dsn through odbc
The main server name where the database exist is xyz & i have created a dsn named abc on the server & the vb appl uses this dsn name to access the db.

My doubt is whether the MS sql server name installed on main server will be available on the workstations.

Please help