I support a system that uses a VB.NET Reporting client that attaches to an Oracle 11g database running on a Linux server. We would like to use the standalone Report Designer as a supplement to our canned reports so that 'Power Users' can query the database to get the data they are after.
All of the support documentation on connection strings refers to SQL server running locally. None of the documentation mentions Oracle. I am wondering if the standalone Report Designer can attach to an Oracle database on a Linux server if given the correct connection details.
If so, could you please provide a sample connection string for connecting to Oracle databases.
Thanks in advance.
All of the support documentation on connection strings refers to SQL server running locally. None of the documentation mentions Oracle. I am wondering if the standalone Report Designer can attach to an Oracle database on a Linux server if given the correct connection details.
If so, could you please provide a sample connection string for connecting to Oracle databases.
Thanks in advance.
5 Answers, 1 is accepted
0
KS
Top achievements
Rank 1
Rank 1
answered on 17 Jul 2014, 04:15 PM
Hi,
It seems to be possible - How to write an Oracle stored procedure to work with Telerik Reporting Wizard?
There is needed only a valid .NET data provider.
-KS
It seems to be possible - How to write an Oracle stored procedure to work with Telerik Reporting Wizard?
There is needed only a valid .NET data provider.
-KS
0
kent
Top achievements
Rank 1
Rank 1
answered on 17 Jul 2014, 04:41 PM
Thank you KS for your reply.
The links you provided (and practically all of the support documentation about reporting) relate back to the Report Designer UI which gets integrated into Visual Studio. I am looking for help with the Standalone Reporting client which does not use Visual Studio, and appears to use connection strings stored within an XML configuration file. The XML configuration would reside on the same machine where the Standalone Reporting client .exe file resides.
Presuming that the client running the Standalone Reporting client has the correct Oracle Data Provider installed (ODP.NET), I am looking for two things:
1. An example of a connection string that will connect to the Oracle database using the Oracle Data Provider.
2. Would like to know if this connection string can be encrypted.
Thanks in advance.
The links you provided (and practically all of the support documentation about reporting) relate back to the Report Designer UI which gets integrated into Visual Studio. I am looking for help with the Standalone Reporting client which does not use Visual Studio, and appears to use connection strings stored within an XML configuration file. The XML configuration would reside on the same machine where the Standalone Reporting client .exe file resides.
Presuming that the client running the Standalone Reporting client has the correct Oracle Data Provider installed (ODP.NET), I am looking for two things:
1. An example of a connection string that will connect to the Oracle database using the Oracle Data Provider.
2. Would like to know if this connection string can be encrypted.
Thanks in advance.
0
KS
Top achievements
Rank 1
Rank 1
answered on 22 Jul 2014, 02:47 PM
Hi,
The SqlDataSource component uses standard ADO.NET classes to establish a connection to the database and retrieve records through the installed on the machine data provider. The connection string should be considered with the selected data provider - it must be the same as the one use to build a command and execute SQL query in code. Check http://www.connectionstrings.com/oracle for examples.
And encrypting the connection string, the designer tool is just an executable with a config file, so this approach will work - Encrypting Configuration File Sections Using Protected Configuration.
-KS
The SqlDataSource component uses standard ADO.NET classes to establish a connection to the database and retrieve records through the installed on the machine data provider. The connection string should be considered with the selected data provider - it must be the same as the one use to build a command and execute SQL query in code. Check http://www.connectionstrings.com/oracle for examples.
And encrypting the connection string, the designer tool is just an executable with a config file, so this approach will work - Encrypting Configuration File Sections Using Protected Configuration.
-KS
0
kent
Top achievements
Rank 1
Rank 1
answered on 23 Jul 2014, 08:08 PM
Thanks again for your reply. Both links that you provided are the same... they point to the connection strings site (very handy).
Could you re-post the link for encryption again?
Thanks in advance.
Could you re-post the link for encryption again?
Thanks in advance.
0
KS
Top achievements
Rank 1
Rank 1
answered on 24 Jul 2014, 11:39 AM
Hi and oops,
Just a severe case of copy/paste... I meant the msdn post regarding connection strings, configurations and protecting sensitive information - http://msdn.microsoft.com/en-us/library/ms254494(v=vs.110).aspx.
On a second thought you can mask all connection stuff in a data model and pass the DLL to users, without them knowing what happens underneath - Extending Report Designer (and it looks easier).
-KS
Just a severe case of copy/paste... I meant the msdn post regarding connection strings, configurations and protecting sensitive information - http://msdn.microsoft.com/en-us/library/ms254494(v=vs.110).aspx.
On a second thought you can mask all connection stuff in a data model and pass the DLL to users, without them knowing what happens underneath - Extending Report Designer (and it looks easier).
-KS