Add ODBC connection to all users

Question

I have a Windows 2012 Server with a .NET application. The application need an ODBC connection to a database to run.

I have to setup to all users the ODBC connection, but i have around 100 diferent users.

Is there any way to create the connection to all users at the same time?

I have to configure this to all users profile, not in the application.

Edit:

After reading a bit, i have created a "system DSN" instead of a "user DSN" but the application can't connect to the DB. Only work if the ODBC is created in "user DSN". Is there any way to change it on the application?

Thanks.

Answer 1

If you want it to be available across users, you add the connection to System DSN and then it will be available regardless of the user logged into the local machine.