Trouble Connecting to Oracle Database

[Yu]

Hi,
I am trying to connect to an Oracle Database using Devart dotConnect for Oracle.
I am able to configure the Data Source without any issues in the wizard and the Query Builder runs fine. The problem is when I  try to execute the query in the Wizard at the Preview Data Source Results I get an error dialog box only says Devart.Data.Oracle.

Thanks,
Yu

[Steve]

Hi Yu,

The SqlDataSource uses ADO.NET classes to interact with any database supported by ADO.NET. This includes:

Provider Name                             Invariant Name                         Description
SqlClient Data Provider              System.Data.SqlClient          .Net Framework Data Provider for SqlServer
OracleClient Data Provider        System.Data.OracleClient    .Net Framework Data Provider for Oracle
OleDb Data Provider                   System.Data.OleDb               .Net Framework Data Provider for OleDb
Odbc Data Provider                     System.Data.Odbc                 .Net Framework Data Provider for Odbc
MySQL Data Provider                  MySql.Data.MySqlClient        .Net Framework Data Provider for MySQL
Oracle Data Provider for .NET   Oracle.DataAccess.Client     Oracle Data Provider for .NET

As you can see Devart dotConnect for Oracle is not among the list of supported providers. At this point we do not have plans to introduce support for new providers, but if the interest for a particular provider increases we might consider it.

Sincerely yours,
Steve
the Telerik team

[Patrick]

@Steve
You might want to add SQLite to that list. I've got a simple proof-of-concept C# 2008 application which targets Q2 2009 of Telerik reporting, but cannot attach .zip files to this post. Drop me a line if you're interested.

[Steve]

Hello Patrick,

When you say "proof-of-concept" you mean that you were able to get it running with our SqlDataSource component? If this is not what you meant, then yes we would consider supporting SQLite for future versions.

Regards,
Steve
the Telerik team

[Patrick]

@Steve,

I'm not using the SqlDataSource component. I've sent an email the Telerik support email address which contains a link to download the demo app from MediaFire.

[Steve]

Hi Patrick,

Thank you for the heads up. We've logged SqLite support in our system and it would be considered for future implementation.

Best wishes,
Steve
the Telerik team

[Alexandre Jobin]

i would also like to have support for DevArt dotConnect for Oracle!

[Steve]

Hi Alexandre,

I'm logging your vote - thank you for the involvement!

Kind regards,
Steve
the Telerik team

[fabiopand]

it's so sad that you don't support the most used oracle provider for EF4 (DevArt dotConnect for Oracle)