Dear,

I've developed a small HR program that connects to the SQL database which is on the local PC. I've created an ODBC connection to connect to this server and the program works fine. I've used VB 2008 Express edition to develop.

My concern is now I want to install this EXE on a server. ON the server, I've created the same databses and successfully created an ODBC connection on the server as well. Also created one shared folder. I copied all my EXEs and DLLS on to this folder. On the server I was able to execute the program without any problem.

From a remote client, I opened this shared folder and try to execute and it was giving me an ODBC related error, basically it was not able to detect the SQL connection.

What could be the problem? Is it anything do with my program or do I need to setup my server or the shared folder.

What I want to achieve is to have one EXE. The program did not throw any other errors.

PLEASE HELP. THANKS IN ADVANCE