About Defining New Odbc Data Source. Then define a data source for each database. In the Create New Data Source dialog box select an Excel driver and then click Next.
Once the Data Source window has been opened the Add button can be clicked to add a new data source. An application written using ODBC can be ported to other platforms both on the client and server side with few changes to the data access code. Open the Server Explorer.
To connect with an ODBC driver start by selecting theNET Framework Data Provider for ODBC as the data source on the Choose a Data Source or Choose a Destination page of the wizard.
In computing Open Database Connectivity is a standard application programming interface for accessing database management systems. From the AQT Signon window click on ODBC Manager. Expand that folder and you can then open either ODBC Data Source 32-bit or ODBC Data Source 64-bit. The designers of ODBC aimed to make it independent of database systems and operating systems.