Oracle Connection string questions

7 posts, 0 answers
  1. kent
    kent avatar
    7 posts
    Member since:
    Jul 2014

    Posted 14 Jul 2014 Link to this post

    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.
  2. KS
    KS avatar
    165 posts
    Member since:
    Oct 2012

    Posted 17 Jul 2014 in reply to kent Link to this post

  3. DevCraft banner
  4. kent
    kent avatar
    7 posts
    Member since:
    Jul 2014

    Posted 17 Jul 2014 in reply to KS Link to this post

    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.
  5. KS
    KS avatar
    165 posts
    Member since:
    Oct 2012

    Posted 22 Jul 2014 in reply to kent Link to this post

    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



  6. kent
    kent avatar
    7 posts
    Member since:
    Jul 2014

    Posted 23 Jul 2014 in reply to KS Link to this post

    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.
  7. KS
    KS avatar
    165 posts
    Member since:
    Oct 2012

    Posted 24 Jul 2014 in reply to kent Link to this post

    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
  8. kent
    kent avatar
    7 posts
    Member since:
    Jul 2014

    Posted 24 Jul 2014 in reply to KS Link to this post

    Investigating both of these options should lead me to the answer I am looking for.  I like the idea of building a separate DLL to pass along to the users better, so I will explore that avenue first.

    Thanks again for your help. :)
Back to Top
DevCraft banner