How to get DB2 ServerClass and ServerVersion for your DB2 instance.
here is code snippet using DataAccessLibrary that ships with :
1. Microsoft Host Integration Server AND
2. Microsoft Biztalk Adapters for Host Systems AND
3. Microsoft's DB2OLEDB (SQL server feature pack for DB2 ) .
if you have any of these , following code will help getting your DB2 server's version and class ( MVS or AS400 or NT etc.)
//referencesspan style="mso-spacerun:yes"> required to be added in your project - Microsoft.HostIntegration.DataAccessLibrary.dll
using System;
using Microsoft.HostIntegration.DataAccessLibrary;
using System.Diagnostics;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
string serverClass = String.Empty;
string serverVersion = String.Empty;
try
{
DataAccessControl control = new DataAccessControl();
//DB2.UDL is the connection to DB2 server( Created with DAT- Data Access Tool)
IConnectionString cnstr = DB2OleDbConnectionString.ReadUDL(@"DB2.UDL");
DataAccessControl.TestConnection(cnstr, out serverClass, out serverVersion);
Console.WriteLine("serverClass" + serverClass);
Console.WriteLine("serverVersion" + serverVersion);
}
catch(Microsoft.HostIntegration.DataAccessLibrary.ConnectionException e)
{
Console.WriteLine("failed to connect " + e.ToString());
}
}
}
}
