For a DB2 ADO.NET data provider, you must provide values for the following connection settings:
- Database
- The name of the database to access.
- Server
- The name of the database server. If the server is remote, you might also need to specify the TCP port number used by DB2, typically 50000. For example,
servername:50000.
- User ID and Password
- You can specify these as connection settings or code them into your program using the EXEC SQL CONNECT statement.