I am trying to configure a data feed in Archer, that should fetch the results from a PostgreSQL server. I installed the PostgreSQL ODBC drivers on the machine, and I am able to connect the same using ADOdb connections to the server, and retrieve the query results (via VB Script). However when I run the query with the same connection string in the Data Feed, it throws an error as below:
An unexpected error has occurred: Unable to find the requested .Net Framework Data Provider. It may not be installed.
This is the connection string I am using in my Data Feed and the client:
What could be a solution to this problem?
- Community Thread
- Forum Thread
- RSA Archer
- RSA Archer Suite
There is a bug in DFM where the Provider is not actually set to "ODBC Data Provider" even though it shows it on the screen. You have to change the value in the dropdown, hit Apply and then change it back to "ODBC Data Provider". This bug has been fixed in 5.5 SP1 P2 and 5.5 SP2.
Was there any solution or insight for the error message? "An unexpected error has occurred: Unable to find the requested .Net Framework Data Provider. It may not be installed."?
I am also getting the same message in the logs. My connection string is good.
ProstgreSQL is not in scope for me.
I am just getting the same error message. An unexpected error has occurred: Unable to find the requested .Net Framework Data Provider. It may not be installed. I am trying to connect to DB2.
I am using Archer 5.2 and I see it lacks .NET 3.5 SP1 on the webserver, so I am installing it and see if that helps. Install guide for 5.2 states it needs 3 flavors of .NET (4.0 Client, 4.0 Extended, 3.5 SP1), but I am missing 3.5 SP1.
I am configuring a data feed as a Database Query Transport. Specifically, I get the error when I "Load Fields" via Execute Query while on the Source Definition tab.
Ok, so Archer tries to talk to the DB2 server. Which means Archer doesn't have the appropriate drivers in place for DB2. Just like the postgresql, custom data source you will need to make sure the drivers are installed. Installing .Net 3.5 is not going to make a difference from what you have explained. Hope this helps!