Skip to main content

ADO.Net client driver Vertica.Data.dll 32 bit vs 64 bit?

  • June 12, 2018
  • 2 replies
  • 9 views

ScottL
Forum|alt.badge.img+1
  • Participating Frequently

I download the client install for 9.1 from https://my.vertica.com/client_drivers/9.1.x/9.1.0-0/VerticaSetup-9.1.0-0.exe and after I installed I compared the Vertica.Data.dll ADO.Net driver in the ADO.NET32 and ADO.NET64 folders and both show as being the same file - a 32 bit dll. I verfied the 8.1 client install and found the same scenario so just wanted to make sure this was intentional and the wrong dll was not mistakenly placed in both folders. thanks!

2 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • June 12, 2018

Hi,

They do indeed seem to be the same file.

Using MS PowerShell I grabbed the "ProcessorArchitecture" for each file. They are both "MSIL". These means they are"Neutral with respect to processor and bits-per-word". ProcessorArchitecture of MSIL are portable and can run under any platform :)

See: https://blog.bugrapostaci.com/2017/06/20/any-cpu-or-x64-or-x86/

Here is my PowerShell output:

PS C:\Users\knicely> [reflection.assemblyname]::GetAssemblyName("C:\Program Files\Vertica Systems\ADO.NET64\Vertica.Data.dll") | fl


Name                  : Vertica.Data
Version               : 9.1.0.0
CultureInfo           :
CultureName           :
CodeBase              : file:///C:/Program Files/Vertica Systems/ADO.NET64/Vertica.Data.dll
EscapedCodeBase       : file:///C:/Program%20Files/Vertica%20Systems/ADO.NET64/Vertica.Data.dll
ProcessorArchitecture : MSIL
ContentType           : Default
Flags                 : PublicKey
HashAlgorithm         : SHA1
VersionCompatibility  : SameMachine
KeyPair               :
FullName              : Vertica.Data, Version=9.1.0.0, Culture=neutral, PublicKeyToken=725728a8837b3bd5


PS C:\Users\knicely> [reflection.assemblyname]::GetAssemblyName("C:\Program Files (x86)\Vertica Systems\ADO.NET32\Vertica.Data.dll") | fl


Name                  : Vertica.Data
Version               : 9.1.0.0
CultureInfo           :
CultureName           :
CodeBase              : file:///C:/Program Files (x86)/Vertica Systems/ADO.NET32/Vertica.Data.dll
EscapedCodeBase       : file:///C:/Program%20Files%20(x86)/Vertica%20Systems/ADO.NET32/Vertica.Data.dll
ProcessorArchitecture : MSIL
ContentType           : Default
Flags                 : PublicKey
HashAlgorithm         : SHA1
VersionCompatibility  : SameMachine
KeyPair               :
FullName              : Vertica.Data, Version=9.1.0.0, Culture=neutral, PublicKeyToken=725728a8837b3bd5

ScottL
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • June 12, 2018

Thanks, Jim! Nice to have confirmation and so expediently as well!