Skip to main content

Notifications

Announcements

No record found.

Microsoft Business Applications Summit Gallery ...
Unanswered

Microsoft ActiveX Data Objects 2.8 Library.Connection in BC on premise

Posted on by 350

Hi Everyone, 

I need to add 'Microsoft ActiveX Data Objects 2.8 Library'.Connection dotnet assembly in business central. I have added System assemblies but don't know the right path of ActiveX. ADO connection.

I can able to access the below dotnet assemblies. I have also added C:\Program Files\Common Files\system\ado in user settings Assembly probing path.

Please provide the structure of ActiveX assembly calling in AL code.

pastedimage1632047504774v1.png

dotnet
{
    Assembly(System.Data)
    {
        type(System.Data.SqlClient.SqlCommand; SqlCommand{ }
        type(System.Data.SqlClient.SqlConnection; SqlConnection{ }
        type(System.Data.SqlClient.SqlDataReader; SqlDataReader{ }
        type(System.Data.CommandType; CommandType{ }
        type(System.Data.DataTable; DataTable{ }
        type(System.Data.DataRow; DataRow{ }
        type(System.Data.DataSet; DatasetAsm{ }
        type(System.Data.DataTableCollection; DataTableCollection{ }
        type(System.Data.DataRowCollection; DataRowCollection{ }
        type(System.Data.DataRowVersion; DataRowVersion{ }

    }
    assembly(mscorlib)
    {
        type(System.Array; Arrayasm{ }
        type(System.IO.StringWriter; StringWriter{ }
        type(System.Convert; Convert{ }
        type(System.IO.MemoryStream; MemoryStream{ }
        type(System.IO.Directory; Directory{ }
    }

    assembly(System.Xml)
    {
        type(System.Xml.XmlAttribute; System_Xml_System_Xml_XmlAttribute{ } //"'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Xml.XmlAttribute"
        type(System.Xml.XmlDocument; System_Xml_System_Xml_XmlDocument{ } //"'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Xml.XmlDocument"
        type(System.Xml.XmlNamedNodeMap; System_Xml_System_Xml_XmlNamedNodeMap{ } //"'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Xml.XmlNamedNodeMap"
        type(System.Xml.XmlNode; System_Xml_System_Xml_XmlNode{ } //"'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Xml.XmlNode"
        type(System.Xml.XmlNodeChangedEventArgs; System_Xml_System_Xml_XmlNodeChangedEventArgs{ } //"'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Xml.XmlNodeChangedEventArgs"
        type(System.Xml.XmlNodeList; System_Xml_System_Xml_XmlNodeList{ } //"'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Xml.XmlNodeList"
        type(System.Xml.Xsl.XslCompiledTransform; System_Xml_System_Xml_Xsl_XslCompiledTransform{ } //"'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Xml.Xsl.XslCompiledTransform"
    }
    assembly(System)
    {
        type(System.Diagnostics.Process; System_System_Diagnostics_Process{ } //"'System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Diagnostics.Process"
        type(System.Collections.Specialized.NameValueCollection; System_System_Collections_Specialized_NameValueCollection{ } //"'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Collections.Specialized.NameValueCollection"
        type(System.Diagnostics.DataReceivedEventArgs; System_System_Diagnostics_DataReceivedEventArgs{ } //"'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Diagnostics.DataReceivedEventArgs"
        type(System.Net.DecompressionMethods; System_System_Net_DecompressionMethods{ } //"'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.DecompressionMethods"
        type(System.Net.HttpStatusCode; System_System_Net_HttpStatusCode{ } //"'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.HttpStatusCode"
        type(System.Net.HttpWebRequest; System_System_Net_HttpWebRequest{ } //"'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.HttpWebRequest"
        type(System.Net.HttpWebResponse; System_System_Net_HttpWebResponse{ } //"'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.HttpWebResponse"
        type(System.Net.WebException; System_System_Net_WebException{ } //"'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.WebException"
        type(System.Net.WebExceptionStatus; System_System_Net_WebExceptionStatus{ } //"'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.WebExceptionStatus"
        type(System.Uri; System_System_Uri{ } //"'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Uri"
        type(System.UriKind; System_System_UriKind{ } //"'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.UriKind"

    }
    assembly(msado60)   //Not Working Activex Controller
    {
        type(ADO.Connection; Ado_Connection{ }
    }

}
Thanks,
Shyam
Categories:

Helpful resources

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans