Deploying a remote vb.net application

Hi

I have an windows vb.net application on the back end using SQL server 2000, I want to deploy only 1 copy on the server and for the client envoirnment, I want all the clients to use this application just with the shortcut,

It doesnt allow you to get the data from the sql server unless its a local copy on the client's machine,

The reason why I m using it because I have a large number of clients will be using and in future there will be more, and As it is only 1 copy installed so support for this application its also easy.

I already tried hard coding the connection string, or put it in separate config file. but it doesnt work out for me.

Can Anyone help me out here

Cheers

Zohair