Exporting a Data Source Name in Windows
After you configure a DSN, you can export it to be used on other machines. When you export a DSN, all of its configuration settings are saved in a .sdc
file. You can then distribute the .sdc
file to other users so that they can import your DSN configuration and use it on their machines.
To export a Data Source Name
- Open the ODBC Data Source Administrator, select the DSN, click Configure, and then click Logging Options.
- Click Export Configuration, specify a name and location for the exported DSN, and then click Save.
Your DSN is saved as a
.sdc
file in the location that you specified.