How Do I Configure Microsoft Sql Server Odbc Data Source

Start the Data Source Administrator. For 32-bit Windows systems: From the Windows start menu, select Settings > Control Panel > Administrative Tools > Data Sources. … On the System DSN tab, click Add. … Select MS SQL Server from the list of drivers, then click Finish.

How do I setup an ODBC connection in SQL Server?

1. Click Start and select Settings > Control Panel > Administrative Tools.
2. Double-click Data Sources (ODBC) to open the ODBC Data Source Administrator.
3. Select the System DSN tab.
4. Click Add.
5. Select SQL Server and click Finish.
6. Complete the DSN Configuration wizard (see example screen shots below)

How do I create an ODBC File DSN for SQL Server?

1. Create an empty database in SQL Server.
2. Choose Start > Control Panel > System and Security.
3. Click Administrative Tools.
4. Double-click Data Sources (ODBC). …
5. Click the System DSN tab and then click Add. …
6. Select the SQL Server driver and click Finish. …
7. Enter a unique Name.