Create ODBC with password

Brogrim
Brogrim used Ask the Experts™
on
I have inherited a batch file that creates and ODBC with the password included. What edits do I need to put in to include a password, I want the user to have to input a password when they access the database.

SET THISDIR=%__MEMBERSDB%
if "_%OS%" == "_Windows_NT" cd /d "%THISDIR%"
if "_%OS%" == "_" cd "%THISDIR%"

"%__ASABIN%\dbdsn" -ws "remMembers" -c "UID=DBA;PWD=sql;DBF=%THISDIR%\members.db" -y
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
BrogrimInformation Systems Development Manager

Author

Commented:
Thanks for the link but it is not really explaing where I edit the batch file that I have to use

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial