This is a migrated thread and some comments may be shown as answers.

Does the EntityDataSource component support Oracle databases?

1 Answer 189 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mark
Top achievements
Rank 1
Mark asked on 21 Nov 2013, 04:54 PM
SqlDataSource seems to work fine with an Oracle DB connection string but I cannot get the EntityDataSource component to work with Oracle.  Is this supported please?  I do not see any document for this combination.

I set up the EntityDataSource component using the wizard and then when I click on the Preview tab the following error appears:

An error has occurred while processing Report 'Report1':
Exception has been thrown by the target of an invocation.
------------- InnerException -------------
An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.
------------- InnerException -------------
The provider did not return a ProviderManifestToken string.
------------- InnerException -------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
------------- InnerException -------------
The network path was not found


It seems to show a SQL rather than Oracle error!

Thanks

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 26 Nov 2013, 09:49 AM
Hello Mark,

Generally not all of the Oracle data providers support Entity Framework. Thus first our suggestion is to check if your provider officially supports Entity Framework and try to use it with a generic control. Additionally you can try to preview the report in a report viewer to make sure the error is not due to the design time peculiarity.

Regards,
Peter
Telerik

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

Tags
General Discussions
Asked by
Mark
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or