How do I obtain a list of available connection types?

Hello,

How do I programmatically obtain a list of available connection types? I want to give my users the ability to add connections at runtime.

Thank you,
Brian Wheatley

Hello

This console application lists known connection types and known aux drivers where available.

Note the driver.Validated property - it allows to chech if assemblies needed for given driver are present on the server’s host

using System;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            RemObjects.DataAbstract.Server.Configuration.Load();


            foreach (RemObjects.DataAbstract.Server.DataProviderInfo driver in RemObjects.DataAbstract.Server.Configuration.DataProviders)
            {
                Console.WriteLine("{2}{0} - {1}", driver.Name, driver.Description, !driver.Validated ? "[N/A]" : "");

                if (!driver.DriverBased)
                    continue;

                foreach (RemObjects.DataAbstract.Server.ProfileMapping auxDriver in driver.DriverProfiles)
                {
                    Console.WriteLine("\t{0} - {1}", auxDriver.Name, auxDriver.ProfileName);
                }
            }

            Console.ReadLine();
        }
    }
}