How do I access ODBC Drivers?
Click Start, and then click Control Panel. In the Control Panel, double-click Administrative Tools. In the Administrative Tools dialog box, double-click Data Sources (ODBC). The ODBC Data Source Administrator dialog box appears.
How do I find my ODBC driver name?
To check the ODBC SQL Server driver version (32-bit ODBC): In Administative Tools, double-click Data Sources (ODBC). Click the Drivers tab. Information for the Microsoft SQL Server entry is displayed in the Version column.
How do I find my ODBC password?
In the Data Link Properties dialog box, on the Provider tab, click Microsoft OLE DB Provider for ODBC Drivers, and then click Next. On the Connection tab, under Specify the source of the data, select a System DSN data source, type the user name and password, and then click to select the Allow saving password check box.
How do I set up an ODBC connection?
- Click Start and select Settings > Control Panel > Administrative Tools.
- Double-click Data Sources (ODBC) to open the ODBC Data Source Administrator.
- Select the System DSN tab.
- Click Add.
- Select SQL Server and click Finish.
- Complete the DSN Configuration wizard (see example screen shots below)