Archive for the 'ODBC Data Source Administrator' Category

How do I set up an ODBC connection?

In the database program you are using, follow the steps for importing data. Database programs vary widely, so refer to the Help documentation for each program to find detailed instructions about importing data.

How do I add a data source and driver to my computer?

1.      Open ODBC data source administrator by clicking the Start button Picture of the Start button, clicking Control Panel, clicking Additional Options, and then clicking Data Sources (ODBC).‌
2.     Click Add, choose the appropriate driver for the data source you’re adding, and then click Finish.
3.     In the Data Source Name box, type a name [...]

Configuring an ODBC Data Source

How do I set up the data source?
The configuration tool is available from the Windows Control Panel, but the method varies depending on the version of Windows.

For example, in Windows 2000 and XP, the ODBC data source administration is available through the Administrative [...]

DSN (Data Source Name)

The DSN is a way of referring to a particular driver and database by any name you wish. The DSN is usually a key to a list of attributes the ODBC driver needs to connect to the database (e.g. ip address and port) but there is always a key which names the driver so the [...]