How can I specify a user id or password for a database ?

[Sean]

You can specify a userid and password when you are configuring the DSN .

You can also specify a userid/password when connecting to the DSN. This allows you to create the DSN with no userid/password specified but instead specify it during runtime. you need to do is connect to the DSN the way you normally would but specify a user id and password attributes:

$db = new Win32::ODBC("DSN=My DSN;UID=Joel;PWD=Joel's Password;");

Note: you must use a semicolon ( ; ) between attributes.