Description for Setting DSN (Data Source Name) in Windows
Description: A Data Source Name (DSN) in Windows is a configuration that allows applications to connect to a database using the ODBC (Open Database Connectivity) interface. It includes details like the database type, server location, and login credentials, enabling seamless communication between the application and the database. Setting up a DSN helps standardize database connections, eliminating the need to specify connection details repeatedly across different applications.
Screenshots
STEP 1: Open *Administrative Tools* and select *Data Sources (ODBC)*. You should be presented with the following dialog.
STEP 2: Select the *User DSN* tab or the *System DSN* tab, depending on whether you wish the SQL data to be made available to only the current user (*User DSN*) or all users (*System DSN*). Then click *Add...*. This will start a wizard that allows you to create a new data source.
STEP 3: Select *MySQL ODBC Driver* and click *Finish*. You will be prompted to enter details about the SQL access using the form below.
STEP 4: Here is what a successful configuration looks like.
STEP 5: Click *OK*. This will add the *Exinda SQL Database* to the list of available data sources that can be used by 3rd party applications on this client.
Research Breakthrough Possible @S-Logix
