For better or worse, our programmer is hard-coding the DSN, User, and Password in their programs. Assuming the DSN on the Windows Server is set up properly (i.e.-correct credentials, connection string, and default database), does hard-coding the DSN, User and Password bypass Server Manager? In other words, does this go through Server Manager at all, or does it connect the program directly to the DB via the Windows Server DSN configuration? Ultimately, I plan to ensure we're keeping with best practice, and I've never seen hard-coded User and Password directly in a program considered best practice. I assume we should be verifying user credentials via the User Manager, and then connecting to the DB via the Server Manager. Any guidance/input is greatly appreciated.
... View more