Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I specify a userid and/or password for a database?

April 26, 2017database password specify UserID

0

10 Posted

How can I specify a userid and/or password for a database?

1 Answer

0

Posted

You can specify a userid and password when configuring the DSN (check out section E of “How Do I Create A System 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. All you need to do is connect to the DSN the way you normally would but specify a usid and pwd attributes: $db = new Win32::ODBC(“DSN=My DSN;UID=Joel;PWD=Joel’s Password;”); Notice that you must use a semicolon (;) between attributes.