File DSN vs Machine DSN in ODBC

[rushdib]

Hi,
Currently we are using ODBC connections using Machine DSN to connect the SQL Server from Access.
Since I have to configure every user's pc, I tried the File DSN, created from my pc and copied the DSN file to all users' pcs in the folder c:/program files/common/odbc.
The users couldn't connect as there was an error saying not using a trusted connection. I reconfigured File DSN on a user's pc and it worked. I opened the File DSN on notepad, and it was still recording my name and my pc name. I deleted the File DSN in the user's pc and recopied the File DSN with a user name and a machine name. It was still working.
I am confused.
All I have to find a way is how can I distribute copies of File DSNs to all the users without having each user configure the ODBC link. Is there any way to do it?

Thanks in advance,

Rushdi

 

[SQLBill]

You can't to my knowledge. Why aren't you using SYSTEM DSNs? That's what I use. I create the connection once on each machine and everyone who can log into that machine can use the connection.

-SQLBill