Freetds + Unixodbc + PHP

J. 'FIK' Brand jurgen.brand at tip.nl
Wed Dec 5 08:33:24 EST 2001


My solution for the multuple sql statment problem was to run this statment
before the odbc_exec ;

    while (odbc_fetch_rec($rec));

This makes sure the all the rows are fetched.

Now for the char/varchar problem;

table d043 layout ;
    nummer smallint,
    omschrijving char(40)

PHP code ;
 $Conn= odbc_connect ("pretech","www","www")
  or die ("Can't open ODBC-DSN");
 $Rec = odbc_exec ( $Conn, "select nummer, omschrijving from d043")
  or die ("Can't execute QUERY");

isql command ;
    select nummer, omschrijving from d043

The isql command works, the php script not, i used DBG PHP debugger to check
where the script stops, is't at the odbc_exec commando.

Jurgen


--DUMP ISQL--
2001-12-05 14:22:03 Connecting addr 192.168.1.1 port 1433
2001-12-05 14:22:03 inside tds_process_login_tokens()
Received packet @ 2001-12-05 14:22:03
0000  e3 13 00 01 02 70 00 74 00 06 6d 00 61 00 73 00   |.....p.t..m.a.s.|
0010  74 00 65 00 72 00 ab 58 00 45 16 00 00 02 00 21   |t.e.r..X.E.....!|
0020  00 43 00 68 00 61 00 6e 00 67 00 65 00 64 00 20   |.C.h.a.n.g.e.d. |
0030  00 64 00 61 00 74 00 61 00 62 00 61 00 73 00 65   |.d.a.t.a.b.a.s.e|
0040  00 20 00 63 00 6f 00 6e 00 74 00 65 00 78 00 74   |. .c.o.n.t.e.x.t|
0050  00 20 00 74 00 6f 00 20 00 27 00 70 00 74 00 27   |. .t.o. .'.p.t.'|
0060  00 2e 00 05 53 00 4d 00 49 00 54 00 53 00 00 00   |....S.M.I.T.S...|
0070  00 e3 17 00 02 0a 75 00 73 00 5f 00 65 00 6e 00   |......u.s._.e.n.|
0080  67 00 6c 00 69 00 73 00 68 00 00 ab 64 00 47 16   |g.l.i.s.h...d.G.|
0090  00 00 01 00 27 00 43 00 68 00 61 00 6e 00 67 00   |....'.C.h.a.n.g.|
00a0  65 00 64 00 20 00 6c 00 61 00 6e 00 67 00 75 00   |e.d. .l.a.n.g.u.|
00b0  61 00 67 00 65 00 20 00 73 00 65 00 74 00 74 00   |a.g.e. .s.e.t.t.|
00c0  69 00 6e 00 67 00 20 00 74 00 6f 00 20 00 75 00   |i.n.g. .t.o. .u.|
00d0  73 00 5f 00 65 00 6e 00 67 00 6c 00 69 00 73 00   |s._.e.n.g.l.i.s.|
00e0  68 00 2e 00 05 53 00 4d 00 49 00 54 00 53 00 00   |h....S.M.I.T.S..|
00f0  00 00 e3 0f 00 03 05 69 00 73 00 6f 00 5f 00 31   |.......i.s.o._.1|
0100  00 01 00 00 e3 0b 00 05 04 31 00 30 00 33 00 33   |.........1.0.3.3|
0110  00 00 e3 0f 00 06 06 31 00 39 00 36 00 36 00 30   |.......1.9.6.6.0|
0120  00 39 00 00 ad 36 00 01 07 00 00 00 16 4d 00 69   |.9...6.......M.i|
0130  00 63 00 72 00 6f 00 73 00 6f 00 66 00 74 00 20   |.c.r.o.s.o.f.t. |
0140  00 53 00 51 00 4c 00 20 00 53 00 65 00 72 00 76   |.S.Q.L. .S.e.r.v|
0150  00 65 00 72 00 00 00 00 00 07 00 03 c1 e3 13 00   |.e.r............|
0160  04 04 34 00 30 00 39 00 36 00 04 34 00 30 00 39   |..4.0.9.6..4.0.9|
0170  00 36 00 fd 00 00 00 00 00 00 00 00               |.6..........|


2001-12-05 14:22:03 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:03 inside tds_process_default_tokens() marker is ab
2001-12-05 14:22:03 Msg 5701, Level 0, State 2, Server SMITS, Line 0
Changed database context to 'pt'.
2001-12-05 14:22:03 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:03 inside tds_process_default_tokens() marker is ab
2001-12-05 14:22:03 Msg 5703, Level 0, State 1, Server SMITS, Line 0
Changed language setting to us_english.
2001-12-05 14:22:03 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:03 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:03 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:03 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:03 increasing block size from 4096 to 4096
2001-12-05 14:22:03 inside tds_process_default_tokens() marker is fd
2001-12-05 14:22:03 leaving tds_process_login_tokens() returning 1
Sending packet @ 2001-12-05 14:22:03
0000  01 01 00 14 00 00 01 00 75 00 73 00 65 00 20 00   |........u.s.e. .|
0010  70 00 74 00                                       |p.t.|


Received packet @ 2001-12-05 14:22:03
0000  e3 0b 00 01 02 70 00 74 00 02 70 00 74 00 ab 58   |.....p.t..p.t..X|
0010  00 45 16 00 00 01 00 21 00 43 00 68 00 61 00 6e   |.E.....!.C.h.a.n|
0020  00 67 00 65 00 64 00 20 00 64 00 61 00 74 00 61   |.g.e.d. .d.a.t.a|
0030  00 62 00 61 00 73 00 65 00 20 00 63 00 6f 00 6e   |.b.a.s.e. .c.o.n|
0040  00 74 00 65 00 78 00 74 00 20 00 74 00 6f 00 20   |.t.e.x.t. .t.o. |
0050  00 27 00 70 00 74 00 27 00 2e 00 05 53 00 4d 00   |.'.p.t.'....S.M.|
0060  49 00 54 00 53 00 00 01 00 fd 00 00 e2 00 00 00   |I.T.S...........|
0070  00 00                                             |..|


2001-12-05 14:22:03 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:03 inside tds_process_default_tokens() marker is ab
2001-12-05 14:22:03 Msg 5701, Level 0, State 1, Server SMITS, Line 1
Changed database context to 'pt'.
2001-12-05 14:22:03 inside tds_process_default_tokens() marker is fd
SQLGetFunctions: fFunction is 999
Sending packet @ 2001-12-05 14:22:16
0000  01 01 00 52 00 00 01 00 73 00 65 00 6c 00 65 00   |...R....s.e.l.e.|
0010  63 00 74 00 20 00 6e 00 75 00 6d 00 6d 00 65 00   |c.t. .n.u.m.m.e.|
0020  72 00 2c 00 20 00 6f 00 6d 00 73 00 63 00 68 00   |r.,. .o.m.s.c.h.|
0030  72 00 69 00 6a 00 76 00 69 00 6e 00 67 00 20 00   |r.i.j.v.i.n.g. .|
0040  66 00 72 00 6f 00 6d 00 20 00 64 00 30 00 34 00   |f.r.o.m. .d.0.4.|
0050  33 00                                             |3.|


Received packet @ 2001-12-05 14:22:16
0000  81 02 00 00 00 09 00 26 02 06 6e 00 75 00 6d 00   |.......&..n.u.m.|
0010  6d 00 65 00 72 00 00 00 09 00 af 28 00 0c 6f 00   |m.e.r.....¯(..o.|
0020  6d 00 73 00 63 00 68 00 72 00 69 00 6a 00 76 00   |m.s.c.h.r.i.j.v.|
0030  69 00 6e 00 67 00 d1 02 01 00 28 00 41 61 6e 6e   |i.n.g.Ñ...(.Aann|
0040  65 6d 65 72 20 20 20 20 20 20 20 20 20 20 20 20   |emer            |
0050  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0060  20 20 20 20 d1 02 02 00 28 00 41 72 63 68 69 74   |    Ñ...(.Archit|
0070  65 63 74 20 20 20 20 20 20 20 20 20 20 20 20 20   |ect             |
0080  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0090  20 20 d1 02 03 00 28 00 44 65 61 6c 65 72 20 20   |  Ñ...(.Dealer  |
00a0  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
00b0  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
00c0  d1 02 04 00 28 00 50 72 6f 6a 65 63 74 6f 6e 74   |Ñ...(.Projectont|
00d0  77 69 6b 6b 65 6c 61 61 72 20 20 20 20 20 20 20   |wikkelaar       |
00e0  20 20 20 20 20 20 20 20 20 20 20 20 20 20 d1 02   |              Ñ.|
00f0  05 00 28 00 4f 76 65 72 68 65 69 64 73 69 6e 73   |..(.Overheidsins|
0100  74 65 6c 6c 69 6e 67 20 20 20 20 20 20 20 20 20   |telling         |
0110  20 20 20 20 20 20 20 20 20 20 20 20 d1 02 06 00   |            Ñ...|
0120  28 00 41 64 76 69 65 73 62 75 72 65 61 75 20 20   |(.Adviesbureau  |
0130  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0140  20 20 20 20 20 20 20 20 20 20 d1 02 07 00 28 00   |          Ñ...(.|
0150  43 6f 6c 6c 65 67 61 2d 63 6f 6e 63 75 72 72 65   |Collega-concurre|
0160  6e 74 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |nt              |
0170  20 20 20 20 20 20 20 20 d1 02 08 00 28 00 50 61   |        Ñ...(.Pa|
0180  72 74 69 63 75 6c 69 65 72 20 20 20 20 20 20 20   |rticulier       |
0190  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
01a0  20 20 20 20 20 20 d1 02 09 00 28 00 50 72 6f 66   |      Ñ...(.Prof|
01b0  69 65 6c 6c 65 76 65 72 61 6e 63 69 65 72 20 20   |ielleverancier  |
01c0  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
01d0  20 20 20 20 d1 02 0a 00 28 00 54 6f 65 62 65 68   |    Ñ...(.Toebeh|
01e0  6f 72 65 6e 2d 6c 65 76 65 72 61 6e 63 69 65 72   |oren-leverancier|
01f0  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0200  20 20 d1 02 0b 00 28 00 4f 76 65 72 69 67 65 20   |  Ñ...(.Overige |
0210  6c 65 76 65 72 61 6e 63 69 65 72 20 20 20 20 20   |leverancier     |
0220  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0230  d1 02 0c 00 28 00 4f 76 65 72 69 67 65 20 20 20   |Ñ...(.Overige   |
0240  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0250  20 20 20 20 20 20 20 20 20 20 20 20 20 20 d1 02   |              Ñ.|
0260  ff ff 28 00 47 65 65 6e 20 20 20 20 20 20 20 20   |ÿÿ(.Geen        |
0270  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0280  20 20 20 20 20 20 20 20 20 20 20 20 fd 10 00 c1   |            ý..Á|
0290  00 0d 00 00 00                                    |.....|


2001-12-05 14:22:16 processing result tokens.  marker is  81
2001-12-05 14:22:16 processing result tokens.  marker is  d1
SQLColAttributes: fDescType is 6
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
SQLColAttributes: fDescType is 18
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = 1
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string =
Aannemer
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = 2
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string =
Architect
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = 3
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = Dealer
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = 4
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string =
Projectontwikkelaar
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = 5
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string =
Overheidsinstelling
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = 6
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string =
Adviesbureau
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = 7
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string =
Collega-concurrent
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = 8
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string =
Particulier
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = 9
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string =
Profielleverancier
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = 10
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string =
Toebehoren-leverancier
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = 11
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = Overige
leverancier
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = 12
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = Overige
2001-12-05 14:22:16 processing row tokens.  marker is  d1
2001-12-05 14:22:16 clearing column 0 NULL bit
2001-12-05 14:22:16 clearing column 1 NULL bit
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = -1
SQLColAttributes: fDescType is 18
SQLColAttributes: fDescType is 6
2001-12-05 14:22:16 converting string dlen = 301 dtype = 47 string = Geen
2001-12-05 14:22:16 processing row tokens.  marker is  fd


--DUMP PHP-PAGE--
2001-12-05 14:22:50 Connecting addr 192.168.1.1 port 1433
2001-12-05 14:22:50 inside tds_process_login_tokens()
Received packet @ 2001-12-05 14:22:50
0000  e3 13 00 01 02 70 00 74 00 06 6d 00 61 00 73 00   |ã....p.t..m.a.s.|
0010  74 00 65 00 72 00 ab 58 00 45 16 00 00 02 00 21   |t.e.r.«X.E.....!|
0020  00 43 00 68 00 61 00 6e 00 67 00 65 00 64 00 20   |.C.h.a.n.g.e.d. |
0030  00 64 00 61 00 74 00 61 00 62 00 61 00 73 00 65   |.d.a.t.a.b.a.s.e|
0040  00 20 00 63 00 6f 00 6e 00 74 00 65 00 78 00 74   |. .c.o.n.t.e.x.t|
0050  00 20 00 74 00 6f 00 20 00 27 00 70 00 74 00 27   |. .t.o. .'.p.t.'|
0060  00 2e 00 05 53 00 4d 00 49 00 54 00 53 00 00 00   |....S.M.I.T.S...|
0070  00 e3 17 00 02 0a 75 00 73 00 5f 00 65 00 6e 00   |.ã....u.s._.e.n.|
0080  67 00 6c 00 69 00 73 00 68 00 00 ab 64 00 47 16   |g.l.i.s.h..«d.G.|
0090  00 00 01 00 27 00 43 00 68 00 61 00 6e 00 67 00   |....'.C.h.a.n.g.|
00a0  65 00 64 00 20 00 6c 00 61 00 6e 00 67 00 75 00   |e.d. .l.a.n.g.u.|
00b0  61 00 67 00 65 00 20 00 73 00 65 00 74 00 74 00   |a.g.e. .s.e.t.t.|
00c0  69 00 6e 00 67 00 20 00 74 00 6f 00 20 00 75 00   |i.n.g. .t.o. .u.|
00d0  73 00 5f 00 65 00 6e 00 67 00 6c 00 69 00 73 00   |s._.e.n.g.l.i.s.|
00e0  68 00 2e 00 05 53 00 4d 00 49 00 54 00 53 00 00   |h....S.M.I.T.S..|
00f0  00 00 e3 0f 00 03 05 69 00 73 00 6f 00 5f 00 31   |..ã....i.s.o._.1|
0100  00 01 00 00 e3 0b 00 05 04 31 00 30 00 33 00 33   |....ã....1.0.3.3|
0110  00 00 e3 0f 00 06 06 31 00 39 00 36 00 36 00 30   |..ã....1.9.6.6.0|
0120  00 39 00 00 ad 36 00 01 07 00 00 00 16 4d 00 69   |.9..­6.......M.i|
0130  00 63 00 72 00 6f 00 73 00 6f 00 66 00 74 00 20   |.c.r.o.s.o.f.t. |
0140  00 53 00 51 00 4c 00 20 00 53 00 65 00 72 00 76   |.S.Q.L. .S.e.r.v|
0150  00 65 00 72 00 00 00 00 00 07 00 03 c1 e3 13 00   |.e.r........Áã..|
0160  04 04 34 00 30 00 39 00 36 00 04 34 00 30 00 39   |..4.0.9.6..4.0.9|
0170  00 36 00 fd 00 00 00 00 00 00 00 00               |.6.ý........|


2001-12-05 14:22:50 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:50 inside tds_process_default_tokens() marker is ab
2001-12-05 14:22:50 Msg 5701, Level 0, State 2, Server SMITS, Line 0
Changed database context to 'pt'.
2001-12-05 14:22:50 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:50 inside tds_process_default_tokens() marker is ab
2001-12-05 14:22:50 Msg 5703, Level 0, State 1, Server SMITS, Line 0
Changed language setting to us_english.
2001-12-05 14:22:50 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:50 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:50 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:50 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:50 increasing block size from 4096 to 4096
2001-12-05 14:22:50 inside tds_process_default_tokens() marker is fd
2001-12-05 14:22:50 leaving tds_process_login_tokens() returning 1
Sending packet @ 2001-12-05 14:22:50
0000  01 01 00 14 00 00 01 00 75 00 73 00 65 00 20 00   |........u.s.e. .|
0010  70 00 74 00                                       |p.t.|


Received packet @ 2001-12-05 14:22:50
0000  e3 0b 00 01 02 70 00 74 00 02 70 00 74 00 ab 58   |ã....p.t..p.t.«X|
0010  00 45 16 00 00 01 00 21 00 43 00 68 00 61 00 6e   |.E.....!.C.h.a.n|
0020  00 67 00 65 00 64 00 20 00 64 00 61 00 74 00 61   |.g.e.d. .d.a.t.a|
0030  00 62 00 61 00 73 00 65 00 20 00 63 00 6f 00 6e   |.b.a.s.e. .c.o.n|
0040  00 74 00 65 00 78 00 74 00 20 00 74 00 6f 00 20   |.t.e.x.t. .t.o. |
0050  00 27 00 70 00 74 00 27 00 2e 00 05 53 00 4d 00   |.'.p.t.'....S.M.|
0060  49 00 54 00 53 00 00 01 00 fd 00 00 e2 00 00 00   |I.T.S....ý..â...|
0070  00 00                                             |..|


2001-12-05 14:22:50 inside tds_process_default_tokens() marker is e3
2001-12-05 14:22:50 inside tds_process_default_tokens() marker is ab
2001-12-05 14:22:50 Msg 5701, Level 0, State 1, Server SMITS, Line 1
Changed database context to 'pt'.
2001-12-05 14:22:50 inside tds_process_default_tokens() marker is fd
SQLGetFunctions: fFunction is 999
Sending packet @ 2001-12-05 14:22:50
0000  01 01 00 52 00 00 01 00 73 00 65 00 6c 00 65 00   |...R....s.e.l.e.|
0010  63 00 74 00 20 00 6e 00 75 00 6d 00 6d 00 65 00   |c.t. .n.u.m.m.e.|
0020  72 00 2c 00 20 00 6f 00 6d 00 73 00 63 00 68 00   |r.,. .o.m.s.c.h.|
0030  72 00 69 00 6a 00 76 00 69 00 6e 00 67 00 20 00   |r.i.j.v.i.n.g. .|
0040  66 00 72 00 6f 00 6d 00 20 00 64 00 30 00 34 00   |f.r.o.m. .d.0.4.|
0050  33 00                                             |3.|


Received packet @ 2001-12-05 14:22:50
0000  81 02 00 00 00 09 00 26 02 06 6e 00 75 00 6d 00   |.......&..n.u.m.|
0010  6d 00 65 00 72 00 00 00 09 00 af 28 00 0c 6f 00   |m.e.r.....¯(..o.|
0020  6d 00 73 00 63 00 68 00 72 00 69 00 6a 00 76 00   |m.s.c.h.r.i.j.v.|
0030  69 00 6e 00 67 00 d1 02 01 00 28 00 41 61 6e 6e   |i.n.g.Ñ...(.Aann|
0040  65 6d 65 72 20 20 20 20 20 20 20 20 20 20 20 20   |emer            |
0050  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0060  20 20 20 20 d1 02 02 00 28 00 41 72 63 68 69 74   |    Ñ...(.Archit|
0070  65 63 74 20 20 20 20 20 20 20 20 20 20 20 20 20   |ect             |
0080  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0090  20 20 d1 02 03 00 28 00 44 65 61 6c 65 72 20 20   |  Ñ...(.Dealer  |
00a0  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
00b0  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
00c0  d1 02 04 00 28 00 50 72 6f 6a 65 63 74 6f 6e 74   |Ñ...(.Projectont|
00d0  77 69 6b 6b 65 6c 61 61 72 20 20 20 20 20 20 20   |wikkelaar       |
00e0  20 20 20 20 20 20 20 20 20 20 20 20 20 20 d1 02   |              Ñ.|
00f0  05 00 28 00 4f 76 65 72 68 65 69 64 73 69 6e 73   |..(.Overheidsins|
0100  74 65 6c 6c 69 6e 67 20 20 20 20 20 20 20 20 20   |telling         |
0110  20 20 20 20 20 20 20 20 20 20 20 20 d1 02 06 00   |            Ñ...|
0120  28 00 41 64 76 69 65 73 62 75 72 65 61 75 20 20   |(.Adviesbureau  |
0130  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0140  20 20 20 20 20 20 20 20 20 20 d1 02 07 00 28 00   |          Ñ...(.|
0150  43 6f 6c 6c 65 67 61 2d 63 6f 6e 63 75 72 72 65   |Collega-concurre|
0160  6e 74 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |nt              |
0170  20 20 20 20 20 20 20 20 d1 02 08 00 28 00 50 61   |        Ñ...(.Pa|
0180  72 74 69 63 75 6c 69 65 72 20 20 20 20 20 20 20   |rticulier       |
0190  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
01a0  20 20 20 20 20 20 d1 02 09 00 28 00 50 72 6f 66   |      Ñ...(.Prof|
01b0  69 65 6c 6c 65 76 65 72 61 6e 63 69 65 72 20 20   |ielleverancier  |
01c0  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
01d0  20 20 20 20 d1 02 0a 00 28 00 54 6f 65 62 65 68   |    Ñ...(.Toebeh|
01e0  6f 72 65 6e 2d 6c 65 76 65 72 61 6e 63 69 65 72   |oren-leverancier|
01f0  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0200  20 20 d1 02 0b 00 28 00 4f 76 65 72 69 67 65 20   |  Ñ...(.Overige |
0210  6c 65 76 65 72 61 6e 63 69 65 72 20 20 20 20 20   |leverancier     |
0220  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0230  d1 02 0c 00 28 00 4f 76 65 72 69 67 65 20 20 20   |Ñ...(.Overige   |
0240  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0250  20 20 20 20 20 20 20 20 20 20 20 20 20 20 d1 02   |              Ñ.|
0260  ff ff 28 00 47 65 65 6e 20 20 20 20 20 20 20 20   |ÿÿ(.Geen        |
0270  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20   |                |
0280  20 20 20 20 20 20 20 20 20 20 20 20 fd 10 00 c1   |            ý..Á|
0290  00 0d 00 00 00                                    |.....|


2001-12-05 14:22:50 processing result tokens.  marker is  81
2001-12-05 14:22:50 processing result tokens.  marker is  d1
SQLColAttributes: fDescType is 1
SQLColAttributes: copying 6 bytes, len = 6, cbDescMax = 32
SQLColAttributes: fDescType is 2
SQLColAttributes: fDescType is 6




----- Original Message -----
From: "Brian Bruns" <camber at ais.org>
To: "TDS Development Group" <freetds at franklin.oit.unc.edu>
Sent: Wednesday, December 05, 2001 2:07 PM
Subject: [freetds] Re: Freetds + Unixodbc + PHP


> On Wed, 5 Dec 2001, J. 'FIK' Brand wrote:
>
> > I've got freetds to work, even multiple sql-statments on the same
connection.
>
> BTW, what was the final solution to your multiple sql statement problem?
>
> > Now my next problem;
> >
> > the commando odbc_exec crashes when executeing a sql-statment that uses
a table with collumn defined as varchar.
>
> Ok, this is really odd.  I've done this many times.  Care to post a tds
> log file of it happening?
>
> > Jurgen
> >
> >
>
> Brian
>
>
> ---
> You are currently subscribed to freetds as: [jurgen.brand at tip.nl]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>




More information about the FreeTDS mailing list