Skip to Content.
Sympa Menu

freetds - Re: [freetds] How to specify uid and pwd in odbc.ini?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] How to specify uid and pwd in odbc.ini?
  • Date: Fri, 22 Nov 2013 18:43:05 -0500

On Tue, 19 Nov 2013 15:45:53 +0000
???????? ?????? ?????????? <m.gavrilov AT citrus-it.ru> wrote:

> I really do not understand is it safer to write when creating each
> table username and password than store in in one place in odbc.ini on
> server???
>
> CREATE TABLE ttlog ENGINE=CONNECT table_type=ODBC tabname='ttlog'
> CONNECTION='DSN=SQL_DW;UID=lnmp;PWD=lnmp'
>
> And will be really nightmare if lnmp password changed. :(

(It is helpful to readers of the archive if you don't top-quote.)

We don't read passwords from odbc.ini for security reasons. We
recommend that people who want passwordless connections use Kerberos or
similar. FreeTDS supports it for all servers and clients, as far as
I'm aware.

If you don't need security, you could set up an account with no
password (or a known one, and hard-code it).

If you want a little security, the kind that will discourage your
grandmother, keep your passwords in a file or environment variable. I
used to keep mine in ~/.netrc, and use awk to parse out the bits.

HTH.

--jkl





Archive powered by MHonArc 2.6.24.

Top of Page