Hi,
I am using Business Objects (5.1) for reporting on a SQLServer db. Within BO I am using some VBA macroes, which connect to the db using ADO 2.8 . The VB macroes perform a few requests and fill the BO prompts with values.
My question is: How can I connect to the db without hardcoding the user/password in the macro ? (this solution is not accepted for security reasons).
The direction I'm looking at for the moment is this one: Is it possible to have the definition of the connection compiled in a dll or ocx and get the results through this connection, without letting anyone find out what the connection user/password is?
(If you see other ways of doing let me know as well)
Thank you,
Toni
I am using Business Objects (5.1) for reporting on a SQLServer db. Within BO I am using some VBA macroes, which connect to the db using ADO 2.8 . The VB macroes perform a few requests and fill the BO prompts with values.
My question is: How can I connect to the db without hardcoding the user/password in the macro ? (this solution is not accepted for security reasons).
The direction I'm looking at for the moment is this one: Is it possible to have the definition of the connection compiled in a dll or ocx and get the results through this connection, without letting anyone find out what the connection user/password is?
(If you see other ways of doing let me know as well)
Thank you,
Toni