[freetds] Problems Connecting Debian --> MSSQL through odbc

Daniel Fazekas fdsubs at t-online.hu
Wed Jul 29 08:44:21 EDT 2009


On Jul 29, 2009, at 14:32, Jaap van Arragon wrote:

> Any idea why I cant connect?

The server refused your login name / password.

But there's something really weird going on, did you tamper with the  
output by hand?

> Attempting connection as admin ...
> + isql SBGROEP admin pass -v
> net.c:671:Received packet
> 0000 aa 58 00 18 48 00 00 01-0e 1f 00 4c 00 6f 00 67  
> |.X..H... ...L.o.g|
> 0010 00 69 00 6e 00 20 00 66-00 61 00 69 00 6c 00 65  
> |.i.n. .f .a.i.l.e|
> 0020 00 64 00 20 00 66 00 6f-00 72 00 20 00 75 00 73  
> |.d. .f.o .r. .u.s|
> 0030 00 65 00 72 00 20 00 27-00 73 00 71 00 6c 00 77  
> |.e.r. .' .a.s.m.i|
> 0040 00 65 00 62 00 27 00 2e-00 07 53 00 42 00 47 00  
> |.n..'.. ..S.B.G.|
> 0050 53 00 51 00 4c 00 31 00-00 01 00 fd 02 00 00 00 | 
> p.a.s.s. ........|
> 0060 00 00 00 00            -                        |....|
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [37000][unixODBC][FreeTDS][SQL Server]Login failed for user 'admin'.
> [ISQL]ERROR: Could not SQLConnect

Notice that the supposed ASCII dump up there supposedly says "asmin"  
rather than admin.
Even weirder, the hex bytes on the left say that the message was:

Login failed for user 'sqlweb' SBGSQL1



More information about the FreeTDS mailing list