Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQlNumResultsCols Failed ?

2 posts in Windows NT Last posting was on 2000-05-11 19:19:02.0Z
Chuck Boyce Posted on 2000-05-11 19:00:54.0Z
Message-ID: <391B0365.79BC2B6B@operamail.com>
Date: Thu, 11 May 2000 15:00:54 -0400
From: Chuck Boyce <chuck_boyce@operamail.com>
X-Mailer: Mozilla 4.6 [en] (WinNT; I)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Subject: SQlNumResultsCols Failed ?
Content-Type: multipart/alternative; boundary="------------921FC2198743F36739180561"
Newsgroups: sybase.public.sqlserver.nt
Lines: 692
NNTP-Posting-Host: 204.170.39.73
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2177
Article PK: 1089610

Any thoughts on the following anyone?

[SQLCon32.exe is a very small (280K) tool Allaire gave me to test SQL that isn't working from CF server 4.5.1 to ASE 12.0(NT).]
[SQLCon32.exe is available at ftp://ftp.allaire.com/outgoing/SqlCon32/]
                     OK. I use SQLCon32.exe to connect to ASE 12.0 with Sybase ODBC
                     Driver Version 03.50.0011. Here's the output:

                     SQLDriverConnect Successful

                     ODBC Version is : 03

                     SQL Driver Name is : SYODASE
                     SQL Driver Version is : 03.50.0011
                     SQL DBMS Name is : SQL Server
                     SQL DBMS Version is : 12.00.0000
 
                     Now, I run this SQL, which abends with ColdFusion Server Pro 4.5.1:

                     select pri, tot_req=count(*), tot_ref= (select count(i.asl_from) from
                     ds_reroute_detail i where dur is not null and
                     i.asrefcode >= '01' and i.asrefcode <'XX' and i.pri= o.pri) into #temp1
                     from ds_reroute_detail o where asl_from >= '00UZ'
                     group by pri select *,refrate=100*(convert(float,tot_ref)/convert(float,
                     tot_req)) into #temp2 from #temp1 select o.pri,
                     t.tot_req,t.tot_ref,t.refrate, total_ref=(select count(i.asl_from) from
                     ds_reroute_detail i where dur is not null and i.asrefcode
                     >= '01' and i.asrefcode <'XX' and i.pri = o.pri), "t30" = (select
                     count(i.asl_from) from ds_reroute_detail i where dur >= 0
                     and dur < 31 and i.asrefcode >= '01' and i.asrefcode <'XX' and i.pri =
                     o.pri), "t60" = (select count(i.asl_from) from
                     ds_reroute_detail i where dur >= 31 and dur < 61 and i.asrefcode >=
                     '01' and i.asrefcode <'XX' and i.pri = o.pri), "t120" =
                     (select count(i.asl_from) from ds_reroute_detail i where i.dur >= 61
                     and i.dur < 121 and i.asrefcode >= '01' and i.asrefcode
                     <'XX' and i.pri = o.pri), "tover" = (select count(i.asl_from) from
                     ds_reroute_detail i where dur >= 121 and i.asrefcode >=
                     '01' and i.asrefcode <'XX' and i.pri = o.pri) from ds_reroute_detail o,
                     #temp2 t where o.pri = t.pri group by o.pri,
                     t.tot_req,t.tot_ref,t.refrate

                     Here are the test results of the SQL using SQLCon32.exe:

                     SQLDriverConnect Successful

                     ODBC Version is : 03

                     SQL Driver Name is : SYODASE
                     SQL Driver Version is : 03.50.0011
                     SQL DBMS Name is : SQL Server
                     SQL DBMS Version is : 12.00.0000

                     SQLExecDirect Successful

                     SQlNumResultsCols Failed

                     OK, now watch what happens when I connect to ASE 12.0 with
                     ODBC Driver Version 02.12.0000.
                     I connect to ASE 12 ok:

                     SQLDriverConnect Successful

                     ODBC Version is : 03

                     SQL Driver Name is : SYODASE
                     SQL Driver Version is : 03.50.0011
                     SQL DBMS Name is : SQL Server
                     SQL DBMS Version is : 12.00.0000

                     SQLExecDirect Successful

                     SQlNumResultsCols Failed
                     SQLDriverConnect Successful

                     ODBC Version is : 03

                     SQL Driver Name is : sysybnt
                     SQL Driver Version is : 02.12.0000
                     SQL DBMS Name is : SQL Server
                     SQL DBMS Version is : SQL Server/12.0/P/Generic/OS/1/OPT/Fri
                     Apr 30 00:01:37 PDT 1999
 
 
 
 

                     I run the same SQL:

                     select pri, tot_req=count(*), tot_ref= (select count(i.asl_from) from
                     ds_reroute_detail i where dur is not null and
                     i.asrefcode >= '01' and i.asrefcode <'XX' and i.pri= o.pri) into #temp1
                     from ds_reroute_detail o where asl_from >= '00UZ'
                     group by pri select *,refrate=100*(convert(float,tot_ref)/convert(float,
                     tot_req)) into #temp2 from #temp1 select o.pri,
                     t.tot_req,t.tot_ref,t.refrate, total_ref=(select count(i.asl_from) from
                     ds_reroute_detail i where dur is not null and i.asrefcode
                     >= '01' and i.asrefcode <'XX' and i.pri = o.pri), "t30" = (select
                     count(i.asl_from) from ds_reroute_detail i where dur >= 0
                     and dur < 31 and i.asrefcode >= '01' and i.asrefcode <'XX' and i.pri =
                     o.pri), "t60" = (select count(i.asl_from) from
                     ds_reroute_detail i where dur >= 31 and dur < 61 and i.asrefcode >=
                     '01' and i.asrefcode <'XX' and i.pri = o.pri), "t120" =
                     (select count(i.asl_from) from ds_reroute_detail i where i.dur >= 61
                     and i.dur < 121 and i.asrefcode >= '01' and i.asrefcode
                     <'XX' and i.pri = o.pri), "tover" = (select count(i.asl_from) from
                     ds_reroute_detail i where dur >= 121 and i.asrefcode >=
                     '01' and i.asrefcode <'XX' and i.pri = o.pri) from ds_reroute_detail o,
                     #temp2 t where o.pri = t.pri group by o.pri,
                     t.tot_req,t.tot_ref,t.refrate

                     However, using SQLCon32.exe, the results are now successfull:

                     SQLDriverConnect Successful

                     ODBC Version is : 03

                     SQL Driver Name is : SYODASE
                     SQL Driver Version is : 03.50.0011
                     SQL DBMS Name is : SQL Server
                     SQL DBMS Version is : 12.00.0000

                     SQLExecDirect Successful

                     SQlNumResultsCols Failed
                     SQLDriverConnect Successful

                     ODBC Version is : 03

                     SQL Driver Name is : sysybnt
                     SQL Driver Version is : 02.12.0000
                     SQL DBMS Name is : SQL Server
                     SQL DBMS Version is : SQL Server/12.0/P/Generic/OS/1/OPT/Fri
                     Apr 30 00:01:37 PDT 1999

                     SQLExecDirect Successful

                     [Row, pri, tot_req, tot_ref, refrate, total_ref, t30, t60, t120, tover]
                     1 A, 496, 64, 12.9032258064516, 64, 25, 16, 14, 9,
                     2 B, 9625, 1810, 18.8051948051948, 1810, 753, 318, 311, 428,


Chuck Boyce Posted on 2000-05-11 19:19:02.0Z
Message-ID: <391B07A5.BBB0619F@operamail.com>
Date: Thu, 11 May 2000 15:19:02 -0400
From: Chuck Boyce <chuck_boyce@operamail.com>
X-Mailer: Mozilla 4.6 [en] (WinNT; I)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Subject: typo / Re: SQlNumResultsCols Failed ?
References: <391B0365.79BC2B6B@operamail.com>
Content-Type: multipart/alternative; boundary="------------B8D0E7A7C07998EAEAACBBAA"
Newsgroups: sybase.public.sqlserver.nt
Lines: 715
NNTP-Posting-Host: 204.170.39.73
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2176
Article PK: 1089608

I made a "cut and paste" typo in my post:  All the results of testing Sybase ODBC driver 02.12.0000 were successfull hitting ASE 12.0 with the SQL snippet that failed on the ColdFusion 4.5.1 Server Professional web application.

Chuck Boyce wrote:

Any thoughts on the following anyone?

[SQLCon32.exe is a very small (280K) tool Allaire gave me to test SQL that isn't working from CF server 4.5.1 to ASE 12.0(NT).]
[SQLCon32.exe is available at ftp://ftp.allaire.com/outgoing/SqlCon32/]
                     OK. I use SQLCon32.exe to connect to ASE 12.0 with Sybase ODBC
                     Driver Version 03.50.0011. Here's the output:

                     SQLDriverConnect Successful

                     ODBC Version is : 03

                     SQL Driver Name is : SYODASE
                     SQL Driver Version is : 03.50.0011
                     SQL DBMS Name is : SQL Server
                     SQL DBMS Version is : 12.00.0000

                     Now, I run this SQL, which abends with ColdFusion Server Pro 4.5.1:

                     select pri, tot_req=count(*), tot_ref= (select count(i.asl_from) from
                     ds_reroute_detail i where dur is not null and
                     i.asrefcode >= '01' and i.asrefcode <'XX' and i.pri= o.pri) into #temp1
                     from ds_reroute_detail o where asl_from >= '00UZ'
                     group by pri select *,refrate=100*(convert(float,tot_ref)/convert(float,
                     tot_req)) into #temp2 from #temp1 select o.pri,
                     t.tot_req,t.tot_ref,t.refrate, total_ref=(select count(i.asl_from) from
                     ds_reroute_detail i where dur is not null and i.asrefcode
                     >= '01' and i.asrefcode <'XX' and i.pri = o.pri), "t30" = (select
                     count(i.asl_from) from ds_reroute_detail i where dur >= 0
                     and dur < 31 and i.asrefcode >= '01' and i.asrefcode <'XX' and i.pri =
                     o.pri), "t60" = (select count(i.asl_from) from
                     ds_reroute_detail i where dur >= 31 and dur < 61 and i.asrefcode >=
                     '01' and i.asrefcode <'XX' and i.pri = o.pri), "t120" =
                     (select count(i.asl_from) from ds_reroute_detail i where i.dur >= 61
                     and i.dur < 121 and i.asrefcode >= '01' and i.asrefcode
                     <'XX' and i.pri = o.pri), "tover" = (select count(i.asl_from) from
                     ds_reroute_detail i where dur >= 121 and i.asrefcode >=
                     '01' and i.asrefcode <'XX' and i.pri = o.pri) from ds_reroute_detail o,
                     #temp2 t where o.pri = t.pri group by o.pri,
                     t.tot_req,t.tot_ref,t.refrate

                     Here are the test results of the SQL using SQLCon32.exe:

                     SQLDriverConnect Successful

                     ODBC Version is : 03

                     SQL Driver Name is : SYODASE
                     SQL Driver Version is : 03.50.0011
                     SQL DBMS Name is : SQL Server
                     SQL DBMS Version is : 12.00.0000

                     SQLExecDirect Successful

                     SQlNumResultsCols Failed

                     OK, now watch what happens when I connect to ASE 12.0 with
                     ODBC Driver Version 02.12.0000.
                     I connect to ASE 12 ok:

                     SQLDriverConnect Successful

                     ODBC Version is : 03

                     SQL Driver Name is : SYODASE
                     SQL Driver Version is : 03.50.0011
                     SQL DBMS Name is : SQL Server
                     SQL DBMS Version is : 12.00.0000

                     SQLExecDirect Successful

                     SQlNumResultsCols Failed
                     SQLDriverConnect Successful

                     ODBC Version is : 03

                     SQL Driver Name is : sysybnt
                     SQL Driver Version is : 02.12.0000
                     SQL DBMS Name is : SQL Server
                     SQL DBMS Version is : SQL Server/12.0/P/Generic/OS/1/OPT/Fri
                     Apr 30 00:01:37 PDT 1999
 
 
 
 

                     I run the same SQL:

                     select pri, tot_req=count(*), tot_ref= (select count(i.asl_from) from
                     ds_reroute_detail i where dur is not null and
                     i.asrefcode >= '01' and i.asrefcode <'XX' and i.pri= o.pri) into #temp1
                     from ds_reroute_detail o where asl_from >= '00UZ'
                     group by pri select *,refrate=100*(convert(float,tot_ref)/convert(float,
                     tot_req)) into #temp2 from #temp1 select o.pri,
                     t.tot_req,t.tot_ref,t.refrate, total_ref=(select count(i.asl_from) from
                     ds_reroute_detail i where dur is not null and i.asrefcode
                     >= '01' and i.asrefcode <'XX' and i.pri = o.pri), "t30" = (select
                     count(i.asl_from) from ds_reroute_detail i where dur >= 0
                     and dur < 31 and i.asrefcode >= '01' and i.asrefcode <'XX' and i.pri =
                     o.pri), "t60" = (select count(i.asl_from) from
                     ds_reroute_detail i where dur >= 31 and dur < 61 and i.asrefcode >=
                     '01' and i.asrefcode <'XX' and i.pri = o.pri), "t120" =
                     (select count(i.asl_from) from ds_reroute_detail i where i.dur >= 61
                     and i.dur < 121 and i.asrefcode >= '01' and i.asrefcode
                     <'XX' and i.pri = o.pri), "tover" = (select count(i.asl_from) from
                     ds_reroute_detail i where dur >= 121 and i.asrefcode >=
                     '01' and i.asrefcode <'XX' and i.pri = o.pri) from ds_reroute_detail o,
                     #temp2 t where o.pri = t.pri group by o.pri,
                     t.tot_req,t.tot_ref,t.refrate

                     However, using SQLCon32.exe, the results are now successfull:

                     SQLDriverConnect Successful

                     ODBC Version is : 03

                     SQL Driver Name is : SYODASE
                     SQL Driver Version is : 03.50.0011
                     SQL DBMS Name is : SQL Server
                     SQL DBMS Version is : 12.00.0000

                     SQLExecDirect Successful

                     SQlNumResultsCols Failed
                     SQLDriverConnect Successful

                     ODBC Version is : 03

                     SQL Driver Name is : sysybnt
                     SQL Driver Version is : 02.12.0000
                     SQL DBMS Name is : SQL Server
                     SQL DBMS Version is : SQL Server/12.0/P/Generic/OS/1/OPT/Fri
                     Apr 30 00:01:37 PDT 1999

                     SQLExecDirect Successful

                     [Row, pri, tot_req, tot_ref, refrate, total_ref, t30, t60, t120, tover]
                     1 A, 496, 64, 12.9032258064516, 64, 25, 16, 14, 9,
                     2 B, 9625, 1810, 18.8051948051948, 1810, 753, 318, 311, 428,

--
Chuck Boyce chuck_boyce@operamail.com
http://www.geocities.com/chuck_boyce_jr/
Yahoo Messenger ID: chuck_boyce_jr  http://messenger.yahoo.com
AOL Instant Messenger ID: sg95m476 http://www.aol.com/aim/
ICQ Messenger ID: 41449031 http://www.icq.com