Problem with DBD::Sybase and SQL Server
"Wechsler, Steven" <[email protected]> Thu, 30 Oct 2008 16:16:57 -0400
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase |
|---|---|
| Message-ID | <9BFA664319211B4780C5F8A4FB060FF503238E04@LAZYTOWN.mtvn.ad.viacom.com> |
This is a multi-part message in MIME format.
------_=_NextPart_001_01C93ACC.760F7970
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I have two hosts here. They are both using FreeTDS to talk to a SQL
Server. One is running DBD::Sybase v 0.95, and it works fine. The other
is running v 1.08, and it gets the following error whenever I try to run
any SQL command:
$ run_sql.pl -S mtvu-sql-1 -q 'select @@servername'
Msg 3902, Severity 16, State 1:
Server 'MTVU-SQL-1', Line: 2:
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
***** Running query against server mtvu-sql-1 at 10/30/08 15:57:36 *****
COL(1)
----------=20
MTVU-SQL-1=20
***** WARNING: Execution finished with warnings/errors at 10/30/08
15:57:36 ****
The TDS version is the same on both. Here is a trace for the working
host:
$ DBI_TRACE=3D1 run_sql.pl -S mtvu-sql-1 -q 'select @@servername'
DBI 1.604-ithread default trace level set to 0x0/1 (pid 13360) at
DBI.pm line 273 via run_sql.pl line 62
-> DBI->connect(dbi:Sybase:server=3Dmtvu-sql-1, sa, ****,
HASH(0x91da1b4))
-> DBI->install_driver(Sybase) for linux perl=3D5.008 pid=3D13360
ruid=3D30905 euid=3D30905
install_driver: DBD::Sybase version 0.95 loaded from
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/Sybase.pm
<- install_driver=3D DBI::dr=3DHASH(0x920b678)
!! warn: 0 CLEARED by call to connect method
<- connect('server=3Dmtvu-sql-1', 'sa', ...)=3D =
DBI::db=3DHASH(0x920c01c)
at DBI.pm line 637
<- STORE('PrintError', 1)=3D 1 at DBI.pm line 689
<- STORE('AutoCommit', 1)=3D 1 at DBI.pm line 689
<- STORE('Username', 'sa')=3D 1 at DBI.pm line 692
<> FETCH('Username')=3D 'sa' ('Username' from cache) at DBI.pm line
692
<- STORE('syb_err_handler', CODE(0x91d1ff4))=3D 1 at DBI.pm line 692
<- FETCH('syb_err_handler')=3D CODE(0x91d1ff4) at DBI.pm line 692
<- connected('dbi:Sybase:server=3Dmtvu-sql-1', 'sa', ...)=3D undef =
at
DBI.pm line 698
<- connect=3D DBI::db=3DHASH(0x920c01c)
<- STORE('dbi_connect_closure', CODE(0x920a2d8))=3D 1 at DBI.pm line
707
<- prepare('select db_name()')=3D DBI::st=3DHASH(0x920c1cc) at
run_sql.pl line 1187
<- execute=3D -1 at run_sql.pl line 1189
<- fetchrow_array=3D ( 'master' ) [1 items] row1 at run_sql.pl line
1190
<- DESTROY(DBI::st=3DHASH(920c0a0))=3D undef at run_sql.pl line 460
***** Running query against server mtvu-sql-1 at 10/30/08 15:59:00 *****
<- prepare("select @@servername
-- ")=3D DBI::st=3DHASH(0x8fb48a8) at run_sql.pl line 557
<- execute=3D -1 at run_sql.pl line 561
<- rows=3D -1 at run_sql.pl line 562
<- FETCH('NUM_OF_FIELDS')=3D 1 at run_sql.pl line 574
<- FETCH('NAME')=3D [ 'COL(1)' ] at run_sql.pl line 578
<- FETCH('syb_result_type')=3D 4040 at run_sql.pl line 584
<- FETCH('NUM_OF_FIELDS')=3D 1 at run_sql.pl line 585
COL(1)
----------=20
MTVU-SQL-1=20
<- more_results=3D undef at run_sql.pl line 724
<- FETCH('syb_more_results')=3D 0 at run_sql.pl line 575
<- finish=3D 1 at run_sql.pl line 760
<- disconnect=3D 1 at run_sql.pl line 761
***** Execution finished at 10/30/08 15:59:00 *****
<- disconnect=3D 1 at run_sql.pl line 941
<- disconnect_all=3D 1 at DBI.pm line 716
! <- DESTROY(DBI::st=3DHASH(8fb48a8))=3D undef during global =
destruction
! <- DESTROY(DBI::db=3DHASH(920b9c0))=3D undef during global =
destruction
! <- DESTROY(DBI::dr=3DHASH(920b6e4))=3D undef during global =
destruction
And here is the trace for the one that gets the error:
$ DBI_TRACE=3D1 run_sql.pl -S mtvu-sql-1 -q 'select @@servername'
DBI 1.604-ithread default trace level set to 0x0/1 (pid 13360) at
DBI.pm line 273 via run_sql.pl line 62 DBI 1.602-ithread default
trace level set to 0x0/1 (pid 17240) at DBI.pm line 273 via run_sql.pl
line 62
-> DBI->connect(dbi:Sybase:server=3Dmtvu-sql-1, sa, ****,
HASH(0x85bbd10))
-> DBI->install_driver(Sybase) for linux perl=3D5.008005 pid=3D17240
ruid=3D2001 euid=3D2001
install_driver: DBD::Sybase version 1.08 loaded from
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBD/Sybase.pm
<- install_driver=3D DBI::dr=3DHASH(0x85fd480)
!! warn: 0 CLEARED by call to connect method
<- connect('server=3Dmtvu-sql-1', 'sa', ...)=3D =
DBI::db=3DHASH(0x85ff5f8)
at DBI.pm line 637
<- STORE('PrintError', 1)=3D 1 at DBI.pm line 689
Msg 3902, Severity 16, State 1:
Server 'MTVU-SQL-1', Line: 2:
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
<- STORE('AutoCommit', 1)=3D 1 at DBI.pm line 689
<- STORE('Username', 'sa')=3D 1 at DBI.pm line 692
<> FETCH('Username')=3D 'sa' ('Username' from cache) at DBI.pm line
692
<- STORE('syb_err_handler', CODE(0x85b4358))=3D 1 at DBI.pm line 692
<- FETCH('syb_err_handler')=3D CODE(0x85b4358) at DBI.pm line 692
<- connected('dbi:Sybase:server=3Dmtvu-sql-1', 'sa', ...)=3D undef =
at
DBI.pm line 698
<- connect=3D DBI::db=3DHASH(0x85ff5f8)
<- STORE('dbi_connect_closure', CODE(0x85fdec8))=3D 1 at DBI.pm line
707
<- prepare('select db_name()')=3D DBI::st=3DHASH(0x85ff79c) at
run_sql.pl line 1187
<- execute=3D -1 at run_sql.pl line 1189
<- fetchrow_array=3D ( 'master' ) [1 items] row1 at run_sql.pl line
1190
<- DESTROY(DBI::st=3DHASH(85ff67c))=3D undef at run_sql.pl line 460
***** Running query against server mtvu-sql-1 at 10/30/08 15:59:11 *****
<- prepare('select @@servername
-- ')=3D DBI::st=3DHASH(0x8352b88) at run_sql.pl line 557
<- execute=3D -1 at run_sql.pl line 561
<- rows=3D -1 at run_sql.pl line 562
<> FETCH('NUM_OF_FIELDS')=3D 1 ('NUM_OF_FIELDS' from cache) at
run_sql.pl line 574
<- FETCH('NAME')=3D [ 'COL(1)' ] at run_sql.pl line 578
<- FETCH('syb_result_type')=3D 4040 at run_sql.pl line 584
<> FETCH('NUM_OF_FIELDS')=3D 1 ('NUM_OF_FIELDS' from cache) at
run_sql.pl line 585
COL(1)
----------=20
MTVU-SQL-1=20
<- more_results=3D undef at run_sql.pl line 724
<- FETCH('syb_more_results')=3D 0 at run_sql.pl line 575
<- finish=3D 1 at run_sql.pl line 760
<- disconnect=3D 1 at run_sql.pl line 761
***** WARNING: Execution finished with warnings/errors at 10/30/08
15:59:11 ****
<- disconnect=3D 1 at run_sql.pl line 941
<- disconnect_all=3D 1 at DBI.pm line 716
! <- DESTROY(DBI::st=3DHASH(8352b88))=3D undef during global =
destruction
! <- DESTROY(DBI::db=3DHASH(85fe294))=3D undef during global =
destruction
! <- DESTROY(DBI::dr=3DHASH(85fd4c8))=3D undef during global =
destruction
Steve Wechsler | [email protected]
Sybase/SQL Server/MySQL Database Administrator
212-846-5683
MTV Networks
------_=_NextPart_001_01C93ACC.760F7970
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7653.38">
<TITLE>Problem with DBD::Sybase and SQL Server</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=3D2 FACE=3D"Arial">I have two hosts here. They are both =
using FreeTDS to talk to a SQL Server. One is running DBD::Sybase v =
0.95, and it works fine. The other is running v 1.08, and it gets the =
following error whenever I try to run any SQL command:</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Lucida Console">$ run_sql.pl -S mtvu-sql-1 -q =
'select @@servername'</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">Msg 3902, Severity 16, State =
1:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">Server 'MTVU-SQL-1', Line: =
2:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">The COMMIT TRANSACTION =
request has no corresponding BEGIN TRANSACTION.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">***** Running query against =
server mtvu-sql-1 at 10/30/08 15:57:36 *****</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">COL(1)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">---------- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">MTVU-SQL-1 </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">***** WARNING: Execution =
finished with warnings/errors at 10/30/08 15:57:36 ****</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">The TDS version is the same on both. =
Here is a trace for the working host:</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Lucida Console">$ DBI_TRACE=3D1 run_sql.pl -S =
mtvu-sql-1 -q 'select @@servername'</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> DBI =
1.604-ithread default trace level set to 0x0/1 (pid 13360) at DBI.pm =
line 273 via run_sql.pl line 62</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> -> =
DBI->connect(dbi:Sybase:server=3Dmtvu-sql-1, sa, ****, =
HASH(0x91da1b4))</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> -> =
DBI->install_driver(Sybase) for linux perl=3D5.008 pid=3D13360 =
ruid=3D30905 euid=3D30905</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida =
Console"> install_driver: =
DBD::Sybase version 0.95 loaded from =
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/Sybase.pm</FON=
T></P>
<P><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
install_driver=3D DBI::dr=3DHASH(0x920b678)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> !! warn: 0 =
CLEARED by call to connect method</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
connect('server=3Dmtvu-sql-1', 'sa', ...)=3D DBI::db=3DHASH(0x920c01c) =
at DBI.pm line 637</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
STORE('PrintError', 1)=3D 1 at DBI.pm line 689</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
STORE('AutoCommit', 1)=3D 1 at DBI.pm line 689</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
STORE('Username', 'sa')=3D 1 at DBI.pm line 692</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <> =
FETCH('Username')=3D 'sa' ('Username' from cache) at DBI.pm line =
692</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
STORE('syb_err_handler', CODE(0x91d1ff4))=3D 1 at DBI.pm line 692</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
FETCH('syb_err_handler')=3D CODE(0x91d1ff4) at DBI.pm line 692</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
connected('dbi:Sybase:server=3Dmtvu-sql-1', 'sa', ...)=3D undef at =
DBI.pm line 698</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
connect=3D DBI::db=3DHASH(0x920c01c)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
STORE('dbi_connect_closure', CODE(0x920a2d8))=3D 1 at DBI.pm line =
707</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
prepare('select db_name()')=3D DBI::st=3DHASH(0x920c1cc) at run_sql.pl =
line 1187</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
execute=3D -1 at run_sql.pl line 1189</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
fetchrow_array=3D ( 'master' ) [1 items] row1 at run_sql.pl line =
1190</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
DESTROY(DBI::st=3DHASH(920c0a0))=3D undef at run_sql.pl line 460</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">***** Running query against =
server mtvu-sql-1 at 10/30/08 15:59:00 *****</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
prepare("select @@servername</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Lucida Console">-- ")=3D =
DBI::st=3DHASH(0x8fb48a8) at run_sql.pl line 557</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
execute=3D -1 at run_sql.pl line 561</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
rows=3D -1 at run_sql.pl line 562</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
FETCH('NUM_OF_FIELDS')=3D 1 at run_sql.pl line 574</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
FETCH('NAME')=3D [ 'COL(1)' ] at run_sql.pl line 578</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
FETCH('syb_result_type')=3D 4040 at run_sql.pl line 584</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
FETCH('NUM_OF_FIELDS')=3D 1 at run_sql.pl line 585</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">COL(1)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">---------- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">MTVU-SQL-1 </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
more_results=3D undef at run_sql.pl line 724</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
FETCH('syb_more_results')=3D 0 at run_sql.pl line 575</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
finish=3D 1 at run_sql.pl line 760</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
disconnect=3D 1 at run_sql.pl line 761</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">***** Execution finished at =
10/30/08 15:59:00 *****</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
disconnect=3D 1 at run_sql.pl line 941</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
disconnect_all=3D 1 at DBI.pm line 716</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">! <- =
DESTROY(DBI::st=3DHASH(8fb48a8))=3D undef during global =
destruction</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">! <- =
DESTROY(DBI::db=3DHASH(920b9c0))=3D undef during global =
destruction</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">! <- =
DESTROY(DBI::dr=3DHASH(920b6e4))=3D undef during global =
destruction</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">And here is the trace for the one that =
gets the error:</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Lucida Console">$ DBI_TRACE=3D1 run_sql.pl -S =
mtvu-sql-1 -q 'select @@servername'</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> DBI =
1.604-ithread default trace level set to 0x0/1 (pid 13360) at DBI.pm =
line 273 via run_sql.pl line 62 DBI 1.602-ithread =
default trace level set to 0x0/1 (pid 17240) at DBI.pm line 273 via =
run_sql.pl line 62</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Lucida Console"> -> =
DBI->connect(dbi:Sybase:server=3Dmtvu-sql-1, sa, ****, =
HASH(0x85bbd10))</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> -> =
DBI->install_driver(Sybase) for linux perl=3D5.008005 pid=3D17240 =
ruid=3D2001 euid=3D2001</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida =
Console"> install_driver: =
DBD::Sybase version 1.08 loaded from =
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBD/Sybase.pm</FON=
T></P>
<P><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
install_driver=3D DBI::dr=3DHASH(0x85fd480)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> !! warn: 0 =
CLEARED by call to connect method</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
connect('server=3Dmtvu-sql-1', 'sa', ...)=3D DBI::db=3DHASH(0x85ff5f8) =
at DBI.pm line 637</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
STORE('PrintError', 1)=3D 1 at DBI.pm line 689</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">Msg 3902, Severity 16, State =
1:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">Server 'MTVU-SQL-1', Line: =
2:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">The COMMIT TRANSACTION =
request has no corresponding BEGIN TRANSACTION.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
STORE('AutoCommit', 1)=3D 1 at DBI.pm line 689</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
STORE('Username', 'sa')=3D 1 at DBI.pm line 692</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <> =
FETCH('Username')=3D 'sa' ('Username' from cache) at DBI.pm line =
692</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
STORE('syb_err_handler', CODE(0x85b4358))=3D 1 at DBI.pm line 692</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
FETCH('syb_err_handler')=3D CODE(0x85b4358) at DBI.pm line 692</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
connected('dbi:Sybase:server=3Dmtvu-sql-1', 'sa', ...)=3D undef at =
DBI.pm line 698</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
connect=3D DBI::db=3DHASH(0x85ff5f8)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
STORE('dbi_connect_closure', CODE(0x85fdec8))=3D 1 at DBI.pm line =
707</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
prepare('select db_name()')=3D DBI::st=3DHASH(0x85ff79c) at run_sql.pl =
line 1187</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
execute=3D -1 at run_sql.pl line 1189</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
fetchrow_array=3D ( 'master' ) [1 items] row1 at run_sql.pl line =
1190</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
DESTROY(DBI::st=3DHASH(85ff67c))=3D undef at run_sql.pl line 460</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">***** Running query against =
server mtvu-sql-1 at 10/30/08 15:59:11 *****</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
prepare('select @@servername</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Lucida Console">-- ')=3D =
DBI::st=3DHASH(0x8352b88) at run_sql.pl line 557</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
execute=3D -1 at run_sql.pl line 561</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
rows=3D -1 at run_sql.pl line 562</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <> =
FETCH('NUM_OF_FIELDS')=3D 1 ('NUM_OF_FIELDS' from cache) at run_sql.pl =
line 574</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
FETCH('NAME')=3D [ 'COL(1)' ] at run_sql.pl line 578</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
FETCH('syb_result_type')=3D 4040 at run_sql.pl line 584</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <> =
FETCH('NUM_OF_FIELDS')=3D 1 ('NUM_OF_FIELDS' from cache) at run_sql.pl =
line 585</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">COL(1)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">---------- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">MTVU-SQL-1 </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
more_results=3D undef at run_sql.pl line 724</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
FETCH('syb_more_results')=3D 0 at run_sql.pl line 575</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
finish=3D 1 at run_sql.pl line 760</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
disconnect=3D 1 at run_sql.pl line 761</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">***** WARNING: Execution =
finished with warnings/errors at 10/30/08 15:59:11 ****</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
disconnect=3D 1 at run_sql.pl line 941</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console"> <- =
disconnect_all=3D 1 at DBI.pm line 716</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">! <- =
DESTROY(DBI::st=3DHASH(8352b88))=3D undef during global =
destruction</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">! <- =
DESTROY(DBI::db=3DHASH(85fe294))=3D undef during global =
destruction</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Lucida Console">! <- =
DESTROY(DBI::dr=3DHASH(85fd4c8))=3D undef during global =
destruction</FONT>
</P>
<BR>
<P><FONT COLOR=3D"#1CA6E4" SIZE=3D2 FACE=3D"Comic Sans MS">Steve =
Wechsler | [email protected]</FONT>
<BR><FONT COLOR=3D"#1CA6E4" SIZE=3D2 FACE=3D"Comic Sans MS">Sybase/SQL =
Server/MySQL Database Administrator</FONT>
<BR><FONT COLOR=3D"#1CA6E4" SIZE=3D2 FACE=3D"Comic Sans =
MS">212-846-5683</FONT>
</P>
<P><FONT COLOR=3D"#1CA6E4" SIZE=3D2 FACE=3D"Comic Sans MS">MTV =
Networks<B></B></FONT><B></B>
</P>
<BR>
</BODY>
</HTML>
------_=_NextPart_001_01C93ACC.760F7970--