Hide my OLEDB connectionstring in Excel

Navigation
3

I need to hide the password or the entire connection string to outsiders who use a certain template in Excel 2010.

To create the connection, I follow the following steps in Excel:

  • "Data" tab
  • Option - "From other sources"
  • Option - "From the wizard for the data connection."
  • I select: "Microsoft Data Access - OLEDB Data Provider for Oracle"
  • Enter connection data.
  • Next, Next, Finish.

    • The issue is that if someone enters the connection properties after created, you can view important data such as the user, password and server of my database, that is why, I consult if someone knows any form of Hide the connection string that is created.

    Does anyone know how?

    Greetings!

        
    asked by SteveKhyuga 28.02.2017 в 22:06
    source

    1 answer

    1

    Following this answer , and if you do not need the Excel file to have the credentials, you can consider removing the connection string after you export the information to the Excel file:

    Follow these steps:

  • Create an Excel file.
  • Follow the same steps you describe in your question .
  • Re-select the "Data" tab
  • Select the option "Connections".
  • Select the existing connection and press the Remove button. At this point you get a warning similar to image 1.
  • Close the Connections window.
  • Select the "Properties" option.

    • At this point, you will see the name of the database, but you will not be able to access the properties of the connection.

    Image 1: Image showing the exit confirmation message before removing the connection.

        
    answered by 01.03.2017 в 14:50
    Read HTML from a WebBrowser AngularJS returns UNDEFINED to me in the RETURN