[freetds] where is was wrong

Victor Gamov vit at lipetsk.ru
Tue Apr 8 13:22:29 EDT 2003


Hi!

I have problem with my freetds-0.60, DBD::Sybase-0.91, perl-5.6.1 on 
FreeBSD box.
When I connect to MS SQL server using tds version = 4.2 in freetds.conf 
with {PrintError=>1, RaiseError=>0} and execute stored procedure on this 
server then I see following lines in dump file (dump level = 9):

--------------------- cut here ---------------------------------

pid: 11699:2003-04-08 17:31:41.918481 inside 
tds_process_default_tokens() marker is d1
pid: 11699:2003-04-08 17:31:41.918542 processing row.  column is 0 
varint size = 1
pid: 11699:2003-04-08 17:31:41.918602 processing row.  column size is 4
pid: 11699:2003-04-08 17:31:41.918660 clearing column 0 NULL bit
pid: 11699:2003-04-08 17:31:41.918718 processing row.  column is 1 
varint size = 1
pid: 11699:2003-04-08 17:31:41.918777 processing row.  column size is 0
pid: 11699:2003-04-08 17:31:41.918836 setting column 1 NULL bit
pid: 11699:2003-04-08 17:31:41.919694 inside ct_con_props() action = 
CS_GET property = 13
pid: 11699:2003-04-08 17:31:41.919756 fetching userdata 141225520
pid: 11699:2003-04-08 17:31:41.919860 inside ct_cmd_drop()
pid: 11699:2003-04-08 17:31:41.921728 inside ct_cmd_alloc()
pid: 11699:2003-04-08 17:31:41.921799 inside ct_command()
pid: 11699:2003-04-08 17:31:41.921858 inside ct_send()
pid: 11699:2003-04-08 17:31:41.921927 ct_send() succeeded
pid: 11699:2003-04-08 17:31:41.921985 inside ct_results()
pid: 11699:2003-04-08 17:31:41.922042 processing result tokens.  marker 
is  0
pid: 11699:2003-04-08 17:31:41.922101 inside 
tds_process_default_tokens() marker is 0
pid: 11699:2003-04-08 17:31:41.922160 leaving 
tds_process_default_tokens() connection dead
pid: 11699:2003-04-08 17:31:41.922255 inside ct_cmd_drop()
pid: 11699:2003-04-08 17:31:41.923277 inside ct_cmd_alloc()
pid: 11699:2003-04-08 17:31:41.923346 inside ct_command()
pid: 11699:2003-04-08 17:31:41.923409 inside ct_send()
pid: 11699:2003-04-08 17:31:41.923491 ct_send() succeeded
pid: 11699:2003-04-08 17:31:41.923548 inside ct_results()
pid: 11699:2003-04-08 17:31:41.923605 processing result tokens.  marker 
is  0
pid: 11699:2003-04-08 17:31:41.923664 inside 
tds_process_default_tokens() marker is 0
pid: 11699:2003-04-08 17:31:41.923723 leaving 
tds_process_default_tokens() connection dead
pid: 11699:2003-04-08 17:31:41.923815 inside ct_cmd_drop()

--------------------- cut here ---------------------------------

but my Perl code doesn't catch this error

{ eval $dbh->do("USE dbname") };
if ( $@ ) {
   print "Error\n";
   exit(1);
}

When i use { PrintError=>0, RaiseError=>1} then i see message like this:

"Server message number=10018 severity=9 state=0 line=0 server=OpenClient 
text=The connection was closed"

Where is my problem?





More information about the FreeTDS mailing list