Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Business Applications Summit Gallery ... / Microsoft ActiveX Data...
Microsoft Business Applications Summit Gallery ...
Unanswered

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

(0) ShareShare
ReportReport
Posted on by Shyamraoo 354

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Leaderboard > Microsoft Business Applications Summit

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans