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.
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