How to create the connection profile See manual W527 section 2-2-2 for more detail. Go to “DB Connection Settings” – Right Click – “Add” – “DB Connection Settings”. This will create a new connection setting with the “Connection Name” of “NJDB2”. Database Type: Pick the database type that you want to connect to. In this case DB2. Server Specification Method: IP address or Host name of the computer the SQL server is on. Instance Name/Port Number: An IT person will know this. You do not need to specify if it is the default. Service Name/Database Name: You must enter the database name here as specified by IT people.
You can omit the name if the user has been set by default to the correct Service/Database within SQL for Oracle and Microsoft SQL only. All the others you must enter the Database name. See the appendices for more detail. Page 7 of 21 Database Default Port Microsoft SQL 1433 Oracle 1521 IBM DB2 50,000 but cannot be omitted, must enter MySQL 3306 Firebird by Firebird Foundation 3050