| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
|---|---|---|---|---|---|---|---|---|---|
Add a Data Source (ODBC) |
Learn how SQL Server ODBC driver calls stored procedures as remote stored procedures in SQL Server using the remote stored procedure call mechanism. |
markingmyname |
maghan |
04/15/2024 |
sql |
native-client |
reference |
|
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
Before using ODBC applications with [!INCLUDEssVersion2005] or later, you must know how to upgrade the version of the catalog stored procedures on earlier versions of [!INCLUDEssNoVersion] and add, delete, and test data sources.
You can add a data source by using ODBC Administrator, programmatically (by using SQLConfigDataSource), or by creating a file.
-
From the Control Panel, access Administrative Tools and then either ODBC Data Sources (64-bit) or ODBC Data Sources (32-bit). Alternatively, you can invoke odbcad32.exe.
-
Click the User DSN, System DSN, or File DSN tab, and then click Add.
-
Click SQL Server, and then click Finish.
-
Complete the steps in the Create a New Data Source to SQL Server Wizard. For more information, see ODBC Data Source Administrator DSN.
- Call SQLConfigDataSource with the second parameter set to either ODBC_ADD_DSN or ODBC_ADD_SYS_DSN.
- Call SQLDriverConnect with a SAVEFILE=file_name parameter in the connect string. If the connect is successful, the ODBC driver creates a file data source with the connection parameters in the location pointed to by the SAVEFILE parameter.