How to distribute FDSN to other users or mahcines?

Vote count:

0

I am using a File DSN to connect to SQL server database in a linked tables project with MS Access as front end .

When i open the created the dsn file , it looks like below:

[ODBC]
DRIVER=SQL Server
UID=XXX
DATABASE=XXXX
WSID=XXXXXX
APP=Microsoft Office 2010
Trusted_Connection=Yes
SERVER=XXXX,XXX
Description=XXX

Here , it is showing my Work Station host name and my user id as i have created the DSN

If i want to share the app along with DSN , do i have to change any details in the DSN file ?

what is procedure to be followed to distribute this FDSN to multiple machines. ? or simply sharing the file would suffice

we prefered to avoid System DSN as it causes difficulty in deploying the app to multiple users in production

Any thoughts on this ?

asked 44 secs ago

Sai Avinash

2,394

How to distribute FDSN to other users or mahcines?