freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Freetds + Unixodbc + PHP

From: "J. 'FIK' Brand" <jurgen.brand AT tip.nl>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Subject: Re: Freetds + Unixodbc + PHP
Date: Wed, 5 Dec 2001 14:33:24 +0100

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')
>

Freetds + Unixodbc + PHP, J. 'FIK' Brand, 12/03/2001
- <Possible follow-up(s)>
- Re: Freetds + Unixodbc + PHP, Brian Bruns, 12/03/2001
- Re: Freetds + Unixodbc + PHP, J. 'FIK' Brand, 12/03/2001
- Re: Freetds + Unixodbc + PHP, Brian Bruns, 12/03/2001
- Re: Freetds + Unixodbc + PHP, J. 'FIK' Brand, 12/04/2001
- Freetds + Unixodbc + PHP, J. 'FIK' Brand, 12/05/2001
- Re: Freetds + Unixodbc + PHP, Brian Bruns, 12/05/2001
- Re: Freetds + Unixodbc + PHP, J. 'FIK' Brand, 12/05/2001
- Re: Freetds + Unixodbc + PHP, J. 'FIK' Brand, 12/05/2001