Accessing server

Hello all,
Can anyone here help me to solve the following problem?
I have developed an application with vb6.0 as front end and ms
sqlserver as back end.
I have already made .exe and now i want to use my application over the
network.
I tried making a shortcut on the client pc from the main pc or server but
iam getting an errror message.
How can I recity this problem?
How can i use my .exe in client machine where the client should acess
the database which is located on the server?
Pls help me.
Thanks in advance
Regards
Jack
Followup Questions:
What's the error message?
It appears that you have installed the VB6 executable and supporting DLL's
on the server, and then, using a UNC Pathname or a Mapped Drive Letter, you
created a Shortcut on the desktop of the client computer.
Is that how it is?
If the user executes the shortcut, then her system will attempt to load all
the components into memory on the local workstation. If there are SQL Server
components required, they will have to be installed locally.
Also, is the SQL Server set up for Domain/Windows Authentication or SQL
Server Authentication or Mixed Mode?
John
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:D47E3EA2-BAF0-4D74-BE44-887149735A59@.microsoft.com...
> Hello all,
> Can anyone here help me to solve the following problem?
> I have developed an application with vb6.0 as front end and ms
> sqlserver as back end.
> I have already made .exe and now i want to use my application over the
> network.
> I tried making a shortcut on the client pc from the main pc or server but
> iam getting an errror message.
> How can I recity this problem?
> How can i use my .exe in client machine where the client should acess
> the database which is located on the server?
> Pls help me.
> Thanks in advance
> Regards
> Jack
|||Thanks for the mail.
I think u didnt get what i need.
Its something like this.
My application uses vb6.0 as front end and sql server as backend.
Now i want to install my application on a network that means i want client
computers to access my databse on the server.
Its a simple application nothing complictaed.
Pls help me.
Regards
jack
"John Smith" wrote:

> Followup Questions:
> What's the error message?
> It appears that you have installed the VB6 executable and supporting DLL's
> on the server, and then, using a UNC Pathname or a Mapped Drive Letter, you
> created a Shortcut on the desktop of the client computer.
> Is that how it is?
> If the user executes the shortcut, then her system will attempt to load all
> the components into memory on the local workstation. If there are SQL Server
> components required, they will have to be installed locally.
> Also, is the SQL Server set up for Domain/Windows Authentication or SQL
> Server Authentication or Mixed Mode?
> John
> "Jack" <Jack@.discussions.microsoft.com> wrote in message
> news:D47E3EA2-BAF0-4D74-BE44-887149735A59@.microsoft.com...
>
>
|||Just change the Datasource of connection string to sql server name...
(i think u might using Localhost as datasource now)
recompile it.. copy it to the client computer...