Z
Zhou, Andy
Guest
Hi there, I'm not a sophisticated VS developer, but I've developed a VB application with Visual Studio Community Edition. The application is compiled to an executable .exe for people to use. Part of the feature is to browse Oracle database objects to perform some predefined search. This requires the application to have a dedicated Oracle account having read access the database. I had coded the account and password in the VB source code, then compile the source code into .exe. The .exe would work on any Windows host, by any user, as long as the host can reach the Oracle database (with proper tns).
Now with the higher security requirements, the Oracle account password needs to be changed periodically. With my current method, each time the Oracle account password is changed, I have to change it in the source code and recompile to generate a new .exe. This is obviously not a desirable way. I know a Web application can be the ultimate solution, but converting this VB application into a Web application could be a bigger effort itself.
Now my question: Is it possible for VB application in Visual Studio Community Edition to parameterize some values (in this case the password), so the compiled .exe can run on any Windows machine with the parameterized values. If I have the .exe to read a configuration file, then every machine/user must have read access to the configuration file, which defeat the security purpose. I just cannot think of any other way. Thanks in advance.
Continue reading...
Now with the higher security requirements, the Oracle account password needs to be changed periodically. With my current method, each time the Oracle account password is changed, I have to change it in the source code and recompile to generate a new .exe. This is obviously not a desirable way. I know a Web application can be the ultimate solution, but converting this VB application into a Web application could be a bigger effort itself.
Now my question: Is it possible for VB application in Visual Studio Community Edition to parameterize some values (in this case the password), so the compiled .exe can run on any Windows machine with the parameterized values. If I have the .exe to read a configuration file, then every machine/user must have read access to the configuration file, which defeat the security purpose. I just cannot think of any other way. Thanks in advance.
Continue reading...