To set up an ADO.NET connection, you need to select an ADO.NET provider from the database connection dialog box and enter a connection string (see also Setting up an ADO.NET Connection). Sample ADO.NET connection strings for various databases are listed below under the .NET provider where they apply.
.NET Data Provider for Teradata
This provider can be downloaded from Teradata website (https://downloads.teradata.com/download/connectivity/net-data-provider-for-teradata). A sample connection string looks as follows:
Data Source=ServerAddress;User Id=user;Password=password; |
.NET Framework Data Provider for IBM i
This provider is installed as part of IBM i Access Client Solutions - Windows Application Package. A sample connection string looks as follows:
DataSource=ServerAddress;UserID=user;Password=password;DataCompression=True; |
For more information, see the ".NET Provider Technical Reference" help file included in the installation package above.
.NET Framework Data Provider for MySQL
This provider can be downloaded from MySQL website (https://dev.mysql.com/downloads/connector/net/). A sample connection string looks as follows:
Server=127.0.0.1;Uid=root;Pwd=12345;Database=test; |
.NET Framework Data Provider for SQL Server
A sample connection string looks as follows:
Data Source=DBSQLSERV;Initial Catalog=ProductsDB;User ID=dbuser;Password=dbpass |
See also: https://msdn.microsoft.com/en-us/library/ms254500(v=vs.110).aspx
IBM DB2 Data Provider 10.1.2 for .NET Framework 4.0
Database=PRODUCTS;UID=user;Password=password;Server=localhost:50000; |
| Note: | This provider is typically installed with the IBM DB2 Data Server Client package. If the provider is missing from the list of ADO.NET providers after installing IBM DB2 Data Server Client package, refer to the following technical note: https://www-01.ibm.com/support/docview.wss?uid=swg21429586. |
Oracle Data Provider for .NET (ODP.NET)
The installation package which includes the ODP.NET provider can be downloaded from the Oracle website (see http://www.oracle.com/technetwork/topics/dotnet/downloads/index.html). A sample connection string looks as follows:
Data Source=DSORCL;User Id=user;Password=password; |
Where DSORCL is the name of the data source which points to an Oracle service name defined in the tnsnames.ora file, as described in Connecting to Oracle (ODBC).
To connect without configuring a service name in the tnsnames.ora file, use a string such as:
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=port)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=user;Password=password; |
See also: https://docs.oracle.com/cd/B28359_01/win.111/b28375/featConnecting.htm
