FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

Hydak, Christopher wrote:
> [][unixODBC][FreeTDS][SQL Server]Login failed for user 'user'.
                                                          ^^^^
> [DBservername]
> Description = FreeTSD to Database Server
> Driver = TDS
> Servername = db.mycompany.com
> Database = DBname
> UID = user
        ^^^^ 
> PWD = "password"
> Trace = No
> Protocol = 4.2

Is there in fact a user named 'user' whose password is "password" (with
the quotes)?   I would guess you want to substitute the real username and
password here.  Try it with tsql and unixODBC's isql first.  

[Generally we don't recommend putting that kind of information in your
.ini file, but I assume you have a reason.]

Also, I wouldn't use TDS version 4.2 unless that's all your server
supports.  

HTH.

--jkl