FreeTDS Development Group

["Patrick Dunnigan" <patrick.dunnigan AT centivia.com>]

I believe that you'll need a

dbresults(dbproc);

after the line that does
dbsqlexec (dbproc);

and before the bind.


----- Original Message ----- 
From: "steve" <freetds AT scaudio.co.uk>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Sent: Thursday, June 30, 2005 12:59 PM
Subject: [freetds] Attempt to bind to a non-existent column


Please help
I am a complete noobie to dblib and I am having a problem binding to the
result of a query. I am probably doing something obvious to you.
Thanks for your help

Steve


Tech details
Server MS SQL Server 7.0 on Win2k server
Client suse linux 9.1 on intel with FreeTDS 0.63

My source
--------------------------

#include <stdlib.h>
#include <string.h>
#include <sqlfront.h>
#include <sqldb.h>
#include <stdio.h>
#include <libgen.h>
#include <unistd.h>
#include <sys/param.h>
//#include <config.h>
int syb_msg_handler (DBPROCESS * dbproc, DBINT msgno,
int msgstate, int severity, char *msgtext, char *srvname,
char *procname, int line);
int syb_err_handler (DBPROCESS * dbproc, int severity, int dberr, int oserr,
     char *dberrstr, char *oserrstr);


int
main ()
{
LOGINREC *login;
DBPROCESS *dbproc;
DBINT testint;
DBCHAR name[60];


dbinit ();
dberrhandle(syb_err_handler);
dbmsghandle(syb_msg_handler);
login = dblogin ();
DBSETLPWD (login, "datamart");
DBSETLUSER (login, "datamart");
DBSETLAPP (login, "sc_test");

dbproc = dbopen (login, "talkie");
dbuse (dbproc, "dmdb");
dbcmd (dbproc, "select FullName from computer");
dbsqlexec (dbproc);
dbbind (dbproc, 1, NTBSTRINGBIND, 60, name);
while (dbnextrow (dbproc) != NO_MORE_ROWS)
{
printf ("The first field is %s\n", name);
}
dbexit ();
return (0);
}

int
syb_msg_handler(DBPROCESS * dbproc, DBINT msgno, int msgstate, int severity,
char *msgtext, char *srvname, char *procname, int line)
{
char var_value[31];
int i;
char *c;

/*
* Check for "database changed", or "language changed" messages from
* the client.  If we get one of these, then we need to pull the
* name of the database or charset from the message and set the
* appropriate variable.
*/
if (msgno == 5701 || /* database context change */
    msgno == 5703 || /* language changed */
    msgno == 5704) { /* charset changed */

/* fprintf( stderr, "msgno = %d: %s\n", msgno, msgtext ) ; */

if (msgtext != NULL && (c = strchr(msgtext, '\'')) != NULL) {
i = 0;
for (++c; i <= 30 && *c != '\0' && *c != '\''; ++c)
var_value[i++] = *c;
var_value[i] = '\0';

#if 0
switch (msgno) {
case 5701:
env_set(g_env, "database", var_value);
break;
case 5703:
env_set(g_env, "language", var_value);
break;
case 5704:
env_set(g_env, "charset", var_value);
-break;
default:
break;
}
#endif
}
return 0;
}

/*
* If the severity is something other than 0 or the msg number is
* 0 (user informational messages).
*/
if (severity >= 0 || msgno == 0) {
/*
* If the message was something other than informational, and
* the severity was greater than 0, then print information to
* stderr with a little pre-amble information.
*/
if (msgno > 0 && severity > 0) {
fprintf(stderr, "Msg %d, Level %d, State %d\n", (int) msgno, (int)
severity, (int) msgstate);
fprintf(stderr, "Server '%s'", srvname);
if (procname != NULL && *procname != '\0')
fprintf(stderr, ", Procedure '%s'", procname);
if (line > 0)
fprintf(stderr, ", Line %d", line);
fprintf(stderr, "\n");
fprintf(stderr, "%s\n", msgtext);
fflush(stderr);
} else {
/*
* Otherwise, it is just an informational (e.g. print) message
* from the server, so send it to stdout.
*/
fprintf(stdout, "%s\n", msgtext);
fflush(stdout);
}
}

return 0;
}


int
syb_err_handler (DBPROCESS * dbproc, int severity, int dberr, int oserr,
char *dberrstr, char *oserrstr)
{

/*
* For server messages, cancel the query and rely on the
* message handler to spew the appropriate error messages out.
*/
if (dberr == SYBESMSG)
return INT_CANCEL;

#if 0
/*
* For any other type of severity (that is not a server
* message), we increment the batch_failcount.
*/
env_set (g_env, "batch_failcount", "1");
#endif

fprintf (stderr,
"DB-LIBRARY error (severity %d, dberr %d, oserr %d, dberrstr %s, oserrstr
%s):\n",
severity, dberr, oserr, dberrstr ? dberrstr : "(null)",
oserrstr ? oserrstr : "(null)");
fflush (stderr);

/*
* If the dbprocess is dead or the dbproc is a NULL pointer and
* we are not in the middle of logging in, then we need to exit.
* We can't do anything from here on out anyway.
* It's OK to end up here in response to a dbconvert() that
* resulted in overflow, so don't exit in that case.
*/
if ((dbproc == NULL) || DBDEAD (dbproc))
{
if (dberr != SYBECOFL)
{
exit (255);
}
}

return INT_CANCEL;
}

-------------------------

17:51:47.328642 Starting log file for FreeTDS 0.63
on 2005-06-30 17:51:47 with debug level 99.
17:51:47.328868 names for ISO-8859-1: ISO-8859-1
17:51:47.328913 names for UTF-8: UTF-8
17:51:47.328952 names for UCS-2LE: UCS-2LE
17:51:47.328990 names for UCS-2BE: UCS-2BE
17:51:47.329028 iconv to convert client-side data to the "ISO-8859-1"
character set
17:51:47.329088 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
17:51:47.329154 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
17:51:47.329201 Connecting to 172.16.10.5 port 1433, TDS 7.0.
17:51:47.329570 tds_put_string converting 7 bytes of "emohawk"
17:51:47.329627 tds_put_string wrote 14 bytes
17:51:47.329666 tds_put_string converting 8 bytes of "datamart"
17:51:47.329705 tds_put_string wrote 16 bytes
17:51:47.329745 tds_put_string converting 7 bytes of "sc_test"
17:51:47.329784 tds_put_string wrote 14 bytes
17:51:47.329821 tds_put_string converting 6 bytes of "talkie"
17:51:47.329860 tds_put_string wrote 12 bytes
17:51:47.329897 tds_put_string converting 10 bytes of "DB-Library"
17:51:47.329936 tds_put_string wrote 20 bytes
17:51:47.329973 tds_put_string converting 10 bytes of "us_english"
17:51:47.330012 tds_put_string wrote 20 bytes
17:51:47.330049 tds_put_string wrote 0 bytes
17:51:47.330106 tds_process_login_tokens()
17:51:47.331317 Received header
0000 04 01 01 90 00 00 00 00-                        |........|

17:51:47.331341 Received packet
0000 e3 17 00 01 04 44 00 4d-00 44 00 42 00 06 6d 00 |.....D.M .D.B..m.|
0010 61 00 73 00 74 00 65 00-72 00 ab 5e 00 45 16 00 |a.s.t.e. r..^.E..|
0020 00 02 00 23 00 43 00 68-00 61 00 6e 00 67 00 65 |...#.C.h .a.n.g.e|
0030 00 64 00 20 00 64 00 61-00 74 00 61 00 62 00 61 |.d. .d.a .t.a.b.a|
0040 00 73 00 65 00 20 00 63-00 6f 00 6e 00 74 00 65 |.s.e. .c .o.n.t.e|
0050 00 78 00 74 00 20 00 74-00 6f 00 20 00 27 00 44 |.x.t. .t .o. .'.D|
0060 00 4d 00 44 00 42 00 27-00 2e 00 06 54 00 41 00 |.M.D.B.' ....T.A.|
0070 4c 00 4b 00 49 00 45 00-00 00 00 e3 17 00 02 0a |L.K.I.E. ........|
0080 75 00 73 00 5f 00 65 00-6e 00 67 00 6c 00 69 00 |u.s._.e. n.g.l.i.|
0090 73 00 68 00 00 ab 66 00-47 16 00 00 01 00 27 00 |s.h...f. G.....'.|
00a0 43 00 68 00 61 00 6e 00-67 00 65 00 64 00 20 00 |C.h.a.n. g.e.d. .|
00b0 6c 00 61 00 6e 00 67 00-75 00 61 00 67 00 65 00 |l.a.n.g. u.a.g.e.|
00c0 20 00 73 00 65 00 74 00-74 00 69 00 6e 00 67 00 | .s.e.t. t.i.n.g.|
00d0 20 00 74 00 6f 00 20 00-75 00 73 00 5f 00 65 00 | .t.o. . u.s._.e.|
00e0 6e 00 67 00 6c 00 69 00-73 00 68 00 2e 00 06 54 |n.g.l.i. s.h....T|
00f0 00 41 00 4c 00 4b 00 49-00 45 00 00 00 00 e3 0f |.A.L.K.I .E......|
0100 00 03 05 69 00 73 00 6f-00 5f 00 31 00 01 00 00 |...i.s.o ._.1....|
0110 e3 0b 00 05 04 31 00 30-00 33 00 33 00 00 e3 0f |.....1.0 .3.3....|
0120 00 06 06 31 00 39 00 36-00 36 00 30 00 39 00 00 |...1.9.6 .6.0.9..|
0130 ad 36 00 01 07 00 00 00-16 4d 00 69 00 63 00 72 |.6...... .M.i.c.r|
0140 00 6f 00 73 00 6f 00 66-00 74 00 20 00 53 00 51 |.o.s.o.f .t. .S.Q|
0150 00 4c 00 20 00 53 00 65-00 72 00 76 00 65 00 72 |.L. .S.e .r.v.e.r|
0160 00 00 00 00 00 07 00 03-c1 e3 13 00 04 04 34 00 |........ ......4.|
0170 30 00 39 00 36 00 04 34-00 30 00 39 00 36 00 fd |0.9.6..4 .0.9.6..|
0180 00 00 00 00 00 00 00 00-                        |........|

17:51:47.331555 looking for login token, got  e3(ENVCHANGE)
17:51:47.331602 tds_process_default_tokens() marker is e3(ENVCHANGE)
17:51:47.331644 tds_get_string: reading 8 from wire to give 4 to client.
17:51:47.331693 tds_get_string: reading 12 from wire to give 6 to client.
17:51:47.331737 looking for login token, got  ab(INFO)
17:51:47.331775 tds_process_default_tokens() marker is ab(INFO)
17:51:47.331815 tds_get_string: reading 70 from wire to give 35 to client.
17:51:47.331857 tds_get_string: reading 12 from wire to give 6 to client.
17:51:47.331905 looking for login token, got  e3(ENVCHANGE)
17:51:47.331944 tds_process_default_tokens() marker is e3(ENVCHANGE)
17:51:47.331983 tds_get_string: reading 20 from wire to give 10 to client.
17:51:47.332024 looking for login token, got  ab(INFO)
17:51:47.332062 tds_process_default_tokens() marker is ab(INFO)
17:51:47.332110 tds_get_string: reading 78 from wire to give 39 to client.
17:51:47.332152 tds_get_string: reading 12 from wire to give 6 to client.
17:51:47.332195 looking for login token, got  e3(ENVCHANGE)
17:51:47.332233 tds_process_default_tokens() marker is e3(ENVCHANGE)
17:51:47.332272 tds_get_string: reading 10 from wire to give 5 to client.
17:51:47.332312 tds_get_string: reading 2 from wire to give 1 to client.
17:51:47.332363 looking for login token, got  e3(ENVCHANGE)
17:51:47.332403 tds_process_default_tokens() marker is e3(ENVCHANGE)
17:51:47.332441 tds_get_string: reading 8 from wire to give 4 to client.
17:51:47.332492 looking for login token, got  e3(ENVCHANGE)
17:51:47.332531 tds_process_default_tokens() marker is e3(ENVCHANGE)
17:51:47.332570 tds_get_string: reading 12 from wire to give 6 to client.
17:51:47.332610 looking for login token, got  ad(LOGINACK)
17:51:47.332651 tds_get_string: reading 44 from wire to give 22 to client.
17:51:47.332691 looking for login token, got  e3(ENVCHANGE)
17:51:47.332729 tds_process_default_tokens() marker is e3(ENVCHANGE)
17:51:47.332767 tds_get_string: reading 8 from wire to give 4 to client.
17:51:47.332807 tds_get_string: reading 8 from wire to give 4 to client.
17:51:47.332848 increasing block size from 4096 to 4096
17:51:47.332895 looking for login token, got  fd(DONE)
17:51:47.332933 tds_process_default_tokens() marker is fd(DONE)
17:51:47.332971 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
17:51:47.333010 tds_process_end() state set to TDS_IDLE
17:51:47.333047 leaving tds_process_login_tokens() returning 1
17:51:47.333091 tds_free_all_results()
17:51:47.333129 tds_put_string converting 19 bytes of "set textsize 64512 "
17:51:47.333168 tds_put_string wrote 38 bytes
17:51:47.333206 Sending packet
0000 01 01 00 2e 00 00 01 00-73 00 65 00 74 00 20 00 |........ s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00       | .6.4.5. 1.2. .|

17:51:47.333639 Received header
0000 04 01 00 11 00 00 00 00-                        |........|

17:51:47.333651 Received packet
0000 fd 00 00 be 00 00 00 00-00                      |........ .|

17:51:47.333659 processing result tokens.  marker is  fd(DONE)
17:51:47.333700 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
17:51:47.333738 tds_process_end() state set to TDS_IDLE
17:51:47.333776 tds_process_result_tokens() state is COMPLETED
17:51:47.333820 dbuse()
17:51:47.333864 dbcmd() bufsz = 0
17:51:47.333905 in dbsqlexec()
17:51:47.333943 in dbsqlsend()
17:51:47.333979 tds_free_all_results()
17:51:47.334017 tds_put_string converting 8 bytes of "use dmdb"
17:51:47.334055 tds_put_string wrote 16 bytes
17:51:47.334092 Sending packet
0000 01 01 00 18 00 00 01 00-75 00 73 00 65 00 20 00 |........ u.s.e. .|
0010 64 00 6d 00 64 00 62 00-                        |d.m.d.b.|

17:51:47.334118 in dbsqlok()
17:51:47.334665 Received header
0000 04 01 00 88 00 00 00 00-                        |........|

17:51:47.334679 Received packet
0000 e3 13 00 01 04 44 00 4d-00 44 00 42 00 04 44 00 |.....D.M .D.B..D.|
0010 4d 00 44 00 42 00 ab 5e-00 45 16 00 00 01 00 23 |M.D.B..^ .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 44 00 4d 00 44 |. .t.o.  .'.D.M.D|
0060 00 42 00 27 00 2e 00 06-54 00 41 00 4c 00 4b 00 |.B.'.... T.A.L.K.|
0070 49 00 45 00 00 01 00 fd-00 00 e2 00 00 00 00 00 |I.E..... ........|

17:51:47.334723 dbsqlok() marker is e3
17:51:47.334762 processing result tokens.  marker is  e3(ENVCHANGE)
17:51:47.334800 tds_process_default_tokens() marker is e3(ENVCHANGE)
17:51:47.334838 tds_get_string: reading 8 from wire to give 4 to client.
17:51:47.334878 tds_get_string: reading 8 from wire to give 4 to client.
17:51:47.334919 processing result tokens.  marker is  ab(INFO)
17:51:47.334965 tds_process_default_tokens() marker is ab(INFO)
17:51:47.335004 tds_get_string: reading 70 from wire to give 35 to client.
17:51:47.335045 tds_get_string: reading 12 from wire to give 6 to client.
17:51:47.335089 processing result tokens.  marker is  fd(DONE)
17:51:47.335128 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
17:51:47.335166 tds_process_end() state set to TDS_IDLE
17:51:47.335203 dbsqlok() end status was success
17:51:47.335241 dbresults()
17:51:47.335279 tds_process_row_tokens() state is COMPLETED
17:51:47.335318 dbcmd() bufsz = 9
17:51:47.335355 in dbfreebuf()
17:51:47.335395 in dbsqlexec()
17:51:47.335432 in dbsqlsend()
17:51:47.335479 tds_free_all_results()
17:51:47.335516 tds_put_string converting 29 bytes of "select FullName from
computer"
17:51:47.335556 tds_put_string wrote 58 bytes
17:51:47.335593 Sending packet
0000 01 01 00 42 00 00 01 00-73 00 65 00 6c 00 65 00 |...B.... s.e.l.e.|
0010 63 00 74 00 20 00 46 00-75 00 6c 00 6c 00 4e 00 |c.t. .F. u.l.l.N.|
0020 61 00 6d 00 65 00 20 00-66 00 72 00 6f 00 6d 00 |a.m.e. . f.r.o.m.|
0030 20 00 63 00 6f 00 6d 00-70 00 75 00 74 00 65 00 | .c.o.m. p.u.t.e.|
0040 72 00                  -                        |r.|

17:51:47.335633 in dbsqlok()
17:51:47.338465 Received header
0000 04 01 06 70 00 00 00 00-                        |...p....|

17:51:47.338488 Received packet
0000 81 01 00 00 00 09 00 af-3c 00 08 46 00 75 00 6c |........ <..F.u.l|
0010 00 6c 00 4e 00 61 00 6d-00 65 00 d1 0c 00 4b 65 |.l.N.a.m .e....Ke|
0020 76 69 6e 20 43 6c 61 72-6b 65 d1 ff ff d1 0b 00 |vin Clar ke......|
0030 49 61 6e 20 4c 61 6d 62-65 72 74 d1 0e 00 53 75 |Ian Lamb ert...Su|
0040 7a 61 6e 6e 65 20 48 65-77 69 74 74 d1 ff ff d1 |zanne He witt....|
0050 0c 00 49 61 6e 20 48 61-6d 69 6c 74 6f 6e d1 0b |..Ian Ha milton..|
0060 00 4e 69 63 6b 20 56 61-69 73 65 79 d1 ff ff d1 |.Nick Va isey....|
0070 ff ff d1 08 00 54 69 6d-20 43 61 6c 65 d1 0d 00 |.....Tim  Cale...|
0080 52 6f 62 65 72 74 20 56-61 6e 2d 45 73 d1 09 00 |Robert V an-Es...|
0090 52 65 63 65 70 74 69 6f-6e d1 ff ff d1 ff ff d1 |Receptio n.......|
00a0 ff ff d1 ff ff d1 ff ff-d1 ff ff d1 ff ff d1 0b |........ ........|
00b0 00 41 6c 61 6e 20 44 69-6d 65 72 79 d1 ff ff d1 |.Alan Di mery....|
00c0 ff ff d1 ff ff d1 0b 00-50 61 63 6b 69 6e 67 20 |........ Packing |
00d0 4f 6e 65 d1 0b 00 4e 69-67 65 6c 20 57 61 74 74 |One...Ni gel Watt|
00e0 73 d1 ff ff d1 ff ff d1-ff ff d1 ff ff d1 10 00 |s....... ........|
00f0 4b 61 74 72 69 6e 61 20-48 61 72 72 69 73 6f 6e |Katrina  Harrison|
0100 d1 0b 00 41 6c 61 6e 20-44 69 6d 65 72 79 d1 0d |...Alan  Dimery..|
0110 00 4d 61 67 67 69 65 20-4d 6f 6c 64 65 6e d1 0b |.Maggie  Molden..|
0120 00 47 61 69 6c 20 48 75-67 68 65 73 d1 09 00 4b |.Gail Hu ghes...K|
0130 65 76 69 6e 20 46 6f 78-d1 ff ff d1 08 00 54 69 |evin Fox ......Ti|
0140 6d 20 43 61 6c 65 d1 ff-ff d1 10 00 4d 61 72 74 |m Cale.. ....Mart|
0150 69 6e 20 4b 69 6e 67 73-63 6f 74 65 d1 0d 00 44 |in Kings cote...D|
0160 65 62 62 69 65 20 48 75-67 68 65 73 d1 0f 00 53 |ebbie Hu ghes...S|
0170 61 6e 64 72 61 20 54 69-6d 62 72 65 6c 6c d1 ff |andra Ti mbrell..|
0180 ff d1 ff ff d1 0f 00 43-61 72 6f 6c 69 6e 65 20 |.......C aroline |
0190 57 61 6c 6c 69 73 d1 0c-00 4b 65 76 69 6e 20 43 |Wallis.. .Kevin C|
01a0 6c 61 72 6b 65 d1 0a 00-53 74 65 76 65 20 43 6f |larke... Steve Co|
01b0 6c 65 d1 0a 00 53 68 61-75 6e 20 4c 61 6e 65 d1 |le...Sha un Lane.|
01c0 0a 00 44 65 65 6e 61 20-57 65 61 72 d1 0d 00 53 |..Deena  Wear...S|
01d0 68 61 72 6f 6e 20 50 6f-74 74 65 72 d1 ff ff d1 |haron Po tter....|
01e0 0c 00 4a 6f 68 6e 20 4f-27 4e 65 69 6c 6c d1 ff |..John O 'Neill..|
01f0 ff d1 0e 00 4a 6f 68 6e-20 43 75 6c 6c 69 6d 6f |....John  Cullimo|
0200 72 65 d1 0f 00 44 65 6e-69 73 65 20 4d 6f 77 62 |re...Den ise Mowb|
0210 65 72 72 79 d1 0d 00 52-6f 73 65 20 43 6f 72 72 |erry...R ose Corr|
0220 69 67 61 6e d1 0c 00 4b-61 74 68 79 20 46 69 73 |igan...K athy Fis|
0230 68 65 72 d1 ff ff d1 0c-00 4e 69 67 65 6c 20 41 |her..... .Nigel A|
0240 64 61 6d 6d 73 d1 ff ff-d1 ff ff d1 0a 00 54 69 |damms... ......Ti|
0250 6d 20 42 75 74 6c 65 72-d1 0c 00 47 72 61 68 61 |m Butler ...Graha|
0260 6d 20 54 75 64 6f 72 d1-0a 00 53 75 65 20 54 68 |m Tudor. ..Sue Th|
0270 6f 6d 61 73 d1 ff ff d1-0c 00 44 69 61 6e 61 20 |omas.... ..Diana |
0280 57 65 61 76 65 72 d1 0b-00 50 68 69 6c 20 44 6f |Weaver.. .Phil Do|
0290 77 6e 65 73 d1 0c 00 4b-65 6e 20 57 69 6c 6c 69 |wnes...K en Willi|
02a0 61 6d 73 d1 0b 00 50 61-75 6c 20 4d 61 72 6c 6f |ams...Pa ul Marlo|
02b0 77 d1 ff ff d1 0d 00 50-61 75 6c 20 57 6f 6f 64 |w......P aul Wood|
02c0 77 61 72 64 d1 08 00 45-6e 67 69 6e 65 65 72 d1 |ward...E ngineer.|
02d0 0c 00 47 6c 65 6e 20 4d-6f 75 6c 64 65 72 d1 09 |..Glen M oulder..|
02e0 00 4d 20 48 6f 70 6b 69-6e 73 d1 ff ff d1 ff ff |.M Hopki ns......|
02f0 d1 10 00 53 65 72 76 69-63 65 20 57 6f 72 6b 73 |...Servi ce Works|
0300 68 6f 70 d1 0c 00 41 76-69 20 4d 61 6c 68 6f 74 |hop...Av i Malhot|
0310 72 61 d1 ff ff d1 0c 00-4b 65 76 69 6e 20 43 6c |ra...... Kevin Cl|
0320 61 72 6b 65 d1 ff ff d1-0f 00 42 72 69 64 67 65 |arke.... ..Bridge|
0330 74 20 48 61 72 6e 64 65-6e d1 0e 00 52 69 63 68 |t Harnde n...Rich|
0340 61 72 64 20 48 6f 77 65-6c 6c d1 0f 00 53 68 61 |ard Howe ll...Sha|
0350 72 6f 6e 20 53 74 65 70-68 65 6e 73 d1 ff ff d1 |ron Step hens....|
0360 11 00 42 61 72 72 69 6e-67 74 6f 6e 20 48 65 73 |..Barrin gton Hes|
0370 6c 6f 70 d1 0b 00 4b 65-69 74 68 20 42 61 6b 65 |lop...Ke ith Bake|
0380 72 d1 ff ff d1 0f 00 43-68 72 69 73 20 4d 61 6e |r......C hris Man|
0390 73 66 69 65 6c 64 d1 0e-00 4e 69 63 6b 20 42 72 |sfield.. .Nick Br|
03a0 69 67 68 74 6d 61 6e d1-0a 00 44 65 65 6e 61 20 |ightman. ..Deena |
03b0 57 65 61 72 d1 0a 00 50-68 69 6c 20 4a 61 6d 65 |Wear...P hil Jame|
03c0 73 d1 09 00 54 6f 6e 79-20 53 6b 61 6c d1 0a 00 |s...Tony  Skal...|
03d0 41 6c 61 6e 20 46 72 79-65 72 d1 0c 00 4d 69 69 |Alan Fry er...Mii|
03e0 61 20 53 63 61 6d 61 6e-73 d1 0f 00 50 68 69 6c |a Scaman s...Phil|
03f0 6c 69 70 20 48 61 77 6b-69 6e 73 d1 0a 00 52 6f |lip Hawk ins...Ro|
0400 73 20 4d 61 72 74 69 6e-d1 0c 00 52 6f 6c 61 6e |s Martin ...Rolan|
0410 64 20 53 6d 69 74 68 d1-0b 00 44 61 76 69 64 20 |d Smith. ..David |
0420 42 72 6f 77 6e d1 0e 00-41 6c 69 73 6f 6e 20 52 |Brown... Alison R|
0430 69 63 68 69 6e 73 d1 ff-ff d1 0c 00 44 61 76 69 |ichins.. ....Davi|
0440 64 20 4d 61 63 6b 61 79-d1 09 00 50 61 74 20 43 |d Mackay ...Pat C|
0450 6f 6d 65 72 d1 09 00 44-61 76 65 20 4b 69 6e 67 |omer...D ave King|
0460 d1 09 00 54 6f 6e 79 20-44 79 65 72 d1 10 00 4b |...Tony  Dyer...K|
0470 65 76 69 6e 20 52 6f 61-64 6b 6e 69 67 68 74 d1 |evin Roa dknight.|
0480 0e 00 41 6e 64 79 20 52-6f 73 65 62 6c 61 64 65 |..Andy R oseblade|
0490 d1 0b 00 44 61 76 65 20-48 6f 77 61 72 64 d1 0c |...Dave  Howard..|
04a0 00 4a 6f 6e 20 53 61 70-73 66 6f 72 64 d1 0c 00 |.Jon Sap sford...|
04b0 44 61 76 65 20 54 72 6f-74 6d 61 6e d1 ff ff d1 |Dave Tro tman....|
04c0 ff ff d1 ff ff d1 ff ff-d1 0e 00 4b 65 72 72 79 |........ ...Kerry|
04d0 20 53 74 65 70 68 65 6e-73 d1 0b 00 54 6f 6e 79 | Stephen s...Tony|
04e0 20 46 65 6e 74 6f 6e d1-0d 00 4d 61 72 74 69 6e | Fenton. ..Martin|
04f0 20 4d 63 44 61 64 65 d1-11 00 4d 69 63 68 61 65 | McDade. ..Michae|
0500 6c 20 4a 6f 68 6e 73 74-72 75 70 d1 0b 00 50 61 |l Johnst rup...Pa|
0510 75 6c 20 57 69 6c 6b 65-73 d1 0a 00 4a 6f 68 6e |ul Wilke s...John|
0520 20 57 69 6c 6c 73 d1 0d-00 41 6c 69 73 6f 6e 20 | Wills.. .Alison |
0530 52 75 74 74 65 72 d1 0b-00 52 6f 62 65 72 74 20 |Rutter.. .Robert |
0540 42 65 6c 6c d1 ff ff d1-0b 00 54 6f 6e 79 20 46 |Bell.... ..Tony F|
0550 65 6e 74 6f 6e d1 09 00-50 61 75 6c 20 4d 61 6e |enton... Paul Man|
0560 6e d1 0b 00 44 61 76 65-20 57 61 6c 6b 65 72 d1 |n...Dave  Walker.|
0570 ff ff d1 0a 00 53 74 65-76 65 20 43 6f 6c 65 d1 |.....Ste ve Cole.|
0580 09 00 76 6d 73 76 69 65-77 65 72 d1 0d 00 41 6e |..vmsvie wer...An|
0590 6e 65 20 43 68 65 73 68-69 72 65 d1 0c 00 41 6e |ne Chesh ire...An|
05a0 74 6f 6e 20 4c 6f 62 61-63 68 d1 0d 00 53 61 72 |ton Loba ch...Sar|
05b0 61 68 20 44 69 61 6d 6f-6e 64 d1 ff ff d1 ff ff |ah Diamo nd......|
05c0 d1 09 00 4d 61 72 6b 65-74 69 6e 67 d1 0b 00 53 |...Marke ting...S|
05d0 75 65 20 53 65 72 72 65-6c 73 d1 0b 00 4e 69 63 |ue Serre ls...Nic|
05e0 6b 20 56 61 69 73 65 79-d1 0c 00 4a 61 6d 65 73 |k Vaisey ...James|
05f0 20 54 75 63 6b 65 72 d1-0a 00 41 64 61 6d 20 47 | Tucker. ..Adam G|
0600 72 6f 6f 6d d1 0d 00 4a-61 69 6e 65 20 44 75 6e |room...J aine Dun|
0610 6d 6f 72 65 d1 08 00 54-69 6d 20 43 61 6c 65 d1 |more...T im Cale.|
0620 0f 00 53 68 61 72 6f 6e-20 53 74 65 70 68 65 6e |..Sharon  Stephen|
0630 73 d1 0b 00 4a 6f 61 6e-6e 65 20 42 65 61 6e d1 |s...Joan ne Bean.|
0640 0b 00 54 6f 6e 79 20 46-65 6e 74 6f 6e d1 ff ff |..Tony F enton...|
0650 d1 0c 00 42 72 79 61 6e-20 44 72 61 70 65 72 fd |...Bryan  Draper.|
0660 10 00 c1 00 90 00 00 00-                        |........|

17:51:47.339027 dbsqlok() marker is 81
17:51:47.339072 dbsqlok() found result token
17:51:47.339111 dbbind() column = 1 2 60
17:51:47.339224 tds_client_msg: #20032: "Attempt to bind to a non-existent
column.".  Connection state is now 0.
17:51:47.339271 dbnextrow()
17:51:47.339309 dbnextrow() dbresults_state = 0
17:51:47.339346 leaving dbnextrow() returning -2
17:51:47.339384 tds_free_all_results()
17:51:47.339467 in dbfreebuf()


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds