FreeTDS Development Group

[Nil Alexandrov <nil AT internet2.ru>]

Hello !

I have written small fake mssql server using tds 4.2 version (it's very
simple, no SQL syntax parse yet) There is no problem to use my fake server
from ODBC driver. Now, I'am going to use it like linked server to the
original MSSQL Server 7.0. When I use ODBC driver to connect to my fake
server - no problem, but I can't use transaction. :( Well, I use native
MSSQL driver (OLEDB) to connect to my fake server.

Real SQL Server (name=FANTOM) make login to my fake server
(name=LIBRARY2) :

host='FANTOM', user='sa', passw='test', app='Microsoft SQL S',
server='LIBRARY2', vers='4.2', library='OLEDB lang='', charset='',
blocksize='4096'

No problem, I send some ... then login_ack, then real mssql server connect
to my fake sqlserver again :


Receiving header packet @ 2000-12-14 02:29:45
0000  10 01 00 e5 00 00 01 00                           |........|

Receiving packet @ 2000-12-14 02:29:45
0000  dd 00 00 00 00 00 00 70 00 10 00 00 00 00 00 06   |.......p........|
0010  d8 00 00 00 00 00 00 00 e0 03 10 00 4c ff ff ff   |............L...|
0020  19 04 00 00 56 00 06 00 62 00 02 00 66 00 04 00   |....V...b...f...|
0030  6e 00 14 00 96 00 08 00 00 00 00 00 a6 00 05 00   |n...............|
0040  b0 00 00 00 b0 00 00 00 00 60 08 0b 2f 70 b0 00   |.........`../p..|
0050  2d 00 dd 00 00 00 46 00 41 00 4e 00 54 00 4f 00   |-.....F.A.N.T.O.|
0060  4d 00 73 00 61 00 e2 a5 f3 a5 92 a5 e2 a5 4d 00   |M.s.a.........M.|
0070  69 00 63 00 72 00 6f 00 73 00 6f 00 66 00 74 00   |i.c.r.o.s.o.f.t.|
0080  20 00 53 00 51 00 4c 00 20 00 53 00 65 00 72 00   | .S.Q.L. .S.e.r.|
0090  76 00 65 00 72 00 4c 00 49 00 42 00 52 00 41 00   |v.e.r.L.I.B.R.A.|
00a0  52 00 59 00 32 00 4f 00 4c 00 45 00 44 00 42 00   |R.Y.2.O.L.E.D.B.|
00b0  4e 54 4c 4d 53 53 50 00 01 00 00 00 07 b2 00 00   |NTLMSSP.........|
00c0  07 00 07 00 26 00 00 00 06 00 06 00 20 00 00 00   |....&....... ...|
00d0  46 41 4e 54 4f 4d 43 45 4e 54 52 41 4c            |FANTOMCENTRAL|

What is this ? Login procedure in TDS 7.0 style ???

Best regards, Nil.
E-Mail: nil AT internet2.ru