Connecting to SQL Databases

• Mar 30, 2018

The WinForms Designer provides the capability to connect to multiple types of SQL databases using the Data Source wizard. You can establish a connection to a database using the two main approaches.

1. Connect to a database by selecting the required database type in the Data Source wizard. Then, specify the required connection parameters. To learn how to connect to the required type of the SQL database, refer to the following tutorials.

   • Microsoft SQL Server
   • Microsoft Access 97
   • Microsoft Access 2007
   • MS SQL Server CE
   • Oracle
   • Amazon Redshift
   • Google BigQuery
   • Teradata
   • Firebird
   • IBM DB2
   • MySQL
   • Pervasive PSQL
   • PostgreSQL
   • SAP Sybase Advantage
   • SAP Sybase ASE
   • SAP Sybase SQL Anywhere
   • SQLite
   • VistaDB
   • VistaDB 5
   • XML File
   • Custom Connection String

2. Register a required data connection in the application’s configuration file by adding a corresponding connection string to the connectionStrings section.

   XML

   <connectionStrings>
       <add name="nwindConnection" connectionString="XpoProvider=MSSqlServer; data source=localhost; initial catalog=Northwind; integrated security=SSPI;" />
     </connectionStrings>
   

   This connection will be displayed for end-users in the Data Source wizard when creating a new data source.

   

   To learn more, see Register Default Data Connections.