Article Content
Article Number | 000017338 |
Applies To | RSA Product Set: Archer Platform: MySQL |
Issue | Unable to connect with MySQL server with a Data Feed using proper credentials and details. Clicking Load Fields fails with Log Reference ID. An unexpected error has occurred: Unable to find the requested .Net Framework Data Provider. It may not be installed. The following is a sample exception is from the w3wp log file: <E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent"> <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system"> <SubType Name="Critical">0</SubType> <Source Name="ArcherTech.DataFeed" /> <Execution ProcessName="w3wp" ProcessID="6548" ThreadID="211" /> </System> <ApplicationData> <TraceData> <DataItem> <TraceRecord Severity="Critical" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord"> <TraceIdentifier>ArcherTech.DataFeed</TraceIdentifier> <Description>Unable to create a database connection: Unable to find the requested .Net Framework Data Provider. It may not be installed. Likely causes are the connection string is either improperly formatted or it contains unknown parameters.</Description> <AppDomain>/LM/W3SVC/1/ROOT/RSAarcher-1-131332415725574658</AppDomain> <ContextData> <LogReferenceId>030617-044705-6286</LogReferenceId> </ContextData> <Exception> <ExceptionType>ArcherTech.DataFeed.Util.LoadFieldsException, ArcherTech.DataFeed.Util, Version=5.5.10000.1088, Culture=neutral, PublicKeyToken=null</ExceptionType> <Message>Unable to create a database connection: Unable to find the requested .Net Framework Data Provider. It may not be installed. Likely causes are the connection string is either improperly formatted or it contains unknown parameters.</Message> <Source>ArcherTech.DataFeed.Util</Source> <StackTrace> at ArcherTech.DataFeed.Util.SqlDbWrapper.GetDatabaseProviderFactory(String provider) at ArcherTech.DataFeed.Util.DataFeedSchemaSetGenerator.GetDatabaseQuerySchemaSet(XDocument configXDoc) at ArcherTech.DataFeed.Util.DataFeedSchemaSetGenerator.GetSchemaSetWithConfig(Stream streamConfigAndSource)</StackTrace> <InnerException> <ExceptionType>System.ArgumentException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType> <Message>Unable to find the requested .Net Framework Data Provider. It may not be installed.</Message> <Source>ArcherTech.DataFeed.Util</Source> <ContextData> <Provider>Odbc Data Provider</Provider> </ContextData> <StackTrace> at ArcherTech.DataFeed.Util.SqlDbWrapper.GetDatabaseProviderFactory(String provider)</StackTrace> </InnerException> </Exception> </TraceRecord> </DataItem> </TraceData> </ApplicationData> </E2ETraceEvent> |
Cause | The MySQL drivers are not installed on all Archer servers. |
Resolution | The following procedures are for adding test and configuring MySQL connection to RSA Archer. The MySQL drivers version may be different than what is shown below. Contact your MySQL DBA to get the correct version.
Driver={MySQL ODBC 5.3w Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=3; For more MySQL connection strings examples visit ConnectionStrings.
|
Legacy Article ID | a65454 |