VB 6 Connection string to SQL server 2000

Hi Guys,

I am new to SQL server 2000. I want to know how to create the connection string to SQL server 2000 using Visual Basic 6.

I can create a connection string to local machine and its work, but the system i am going to develop is a multiuser system (That means clients have to access the server for the database).