i'm trying to create a new Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetConnectionSupport object however it needs a parameter called providerName for the constructor. I've tried using System.Data.SqlClient with no success all the members in the underlying object are null. If anyone has any idea what the providerName should be please tell me. I've googled but with no results except it listing all the members and basic information, no examples. thanx in advance