How to connect to a Database in Visual Studio Using ODBC?
Article ID: KB0137813
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
| TIBCO Data Virtualization | All supported versions |
Description
ODBC (Open Database Connectivity) allows Visual Studio to interface with various database systems using defined Data Source Names (DSNs).
Prerequisites:
-
An existing ODBC System DSN configured on your machine
-
Valid database credentials
-
Visual Studio installed
Resolution
Follow the steps below to connect to the database via ODBC in Visual Studio:
-
Open Visual Studio
-
Navigate to:
Tools → Connect to Database -
In the Choose Data Source dialog:
-
Select Microsoft ODBC Data Source (.NET Framework)
-
Click Continue
-
-
In the Add Connection window:
-
Under Use user or system data source name, select the appropriate System DSN from the list
-
Enter the required username and password for your database connection
-
-
Click Test Connection to verify the setup.
Please check the below screenshot for reference:
Issue/Introduction
This article outlines the steps required to connect to a database in Microsoft Visual Studio using an existing ODBC data source. This is useful for testing connectivity, browsing schema, or integrating database operations into your application or development workflow.
