System.Data.SqlClient.SqlClientFactory, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

Question

Hello 
 In a import script we have the following line. After the migration to 9.3 is done, it started to throw this exception: 
 lineProvider.ProviderName = "System.Data.SqlClient.SqlClientFactory, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" 
 Exception: 
 The assembly 'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' could not be found., at VI.Base.AssemblyLoader._LoadFrom(AssemblyName asmName, Boolean throwOnException) 
 How can we solve this issue? 
 Kind regards, 
 David.

Markus Weiss-Ehlers · Accepted Answer

Try to replace the line with the following.

dbLineProvider.ProviderName = "Microsoft.Data.SqlClient.SqlClientFactory, Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5"

david alarcia_51955 · Answer

Hello, 
 Finally I found the solution: 
 #R Microsoft.Data.SqlClient 
 lineProvider.ProviderName = "Microsoft.Data.SqlClient.SqlClientFactory, Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2dbae4235" lineProvider.ConnectionString = dfImport.Options & ";TrustServerCertificate=True" 
 Kind regards, 
 David.

System.Data.SqlClient.SqlClientFactory, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

Top Replies