MDAC Version
-
Hi, Can anyone please give me the code snippet in vb6 to check if MDAC is present on a machine and the MDAC version number if it is present. Right now i have a code that checks the ADO version. Here is the code: Option Explicit Function GetAdoVersion() As String 'Returns an empty string if ADO is not installed Dim o As Object On Error Resume Next Set o = CreateObject("ADODB.Connection") If Err.Number = 0 Then GetAdoVersion = o.Version Label1.Caption = "ADO Version = " & o.Version Else Label1.Caption = "ADO is not installed" End If End Function Private Sub Form_Load() Call GetAdoVersion End Sub Are ADO version and MDAC version the same always? Thanks in advance, Sarah -- modified at 6:12 Thursday 24th November, 2005
-
Hi, Can anyone please give me the code snippet in vb6 to check if MDAC is present on a machine and the MDAC version number if it is present. Right now i have a code that checks the ADO version. Here is the code: Option Explicit Function GetAdoVersion() As String 'Returns an empty string if ADO is not installed Dim o As Object On Error Resume Next Set o = CreateObject("ADODB.Connection") If Err.Number = 0 Then GetAdoVersion = o.Version Label1.Caption = "ADO Version = " & o.Version Else Label1.Caption = "ADO is not installed" End If End Function Private Sub Form_Load() Call GetAdoVersion End Sub Are ADO version and MDAC version the same always? Thanks in advance, Sarah -- modified at 6:12 Thursday 24th November, 2005
It's not that simple. No ADO and MDAC versions are NOT always the same. Various applications can install differing versions on their own, without installing the complete MDAC package. There is no reliable way to determine whcih version your using. Component Checker[^] will scan your machine to determine which version of MDAC your machine has installed, or the closest match. It'll show you what pieces are missing and what's installed, as well as the version information for each .DLL. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-
It's not that simple. No ADO and MDAC versions are NOT always the same. Various applications can install differing versions on their own, without installing the complete MDAC package. There is no reliable way to determine whcih version your using. Component Checker[^] will scan your machine to determine which version of MDAC your machine has installed, or the closest match. It'll show you what pieces are missing and what's installed, as well as the version information for each .DLL. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
Ok.Thanks for taking the time to reply.:) -- modified at 0:34 Saturday 26th November, 2005
-
Ok.Thanks for taking the time to reply.:) -- modified at 0:34 Saturday 26th November, 2005