Some more information.
This is the error we get in our MySQL Workbench logs. Not sure exactly what the ‘type’ field that it thinks is Null is:
2016-11-21T22:10:03.045323Z 1571 Query INSERT INTO ErrorLog (Source, Type, Message, Detail) VALUES ('No Source', 'System.InvalidOperationException', 'Failed to load adapter "PPA" [ADOAdapters.AdoOutputAdapter] from "C:\\Program Files\\openPDC\\AdoAdapters.dll": Value cannot be null.
Parameter name: type', '(Inner Exception)
Date and Time: 11/21/2016 5:09:58 PM
Machine Name: WIN-KUPIQUEG1GI
Machine IP: fe80::3d98:6490:2b4c:2df7%12
Machine OS: Microsoft Windows NT 6.1.7601 Service Pack 1
Current User ID: NT SERVICE\\openPDC
Current User Name:
Current User Phone:
Current User Email:
Application Domain: openPDC.exe
Assembly Codebase: C:/Program Files/openPDC/openPDC.exe
Assembly Full Name: openPDC, Version=2.3.1.0, Culture=neutral, PublicKeyToken=null
Assembly Version: 2.3.1.0
Assembly Build Date: 10/16/2016 12:01:30 AM
.Net Runtime Version: 4.0.30319.42000
Exception Source: mscorlib
Exception Type: System.ArgumentNullException
Exception Message: Value cannot be null.
Parameter name: type
Exception Target Site: CreateInstance
---- Stack Trace ----
System.Activator.CreateInstance(type As Type, nonPublic As Boolean)
openPDC.exe: N 13800168
System.Activator.CreateInstance(type As Type)
openPDC.exe: N 00012
GSF.TimeSeries.Adapters.AdapterCollectionBase\`1.TryCreateAdapter(adapterRow As DataRow, adapter As T&)
openPDC.exe: N 00442
(Outer Exception)
Date and Time: 11/21/2016 5:10:03 PM
Machine Name: WIN-KUPIQUEG1GI
Machine IP: fe80::3d98:6490:2b4c:2df7%12
Machine OS: Microsoft Windows NT 6.1.7601 Service Pack 1
Current User ID: NT SERVICE\\openPDC
Current User Name:
Current User Phone:
Current User Email:
Application Domain: openPDC.exe
Assembly Codebase: C:/Program Files/openPDC/openPDC.exe
Assembly Full Name: openPDC, Version=2.3.1.0, Culture=neutral, PublicKeyToken=null
Assembly Version: 2.3.1.0
Assembly Build Date: 10/16/2016 12:01:30 AM
.Net Runtime Version: 4.0.30319.42000
Exception Source:
Exception Type: System.InvalidOperationException
Exception Message: Failed to load adapter "PPA" [ADOAdapters.AdoOutputAdapter] from "C:\\Program Files\\openPDC\\AdoAdapters.dll": Value cannot be null.
Parameter name: type
---- Stack Trace ----
###############
This is our Connection String:
BulkInsertLimit=500; DataProviderString={ AssemblyName={MySql.Data, Version=6.2.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d}; ConnectionType=MySql.Data.MySqlClient.MySqlConnection; AdapterType=MySql.Data.MySqlClient.MySqlDataAdapter }; DbConnectionString={ Server=localhost; Database=openpdc; Uid=root; Password=sqldba}; TableName=timeseriesmeasurement; IDFieldName=ID; TimestampFieldName=Timestamp; ValueFieldName=Value