>-- As far as the DBC is concerned --
>Yes, you can store the on a file server. On the other hand, you'll get better performance if you install the DBC to each workstation.

I see that you can install the DBC in a place other than the SQL server machine. Thank you.

>The DSN should be defined in the terminal runnin the program.
>
>You may also consider declaring DSN-less connections on your DBC, that way, the DSN connection does not need to be defined on each workstation. You can define a DSN-less conection as follows:
>
>

>	OPEN DATA YourDBC
>	CREATE CONNECTION MyConnection ;
>	   CONNSTRING 'DRIVER=sql server;SERVER=(local);UID=sa;PWD=;DATABASE=northwind'
>	

Thank you very much.

Can a DNS-less connection be defined right in the project or does it need to be done at run time?

Your answer brings up new questions, some of which belong in a separate thread.

Alex