How to create an Oracle data source?

[M. R.]

Hello,

I installed latest version of Reporting and trying to create a report based on an Oracle table.
Can you please provide instructions about how connect to the Oracle database?

I see the following screen in the connection wizard:
I need to connect to 
server: OTNE25
database: BTUDEV
user: NTHOMAS

Where do I enter this information on the screen below?
In order to connect to Oracle I need to provide three pieces on information, i.e. server, schema and user name. There is no "schema" box on this screen.

Maybe it relies on TNSNAMES.ORA that I have in my Oracle Client folder? I have an entry in this file that describes the connection but how to use it?

Please advise.
Regards,
M.R.

[M. R.]

Hi M.R.,

This is our reply in your support ticket on the same question:

   Please try to configure the SqlDataSource component to use a different data provider:

    Add a new SqlDataSource component to the report.
    Click on the "Specify a new connection string" option.
    Choose "OracleClient Data Provider" from the dropdown and click "Build...".
    In the "Connection Properties" window click "Change...".
    In the "Change Data Source" window select ".NET Framework Data Provider for OLE DB" from the Data provider dropdown and click OK.
    Now configure your connection properties as usual.


Try the above and if you have any issues with the connection string builder you can specify the connection string manually. For more information on the Oracle connection string format you follow the Oracle connection strings page.

If you need any further help, please let us continue the discussion in the support ticket, so we can avoid splitting information between threads.

Regards,
Stef
Telerik

 

 

[M. R.]

thanks for asking this question because the same problem to me

oracle training in

[M. R.]

Hi, It's a great post. really you shared useful Information. Thank you for sharing.

<a href=”https://www.digitalkora.com”>digital marketing courses in bangalore</a>

[M. R.]

hello sir,
thanks for giving that type of information.
<a href="https://www.ogeninfo.com/digital-marketing/">best digital marketing company in delhi</a>

[Jeff]

I have the same question, however your advice didn't work for me. 

I have 2 user accounts that successfully log in through my Oracle Forms Designer using a connection defined in my tnsnames.ora file. So I know I have valid username/password combos.

When I build and test the connection string in Telerik Report Designer using the Oracle Database (Oracle Client) with .NET Framework Data Provider for OLE DB, Server name from my tnsnames.ora file, and username/password,  I get the error "The 'MSDAORA' provider is not registered on the local machine".

However, when I build and test the connection string in Telerik Report Designer using the Oracle Database (Oracle Client) with .NET Framework Data Provider for Oracle, Server name from my tnsnames.ora file, and username/password,  I get the error "ORA-01017: invalid username/password; logon denied".  With this connection string at least I know I'm getting to the server.

The description for the Oracle Database/Data Provider .NET Framework Data Provider for Oracle says its only designed to work up to Oracle v 10g.  My db is on version 12g.  Any suggestions?

 

 

 

[Dimitar]

The OracleClient data provider for .NET is deprecated and should not be used - Should I use System.Data.OracleClient .NET data provider to retrieve data for reports from an Oracle database?

Regarding the MSDAORA error, I believe that MSDAORA is only supported for 32-bit applications and the default designer is a 64-bit application. In the installation folder, inside the Report Designer, there is an x86 version of the application that you may run and test with this data provider. I definitely could be wrong about the MSDAORA being supported only in 32 bit but I believe it is worth trying.

Regarding the ORA-01017 error, please note that the credentials are case sensitive and it is very easy to get something wrong, I certainly have had this problem before and it has always turned out to be some small mistake in my password. I cannot think of why this error would be thrown if the problem was elsewhere. Does this user have all or enough privileges?

We recommend the usage of Oracle Data Provider for .NET/ODP.NET. More .NET data providers and how they can be used for connecting to an Oracle database can be found in Oracle connection strings.

Please try with the suggested provider and let us know the results. If you would need further help, you may attach a trace listener to the standalone designer and then send us the generated log - Standalone Report Designer Problems.