FreeTDS Development Group

["Lowden, James K" <james.k.lowden AT alliancebernstein.com>]

> From: Lowden, James K
> Sent: Wednesday, June 28, 2006 11:04 AM
> 
> > From: ZIGLIO, Frediano, VF-IT Sent: Wednesday, June 28, 2006 8:23
> > AM
> > 
> > > I'm getting an invalid cursor state error trying to fetch data
> > > from a stored procedure using prepare/execute from DBD::ODBC.
> > > It looks like DBD::ODBC thinks there is more than one result
> > > set and is trying to get column descriptors when there are no
> > > metadata.
> 
> > James, can you post jkl script source ?

Simpler still, src/odbc/unittests/funccall.c fails:

=================
$ tsql -C | grep Ver; isql --version; cat typescript
                           Version: freetds v0.64.dev.20060127
unixODBC 2.2.6
Script started on Wed Jun 28 14:35:54 2006
$ pwd; ident src/funccall.c; make funccall && ./funccall
/usr/users/home/jklowden/projects/freetds.cvs/freetds/build/src/odbc/uni
ttests
src/funccall.c:
     $Id: funccall.c,v 1.11 2004/10/28 13:16:18 freddy77 Exp $
`funccall' is up to date.
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
drop proc simpleresult
Unable to execute statement
create proc simpleresult @i int as begin return @i end
DECLARE @i INT
drop proc simpleresult
drop proc simpleresult2
create proc simpleresult2 @i int, @x int output, @y varchar(20) output
as begin select @x = 6789 select @y = 'test foo' return @i end
drop proc simpleresult2
Unable to execute statement
SQL error 24000 -- [unixODBC][Driver Manager]Invalid cursor state
=================

That made me wonder about the rest of the unit tests.  8 failed, please
see below.  

$ rm nohup.out; nohup make check; grep -E 'FAIL|tests failed' nohup.out
sending output to nohup.out
FAIL: funccall
FAIL: params
FAIL: raiserror
FAIL: genparams
FAIL: const_params
FAIL: cursor1
FAIL: scroll
FAIL: describecol
8 of 42 tests failed

This is with CVS HEAD and unixODBC 2.2.6 (and a hack on genparams to
avoid W types).  Is there another combination I should try?  

Log follows.  Please note the stderr output comes *before* the stdout
output for each test, due to buffering. 

--jkl



Starting array
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
drop table #tmp1
create table #tmp1 (id tinyint, value char(20))
drop table #tmp1
create table #tmp1 (id tinyint, value char(20))
drop table #tmp1
create table #tmp1 (id tinyint, value char(20))
drop table #tmp1
create table #tmp1 (id tinyint, value char(20))
drop table #tmp1
create table #tmp1 (id tinyint, value char(20))
Success!.


Starting array_out
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
CREATE TABLE #odbc_test(i INT, t TEXT)
INSERT INTO #odbc_test(i, t) VALUES(1, 'arow number 0')
INSERT INTO #odbc_test(i, t) VALUES(2, 'brow number 13')
INSERT INTO #odbc_test(i, t) VALUES(3, 'crow number 26')
INSERT INTO #odbc_test(i, t) VALUES(4, 'drow number 39')
INSERT INTO #odbc_test(i, t) VALUES(5, 'erow number 52')
INSERT INTO #odbc_test(i, t) VALUES(6, 'frow number 65')
INSERT INTO #odbc_test(i, t) VALUES(7, 'grow number 78')
INSERT INTO #odbc_test(i, t) VALUES(8, 'hrow number 91')
INSERT INTO #odbc_test(i, t) VALUES(9, 'irow number 104')
INSERT INTO #odbc_test(i, t) VALUES(10, 'jrow number 117')
test line 154
test line 158
test line 164
test line 169
Success!.


Starting binary_test
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
create table #binary_test (im IMAGE)
SET TEXTSIZE 1000000
DECLARE @i INT
Input and output buffers of length 131072 match.
Test passed.


Starting compute
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
create table #tmp1 (c varchar(20), i int)
insert into #tmp1 values('pippo', 12)
insert into #tmp1 values('pippo', 34)
insert into #tmp1 values('pluto', 1)
insert into #tmp1 values('pluto', 2)
insert into #tmp1 values('pluto', 3)
select * from #tmp1 order by c, i compute sum(i)
select c as mao, i from #tmp1 order by c, i compute sum(i) by c compute
max(i)
select * from #tmp1 where i = 2 or i = 34 order by c, i compute min(i)
by c


Starting connect
SQLConnect connect..
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
connect string DSN connect..
connect string SERVERNAME connect..
odbcinst.ini must be configured with FreeTDS driver..
Unable to open data source (ret=-1)
Done.


Starting const_params
SQL error 24000 -- [unixODBC][Driver Manager]Invalid cursor state
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
drop proc const_param
create proc const_param @in1 int, @in2 int, @in3 datetime, @in4
varchar(10), @out int output as
begin
 set nocount on
 select @out = 7654321
 if (@in1 <> @in2 and @in2 is not null) or @in3 <> convert(datetime,
'2004-10-15 12:09:08') or @in4 <> 'foo'
  select @out = 1234567
 return 24680
end
DECLARE @i INT
Unable to execute statement
FAILED: const_params at Wed Jun 28 17:05:01 EDT 2006


Starting convert_error
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
create table #test_output (id int, msg text)


Starting copydesc
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
Done.


Starting cursor1
../../../../src/odbc/unittests/cursor1.c:79 SQLExecDirect
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
IF OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE #test
CREATE TABLE #test(i int, c varchar(6))
INSERT INTO #test(i, c) VALUES(1, 'a')
INSERT INTO #test(i, c) VALUES(2, 'bb')
INSERT INTO #test(i, c) VALUES(3, 'ccc')
INSERT INTO #test(i, c) VALUES(4, 'dddd')
INSERT INTO #test(i, c) VALUES(5, 'eeeee')
INSERT INTO #test(i, c) VALUES(6, 'ffffff')
FAILED: cursor1 at Wed Jun 28 17:05:01 EDT 2006


Starting cursor2
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
CREATE TABLE #cursor2_test (i INT)
DROP TABLE #cursor2_test


Starting data
Wrong result
  Got: 13000179DF0D86487000000000000000000000
  Expected: 79DF0D8648700000
Ignore previous error. You should configure TDS 8.0 for this!!!
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
SELECT CONVERT(NUMERIC(18,2), '123') AS data
SELECT CONVERT(CHAR(7), 'pippo') AS data
SELECT CONVERT(TEXT, 'mickey') AS data
SELECT CONVERT(VARCHAR(20), 'foo') AS data
SELECT CONVERT(BINARY(5), 'qwer') AS data
SELECT CONVERT(IMAGE, 'cricetone') AS data
SELECT CONVERT(VARBINARY(20), 'teo') AS data
SELECT CONVERT(TIMESTAMP, 'abcdefghi') AS data
SELECT CONVERT(DATETIME, '2004-02-24 15:16:17') AS data
SELECT CONVERT(SMALLDATETIME, '2004-02-24 15:16:17') AS data
SELECT CONVERT(BIT, '1') AS data
SELECT CONVERT(BIT, '0') AS data
SELECT CONVERT(TINYINT, '231') AS data
SELECT CONVERT(SMALLINT, '4321') AS data
SELECT CONVERT(INT, '1234567') AS data
SELECT CONVERT(BIGINT, '123456789012345') AS data
SELECT CONVERT(DECIMAL, '1234.5678') AS data
SELECT CONVERT(NUMERIC, '8765.4321') AS data
SELECT CONVERT(FLOAT, '1234.5678') AS data
SELECT CONVERT(REAL, '8765.4321') AS data
SELECT CONVERT(SMALLMONEY, '765.4321') AS data
SELECT CONVERT(MONEY, '4321234.5678') AS data
SELECT CONVERT(UNIQUEIDENTIFIER, '0DDF3B64-E692-11D1-AB06-00AA00BDD685')
AS data
SELECT CONVERT(DATETIME, '2006-06-09 11:22:44') AS data
SELECT CONVERT(SMALLDATETIME, '2006-06-12 22:37:21') AS data
Done successfully!


Starting date
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
select convert(datetime, '2002-12-27 18:43:21')
Date returned: 2002-12-27 18:43:21.000
select convert(datetime, '2002-12-27 18:43:21')
Date returned: 2002-12-27 18:43:21.000
Done.


Starting describecol
Line 15: invalid SQL_COLUMN_PRECISION got 1 expected 3
Line 17: invalid SQL_DESC_LENGTH got 1 expected 3
Line 19: invalid SQL_DESC_PRECISION got 1 expected 3
Line 25: invalid SQL_COLUMN_PRECISION got 2 expected 5
Line 27: invalid SQL_DESC_LENGTH got 2 expected 5
Line 29: invalid SQL_DESC_PRECISION got 2 expected 5
Line 35: invalid SQL_COLUMN_PRECISION got 4 expected 10
Line 37: invalid SQL_DESC_LENGTH got 4 expected 10
Line 39: invalid SQL_DESC_PRECISION got 4 expected 10
Line 44: invalid SQL_COLUMN_LENGTH got 17 expected 8
Line 47: invalid SQL_DESC_LENGTH got 17 expected 19
Line 48: invalid SQL_DESC_OCTET_LENGTH got 17 expected 8
Line 51: invalid SQL_DESC_DISPLAY_SIZE got 21 expected 20
Line 55: invalid SQL_COLUMN_PRECISION got 4 expected 7
Line 57: invalid SQL_DESC_LENGTH got 4 expected 7
Line 59: invalid SQL_DESC_PRECISION got 4 expected 7
Line 61: invalid SQL_DESC_DISPLAY_SIZE got 24 expected 14
Line 65: invalid SQL_COLUMN_PRECISION got 8 expected 15
Line 67: invalid SQL_DESC_LENGTH got 8 expected 15
Line 69: invalid SQL_DESC_PRECISION got 8 expected 15
Line 74: invalid SQL_COLUMN_LENGTH got 4 expected 12
Line 75: invalid SQL_COLUMN_PRECISION got 4 expected 10
Line 76: invalid SQL_COLUMN_SCALE got 0 expected 4
Line 77: invalid SQL_DESC_LENGTH got 4 expected 10
Line 78: invalid SQL_DESC_OCTET_LENGTH got 4 expected 12
Line 79: invalid SQL_DESC_PRECISION got 4 expected 10
Line 80: invalid SQL_DESC_SCALE got 0 expected 4
Line 81: invalid SQL_DESC_DISPLAY_SIZE got 24 expected 12
Line 84: invalid SQL_COLUMN_LENGTH got 8 expected 21
Line 85: invalid SQL_COLUMN_PRECISION got 8 expected 19
Line 86: invalid SQL_COLUMN_SCALE got 0 expected 4
Line 87: invalid SQL_DESC_LENGTH got 8 expected 19
Line 88: invalid SQL_DESC_OCTET_LENGTH got 8 expected 21
Line 89: invalid SQL_DESC_PRECISION got 8 expected 19
Line 90: invalid SQL_DESC_SCALE got 0 expected 4
Line 91: invalid SQL_DESC_DISPLAY_SIZE got 24 expected 21
Line 94: invalid SQL_COLUMN_LENGTH got 17 expected 12
Line 97: invalid SQL_DESC_LENGTH got 17 expected 10
Line 98: invalid SQL_DESC_OCTET_LENGTH got 17 expected 12
Line 104: invalid SQL_COLUMN_LENGTH got 17 expected 25
Line 107: invalid SQL_DESC_LENGTH got 17 expected 23
Line 108: invalid SQL_DESC_OCTET_LENGTH got 17 expected 25
Line 114: invalid SQL_COLUMN_LENGTH got 8 expected 16
Line 115: invalid SQL_COLUMN_PRECISION got 8 expected 23
Line 116: invalid SQL_COLUMN_SCALE got 0 expected 3
Line 117: invalid SQL_DESC_LENGTH got 8 expected 23
Line 118: invalid SQL_DESC_OCTET_LENGTH got 8 expected 16
Line 119: invalid SQL_DESC_PRECISION got 8 expected 3
Line 120: invalid SQL_DESC_SCALE got 0 expected 3
Line 124: invalid SQL_COLUMN_LENGTH got 4 expected 16
Line 125: invalid SQL_COLUMN_PRECISION got 4 expected 16
Line 127: invalid SQL_DESC_LENGTH got 4 expected 16
Line 128: invalid SQL_DESC_OCTET_LENGTH got 4 expected 16
Line 129: invalid SQL_DESC_PRECISION got 4 expected 0
Line 131: invalid SQL_DESC_DISPLAY_SIZE got 23 expected 19
Line 154: invalid SQL_COLUMN_LENGTH got 12 expected 24
Line 158: invalid SQL_DESC_OCTET_LENGTH got 12 expected 24
Line 164: invalid SQL_COLUMN_LENGTH got 13 expected 26
Line 168: invalid SQL_DESC_OCTET_LENGTH got 13 expected 26
Line 184: invalid SQL_COLUMN_LENGTH got 2048 expected 4096
Line 188: invalid SQL_DESC_OCTET_LENGTH got 2048 expected 4096
Line 239: invalid SQL_COLUMN_PRECISION got 1 expected 3
Line 241: invalid SQL_DESC_LENGTH got 1 expected 3
Line 243: invalid SQL_DESC_PRECISION got 1 expected 3
Line 249: invalid SQL_COLUMN_PRECISION got 2 expected 5
Line 251: invalid SQL_DESC_LENGTH got 2 expected 5
Line 253: invalid SQL_DESC_PRECISION got 2 expected 5
Line 259: invalid SQL_COLUMN_PRECISION got 4 expected 10
Line 261: invalid SQL_DESC_LENGTH got 4 expected 10
Line 263: invalid SQL_DESC_PRECISION got 4 expected 10
Line 268: invalid SQL_COLUMN_LENGTH got 17 expected 8
Line 271: invalid SQL_DESC_LENGTH got 17 expected 19
Line 272: invalid SQL_DESC_OCTET_LENGTH got 17 expected 8
Line 275: invalid SQL_DESC_DISPLAY_SIZE got 21 expected 20
Line 279: invalid SQL_COLUMN_PRECISION got 4 expected 7
Line 281: invalid SQL_DESC_LENGTH got 4 expected 24
Line 283: invalid SQL_DESC_PRECISION got 4 expected 24
Line 285: invalid SQL_DESC_DISPLAY_SIZE got 24 expected 14
Line 289: invalid SQL_COLUMN_PRECISION got 8 expected 15
Line 291: invalid SQL_DESC_LENGTH got 8 expected 53
Line 293: invalid SQL_DESC_PRECISION got 8 expected 53
Line 298: invalid SQL_COLUMN_LENGTH got 4 expected 12
Line 299: invalid SQL_COLUMN_PRECISION got 4 expected 10
Line 300: invalid SQL_COLUMN_SCALE got 0 expected 4
Line 301: invalid SQL_DESC_LENGTH got 4 expected 10
Line 302: invalid SQL_DESC_OCTET_LENGTH got 4 expected 12
Line 303: invalid SQL_DESC_PRECISION got 4 expected 10
Line 304: invalid SQL_DESC_SCALE got 0 expected 4
Line 305: invalid SQL_DESC_DISPLAY_SIZE got 24 expected 12
Line 308: invalid SQL_COLUMN_LENGTH got 8 expected 21
Line 309: invalid SQL_COLUMN_PRECISION got 8 expected 19
Line 310: invalid SQL_COLUMN_SCALE got 0 expected 4
Line 311: invalid SQL_DESC_LENGTH got 8 expected 19
Line 312: invalid SQL_DESC_OCTET_LENGTH got 8 expected 21
Line 313: invalid SQL_DESC_PRECISION got 8 expected 19
Line 314: invalid SQL_DESC_SCALE got 0 expected 4
Line 315: invalid SQL_DESC_DISPLAY_SIZE got 24 expected 21
Line 318: invalid SQL_COLUMN_LENGTH got 17 expected 12
Line 321: invalid SQL_DESC_LENGTH got 17 expected 10
Line 322: invalid SQL_DESC_OCTET_LENGTH got 17 expected 12
Line 328: invalid SQL_COLUMN_LENGTH got 17 expected 25
Line 331: invalid SQL_DESC_LENGTH got 17 expected 23
Line 332: invalid SQL_DESC_OCTET_LENGTH got 17 expected 25
Line 338: invalid SQL_COLUMN_LENGTH got 8 expected 16
Line 339: invalid SQL_COLUMN_PRECISION got 8 expected 23
Line 340: invalid SQL_COLUMN_SCALE got 0 expected 3
Line 341: invalid SQL_DESC_LENGTH got 8 expected 23
Line 342: invalid SQL_DESC_OCTET_LENGTH got 8 expected 16
Line 343: invalid SQL_DESC_PRECISION got 8 expected 3
Line 344: invalid SQL_DESC_SCALE got 0 expected 3
Line 348: invalid SQL_COLUMN_LENGTH got 4 expected 16
Line 349: invalid SQL_COLUMN_PRECISION got 4 expected 16
Line 351: invalid SQL_DESC_LENGTH got 4 expected 16
Line 352: invalid SQL_DESC_OCTET_LENGTH got 4 expected 16
Line 353: invalid SQL_DESC_PRECISION got 4 expected 0
Line 355: invalid SQL_DESC_DISPLAY_SIZE got 23 expected 19
Line 378: invalid SQL_COLUMN_LENGTH got 12 expected 24
Line 382: invalid SQL_DESC_OCTET_LENGTH got 12 expected 24
Line 388: invalid SQL_COLUMN_LENGTH got 13 expected 26
Line 392: invalid SQL_DESC_OCTET_LENGTH got 13 expected 26
Line 408: invalid SQL_COLUMN_LENGTH got 2048 expected 4096
Line 412: invalid SQL_DESC_OCTET_LENGTH got 2048 expected 4096
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
SET TEXTSIZE 4096
SELECT CONVERT(bit, 0) AS col
SELECT CONVERT(tinyint, 0) AS col
SELECT CONVERT(smallint, 0) AS col
SELECT CONVERT(int, 0) AS col
SELECT CONVERT(bigint, 0) AS col
SELECT CONVERT(real, 0) AS col
SELECT CONVERT(float, 0) AS col
SELECT CONVERT(smallmoney, 0) AS col
SELECT CONVERT(money, 0) AS col
SELECT CONVERT(numeric(10,2), 0) AS col
SELECT CONVERT(numeric(23,4), 0) AS col
SELECT CONVERT(datetime, '2006-04-14') AS col
SELECT CONVERT(smalldatetime, '2006-04-14') AS col
SELECT CONVERT(char(10), 'hi!') AS col
SELECT CONVERT(varchar(11), 'hi!') AS col
SELECT CONVERT(nchar(12), 'hi!') AS col
SELECT CONVERT(nvarchar(13), 'hi!') AS col
SELECT CONVERT(text, 'hi!') AS col
SELECT CONVERT(ntext, 'hi!') AS col
SELECT CONVERT(binary(10), 'hi!') AS col
SELECT CONVERT(varbinary(11), 'hi!') AS col
SELECT CONVERT(image, 'hi!') AS col
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
SET TEXTSIZE 4096
SELECT CONVERT(bit, 0) AS col
SELECT CONVERT(tinyint, 0) AS col
SELECT CONVERT(smallint, 0) AS col
SELECT CONVERT(int, 0) AS col
SELECT CONVERT(bigint, 0) AS col
SELECT CONVERT(real, 0) AS col
SELECT CONVERT(float, 0) AS col
SELECT CONVERT(smallmoney, 0) AS col
SELECT CONVERT(money, 0) AS col
SELECT CONVERT(numeric(10,2), 0) AS col
SELECT CONVERT(numeric(23,4), 0) AS col
SELECT CONVERT(datetime, '2006-04-14') AS col
SELECT CONVERT(smalldatetime, '2006-04-14') AS col
SELECT CONVERT(char(10), 'hi!') AS col
SELECT CONVERT(varchar(11), 'hi!') AS col
SELECT CONVERT(nchar(12), 'hi!') AS col
SELECT CONVERT(nvarchar(13), 'hi!') AS col
SELECT CONVERT(text, 'hi!') AS col
SELECT CONVERT(ntext, 'hi!') AS col
SELECT CONVERT(binary(10), 'hi!') AS col
SELECT CONVERT(varbinary(11), 'hi!') AS col
SELECT CONVERT(image, 'hi!') AS col
Done.
FAILED: describecol at Wed Jun 28 17:05:01 EDT 2006


Starting earlybind
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
CREATE TABLE #test(id INT, name VARCHAR(100))
INSERT INTO #test(id, name) VALUES(8, 'sysobjects')
SELECT id, name FROM #test WHERE name = 'sysobjects' SELECT 123, 'foo'
SELECT 321, 'minni'
Done.


Starting error
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
create table #tmp (i int)
insert into #tmp values(3)
insert into #tmp values(4)
insert into #tmp values(5)
insert into #tmp values(6)
insert into #tmp values(7)
select 100 / (i - 5) from #tmp order by i
Message: [FreeTDS][SQL Server]Divide by zero error encountered.
SELECT * FROM sysobjects
SELECT * FROM sysobjects
Message: [FreeTDS][SQL Server]Invalid cursor state
Done.


Starting funccall
SQL error 24000 -- [unixODBC][Driver Manager]Invalid cursor state
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
drop proc simpleresult
Unable to execute statement
create proc simpleresult @i int as begin return @i end
DECLARE @i INT
drop proc simpleresult
drop proc simpleresult2
create proc simpleresult2 @i int, @x int output, @y varchar(20) output
as begin select @x = 6789 select @y = 'test foo' return @i end
drop proc simpleresult2
Unable to execute statement
FAILED: funccall at Wed Jun 28 17:05:02 EDT 2006


Starting genparams
SQL error 24000 -- [unixODBC][Driver Manager]Invalid cursor state
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
drop proc spTestProc
Unable to execute statement
CREATE PROC spTestProc @i NUMERIC(18,2) OUTPUT AS SELECT @i =
CONVERT(NUMERIC(18,2), '123')
drop proc spTestProc
Unable to execute statement
FAILED: genparams at Wed Jun 28 17:05:02 EDT 2006


Starting getdata
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
SELECT CONVERT(TEXT,'Prova')
Done.


Starting insert_speed
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
DROP TABLE test
CREATE TABLE test(i int, c varchar(40))
DELETE FROM test
DROP TABLE test


Starting lang_error
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
SELECT DATEADD(dd,-100000,getdate())
Done.


Starting moreandcount
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
create table #tmp1 (i int)
create table #tmp2 (i int)
insert into #tmp1 values(1)
insert into #tmp1 values(2)
insert into #tmp1 values(5)
Use direct statement
Result 1
Result 2
Result 3
Result 4
Result 5
Use prepared statement
Result 1
Result 2
Done.


Starting norowset
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
drop proc sp_norowset_test
create proc sp_norowset_test as begin declare @i int end
exec sp_norowset_test
select name from master..sysobjects where name = 'sysobjects'
drop proc sp_norowset_test
Done.


Starting params
SQL error 24000 -- [unixODBC][Driver Manager]Invalid cursor state
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
drop proc spTestProc
CREATE PROCEDURE spTestProc
    @InParam int,
    @OutParam int OUTPUT,
    @OutString varchar(20) OUTPUT
AS
     SELECT @OutParam = @InParam
     SELECT @OutString = 'This is cool!'
     IF @InParam < 10
          RETURN (0)
     ELSE
          RETURN (1)

drop proc spTestProc
Unable to execute statement
FAILED: params at Wed Jun 28 17:05:04 EDT 2006


Starting prepare_results
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
create table #odbctestdata (i int, c char(20), n numeric(34,12) )
select * from #odbctestdata
drop table #odbctestdata
Done.


Starting prepclose
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
state=08S01 err=[FreeTDS][SQL Server]Write to SQL Server failed.
Done.


Starting preperror
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
CREATE TABLE #urls ( recdate DATETIME ) 
INSERT INTO #urls ( recdate ) VALUES ( '2003-10-1 10:11:1 0' )
err=[FreeTDS][SQL Server]The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value.
err=[FreeTDS][SQL Server]Invalid column name 'XXNOTCOLUMN'.
Done.


Starting print
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
print 'START' select count(*) from sysobjects where name='sysobjects'
print 'END'
Message: [unixODBC][FreeTDS][SQL Server]START
SELECT donotexistsfield FROM donotexiststable
Message: [FreeTDS][SQL Server]Invalid object name 'donotexiststable'.
Message: [unixODBC][Driver Manager]Function sequence error
Message: [unixODBC][Driver Manager]Function sequence error
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
print 'START' select count(*) from sysobjects where name='sysobjects'
print 'END'
Message: [unixODBC][FreeTDS][SQL Server]START
Message: [unixODBC][FreeTDS][SQL Server]END
SELECT donotexistsfield FROM donotexiststable
Message: [FreeTDS][SQL Server]Invalid object name 'donotexiststable'.
Message: [unixODBC][Driver Manager]Function sequence error
Message: [unixODBC][Driver Manager]Function sequence error
Done.


Starting putdata
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
CREATE TABLE #putdata (c TEXT NULL, b IMAGE NULL)
DECLARE @i INT
DECLARE @i2 INT
Done.


Starting raiseerror
Shared object "libiconv.so.4" not found
FAILED: raiseerror at Wed Jun 28 17:05:04 EDT 2006


Starting raiserror
SQLGetDiagRec error!
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
CREATE PROCEDURE #tmp1
    @InParam int,
    @OutParam int OUTPUT,
    @OutString varchar(20) OUTPUT
AS
     SET @OutParam = @InParam
     SET @OutString = 'This is bogus!'
     SELECT 'Here is the first row' AS FirstResult
     RAISERROR('An error occurred.', @InParam, 1)
     SELECT 'Here is the last row' AS LastResult
     RETURN (0)
ODBC 2 nocount no select yes level 5
RAISERROR('An error occurred.', 5, 1)
Result=0 DIAG REC 1: State=01000 Error=50000: [unixODBC][FreeTDS][SQL
Server]An error occurred.
Result=100 DIAG REC 1: State=00000 Error=0: 
FAILED: raiserror at Wed Jun 28 17:05:04 EDT 2006


Starting rpc
connecting
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
creating procedure
Dropping procedure freetds_odbc_rpc_test
Creating procedure freetds_odbc_rpc_test
running test
executing SQLAllocStmt
executing SQLBindParameter for parameter 1
executing SQLBindParameter for parameter 2
executing SQLBindParameter for parameter 3
executing SQLBindParameter for parameter 4
executing SQLBindParameter for parameter 5
executing SQLBindParameter for parameter 6
executing SQLPrepare: {?=call freetds_odbc_rpc_test(?,?,?,?,?)}
executing SQLExecute
executing SQLFetch (ignoring rows)
bound data for parameter 1 is 3 bytes: '134543152'.
bound data for parameter 2 is -1 bytes: ''.
bound data for parameter 3 is 3 bytes: ''.
bound data for parameter 4 is 4 bytes: '134543664'.
bound data for parameter 5 is 4 bytes: '134543680'.
bound data for parameter 6 is 3 bytes: ''.
executing SQLFreeStmt
dropping procedure
Done.


Starting scroll
../../../../src/odbc/unittests/scroll.c:72 SQLExecDirect
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
IF OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE #test
CREATE TABLE #test(i int, c varchar(6))
INSERT INTO #test(i, c) VALUES(1, 'a')
INSERT INTO #test(i, c) VALUES(2, 'bb')
INSERT INTO #test(i, c) VALUES(3, 'ccc')
INSERT INTO #test(i, c) VALUES(4, 'dddd')
INSERT INTO #test(i, c) VALUES(5, 'eeeee')
FAILED: scroll at Wed Jun 28 17:05:05 EDT 2006


Starting t0001
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
drop table #odbctestdata
Unable to execute statement
create table #odbctestdata (col1 varchar(30) not null,col2 int not
null,col3 float not null,col4 numeric(18,6) not null,col5 datetime not
null,col6 text not null)
insert #odbctestdata values
('ABCDEFGHIJKLMNOP',123456,1234.56,123456.78,'Sep 11 2001 10:00AM','just
to check returned length...')
select * from #odbctestdata
output data >ABCDEFGHIJKLMNOP< len_or_ind = 16
output data >123456< len_or_ind = 6
output data >1234.56< len_or_ind = 7
output data >123456.780000< len_or_ind = 13
output data >2001-09-11 10:00:00.000< len_or_ind = 23
output data >just to check returned length...< len_or_ind = 32
drop table #odbctestdata
Done.


Starting t0002
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
drop table #odbctestdata
Unable to execute statement
create table #odbctestdata (i int)
insert #odbctestdata values (123)
select * from #odbctestdata where 0=1
select * from #odbctestdata
drop table #odbctestdata
Done.


Starting t0003
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
create table #odbctestdata (i int)
select * from #odbctestdata select * from #odbctestdata
Getting next recordset
insert into #odbctestdata values(123)
select * from #odbctestdata select * from #odbctestdata
Getting next recordset
drop table #odbctestdata
create table #odbctestdata (i int)
Getting next recordset
insert into #odbctestdata values(123)
Getting next recordset
drop table #odbctestdata
Done.


Starting t0004
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
Done.


Starting tables
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
Test type '' with row
Test type ''SYSTEM TABLE'' with row
Test type ''TABLE'' without row
Test type ''SYSTEM TABLE'' with row
Test type 'TABLE' without row
Test type 'TABLE,VIEW' without row
Test type 'SYSTEM TABLE,'TABLE'' with row
Test type 'TABLE,'SYSTEM TABLE'' with row
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
Test type ''SYSTEM TABLE'' with row
Test type '' with row
Test type '' with row
Test type '' with row
Test type '' with row
Done.


Starting testodbc
Running test  1: Raw ODBC direct query... TestRawODBCDirectQuery (in)
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
CREATE TABLE #Products (ProductID int NOT NULL ,ProductName varchar (40)
,SupplierID int NULL ,CategoryID int NULL ,QuantityPerUnit varchar (20)
,UnitPrice money NULL ,UnitsInStock smallint NULL ,UnitsOnOrder smallint
NULL ,ReorderLevel smallint NULL ,Discontinued bit NOT NULL ) INSERT
INTO
#Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,Un
itPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued)
VALUES(1,'Chai',1,1,'10 boxes x 20 bags',18.00,39,0,10,0) INSERT INTO
#Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,Un
itPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued)
VALUES(2,'Chang',1,1,'24 - 12 oz bottles',19.00,17,40,25,0) INSERT INTO
#Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,Un
itPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued)
VALUES(3,'Aniseed Syrup',1,2,'12 - 550 ml bottles',10.00,13,70,25,0)
INSERT INTO
#Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,Un
itPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued)
VALUES(4,'Chef Anton''s Cajun Seasoning',2,2,'48 - 6 oz
jars',22.00,53,0,0,0) INSERT INTO
#Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,Un
itPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued)
VALUES(5,'Chef Anton''s Gumbo Mix',2,2,'36 boxes',21.35,0,0,0,1) 
Got 3 rows
TestRawODBCDirectQuery (out): ok
pass
Running test  2: Raw ODBC prepared query... TestRawODBCPreparedQuery
(in)
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
CREATE TABLE #Products (ProductID int NOT NULL ,ProductName varchar (40)
,SupplierID int NULL ,CategoryID int NULL ,QuantityPerUnit varchar (20)
,UnitPrice money NULL ,UnitsInStock smallint NULL ,UnitsOnOrder smallint
NULL ,ReorderLevel smallint NULL ,Discontinued bit NOT NULL ) INSERT
INTO
#Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,Un
itPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued)
VALUES(9,'Mishi Kobe Niku',4,6,'18 - 500 g pkgs.',97.00,29,0,0,1) INSERT
INTO
#Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,Un
itPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued)
VALUES(10,'Ikura',4,8,'12 - 200 ml jars',31.00,31,0,0,0) INSERT INTO
#Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,Un
itPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued)
VALUES(74,'Longlife Tofu',4,7,'5 kg pkg.',10.00,4,20,5,0) INSERT INTO
#Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,Un
itPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued)
VALUES(11,'Queso Cabrales',5,4,'1 kg pkg.',21.00,22,30,30,0) INSERT INTO
#Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,Un
itPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued)
VALUES(12,'Queso Manchego La Pastora',5,4,'10 - 500 g
pkgs.',38.00,86,0,0,0)
Got 3 rows
TestRawODBCPreparedQuery (out): ok
pass
Running test  3: Raw ODBC GUID... TestRawODBCGuid (in)
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
Creating #pet table
DROP PROC GetGUIDRows
Creating stored proc GetGUIDRows
Insert row 1
Insert row 2
Insert row 3
Insert row 4
Insert row 5
retrieving name and guid
name: Fang       guid: D424840B-AADD-4973-99E0-1E0268A55EB7
name: Splash     guid: 12345678-1234-1234-1234-123456789012
name: Woof       guid: 87654321-4321-4321-4321-123456789ABC
name: Spike      guid: 1234ABCD-ABCD-ABCD-ABCD-123456789ABC
name: Fluffy     guid: AABBCCDD-EEFF-1122-1122-334455667788
retrieving name and guid again
Fang       D424840B-AADD-4973-99E0-1E0268A55EB7
Splash     12345678-1234-1234-1234-123456789012
Woof       87654321-4321-4321-4321-123456789ABC
Spike      1234ABCD-ABCD-ABCD-ABCD-123456789ABC
Fluffy     AABBCCDD-EEFF-1122-1122-334455667788
retrieving name and guid
Woof       87654321-4321-4321-4321-123456789ABC
DROP PROC GetGUIDRows
TestRawODBCGuid (out): ok
pass

All 3 tests passed.



Starting timeout
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
drop table test_timeout
create table test_timeout(n numeric(18,0) primary key, t varchar(30))
insert into test_timeout(n, t) values(1, 'initial')
update test_timeout set t = 'second' where n = 1
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
update test_timeout set t = 'bad' where n = 1
drop table test_timeout


Starting transaction
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
DROP TABLE TestTransaction
CREATE TABLE TestTransaction ( value INT )
DROP PROCEDURE testinsert
CREATE PROCEDURE testinsert @value INT AS
INSERT INTO TestTransaction VALUES ( @value )
SELECT * FROM TestTransaction

DROP PROCEDURE testerror
CREATE PROCEDURE testerror AS
SELECT value FROM TestTransaction
SELECT value / (value-value) FROM TestTransaction

EXEC testinsert 1
EXEC testinsert 2
EXEC testerror
        1
SQLMoreResults returned -1
err=[FreeTDS][SQL Server]Divide by zero error encountered.
SQLMoreResults returned 100
DROP PROCEDURE testinsert
DROP PROCEDURE testerror
DROP PROCEDURE testinsert
CREATE PROCEDURE testinsert @value INT AS
INSERT INTO TestTransaction VALUES ( @value )

DROP PROCEDURE testerror
CREATE PROCEDURE testerror AS
SELECT value FROM TestTransaction
SELECT value / (value-value) FROM TestTransaction

EXEC testinsert 1
EXEC testinsert 2
EXEC testerror
        1
        1
SQLMoreResults returned -1
err=[FreeTDS][SQL Server]Divide by zero error encountered.
SQLMoreResults returned 100
DROP PROCEDURE testinsert
DROP PROCEDURE testerror
DROP TABLE TestTransaction
Done.


Starting type
Error setting type -5 (SQL_BIGINT)
Error setting type -3 (SQL_VARBINARY)
Error setting type -4 (SQL_LONGVARBINARY)
Error setting type 12 (SQL_VARCHAR)
Error setting type -1 (SQL_LONGVARCHAR)
Error setting type 3 (SQL_DECIMAL)
Error setting type 6 (SQL_FLOAT)
Error setting type 99 (SQL_C_DEFAULT)
Error setting type 9 (SQL_C_DATE)
Error setting type 10 (SQL_C_TIME)
Error setting type 91 (SQL_C_TYPE_DATE)
Error setting type 92 (SQL_C_TYPE_TIME)
Error setting type 101 (SQL_C_INTERVAL_YEAR)
Error setting type 102 (SQL_C_INTERVAL_MONTH)
Error setting type 103 (SQL_C_INTERVAL_DAY)
Error setting type 104 (SQL_C_INTERVAL_HOUR)
Error setting type 105 (SQL_C_INTERVAL_MINUTE)
Error setting type 106 (SQL_C_INTERVAL_SECOND)
Error setting type 107 (SQL_C_INTERVAL_YEAR_TO_MONTH)
Error setting type 108 (SQL_C_INTERVAL_DAY_TO_HOUR)
Error setting type 109 (SQL_C_INTERVAL_DAY_TO_MINUTE)
Error setting type 110 (SQL_C_INTERVAL_DAY_TO_SECOND)
Error setting type 111 (SQL_C_INTERVAL_HOUR_TO_MINUTE)
Error setting type 112 (SQL_C_INTERVAL_HOUR_TO_SECOND)
Error setting type 113 (SQL_C_INTERVAL_MINUTE_TO_SECOND)
Error setting type -25 (SQL_C_SBIGINT)
Error setting type -27 (SQL_C_UBIGINT)
Error setting type -16 (SQL_C_SLONG)
Error setting type -15 (SQL_C_SSHORT)
Error setting type -26 (SQL_C_STINYINT)
Error setting type -18 (SQL_C_ULONG)
Error setting type -17 (SQL_C_USHORT)
Error setting type -28 (SQL_C_UTINYINT)
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
Setted type SQL_C_CHAR -> [1 (SQL_C_CHAR), 1 (SQL_C_CHAR), 0]
Setted type SQL_C_LONG -> [4 (SQL_C_LONG), 4 (SQL_C_LONG), 0]
Setted type SQL_C_SHORT -> [5 (SQL_C_SHORT), 5 (SQL_C_SHORT), 0]
Setted type SQL_C_FLOAT -> [7 (SQL_C_FLOAT), 7 (SQL_C_FLOAT), 0]
Setted type SQL_C_DOUBLE -> [8 (SQL_C_DOUBLE), 8 (SQL_C_DOUBLE), 0]
Setted type SQL_C_NUMERIC -> [2 (SQL_C_NUMERIC), 2 (SQL_C_NUMERIC), 0]
Setted type SQL_C_DEFAULT -> [99 (SQL_C_DEFAULT), 99 (SQL_C_DEFAULT), 0]
Setted type SQL_C_DATE -> [91 (SQL_C_TYPE_DATE), 9 (SQL_C_DATE), 1]
Setted type SQL_C_TIME -> [92 (SQL_C_TYPE_TIME), 9 (SQL_C_DATE), 2]
Setted type SQL_C_TIMESTAMP -> [93 (SQL_C_TYPE_TIMESTAMP), 9
(SQL_C_DATE), 3]
Setted type SQL_C_TYPE_DATE -> [91 (SQL_C_TYPE_DATE), 9 (SQL_C_DATE), 1]
Setted type SQL_C_TYPE_TIME -> [92 (SQL_C_TYPE_TIME), 9 (SQL_C_DATE), 2]
Setted type SQL_C_TYPE_TIMESTAMP -> [93 (SQL_C_TYPE_TIMESTAMP), 9
(SQL_C_DATE), 3]
Setted type SQL_C_INTERVAL_YEAR -> [101 (SQL_C_INTERVAL_YEAR), 10
(SQL_C_TIME), 1]
Setted type SQL_C_INTERVAL_MONTH -> [102 (SQL_C_INTERVAL_MONTH), 10
(SQL_C_TIME), 2]
Setted type SQL_C_INTERVAL_DAY -> [103 (SQL_C_INTERVAL_DAY), 10
(SQL_C_TIME), 3]
Setted type SQL_C_INTERVAL_HOUR -> [104 (SQL_C_INTERVAL_HOUR), 10
(SQL_C_TIME), 4]
Setted type SQL_C_INTERVAL_MINUTE -> [105 (SQL_C_INTERVAL_MINUTE), 10
(SQL_C_TIME), 5]
Setted type SQL_C_INTERVAL_SECOND -> [106 (SQL_C_INTERVAL_SECOND), 10
(SQL_C_TIME), 6]
Setted type SQL_C_INTERVAL_YEAR_TO_MONTH -> [107
(SQL_C_INTERVAL_YEAR_TO_MONTH), 10 (SQL_C_TIME), 7]
Setted type SQL_C_INTERVAL_DAY_TO_HOUR -> [108
(SQL_C_INTERVAL_DAY_TO_HOUR), 10 (SQL_C_TIME), 8]
Setted type SQL_C_INTERVAL_DAY_TO_MINUTE -> [109
(SQL_C_INTERVAL_DAY_TO_MINUTE), 10 (SQL_C_TIME), 9]
Setted type SQL_C_INTERVAL_DAY_TO_SECOND -> [110
(SQL_C_INTERVAL_DAY_TO_SECOND), 10 (SQL_C_TIME), 10]
Setted type SQL_C_INTERVAL_HOUR_TO_MINUTE -> [111
(SQL_C_INTERVAL_HOUR_TO_MINUTE), 10 (SQL_C_TIME), 11]
Setted type SQL_C_INTERVAL_HOUR_TO_SECOND -> [112
(SQL_C_INTERVAL_HOUR_TO_SECOND), 10 (SQL_C_TIME), 12]
Setted type SQL_C_INTERVAL_MINUTE_TO_SECOND -> [113
(SQL_C_INTERVAL_MINUTE_TO_SECOND), 10 (SQL_C_TIME), 13]
Setted type SQL_C_BINARY -> [-2 (SQL_C_BINARY), -2 (SQL_C_BINARY), 0]
Setted type SQL_C_BIT -> [-7 (SQL_C_BIT), -7 (SQL_C_BIT), 0]
Setted type SQL_C_SBIGINT -> [-25 (SQL_C_SBIGINT), -25 (SQL_C_SBIGINT),
0]
Setted type SQL_C_UBIGINT -> [-27 (SQL_C_UBIGINT), -27 (SQL_C_UBIGINT),
0]
Setted type SQL_C_TINYINT -> [-6 (SQL_C_TINYINT), -6 (SQL_C_TINYINT), 0]
Setted type SQL_C_SLONG -> [-16 (SQL_C_SLONG), -16 (SQL_C_SLONG), 0]
Setted type SQL_C_SSHORT -> [-15 (SQL_C_SSHORT), -15 (SQL_C_SSHORT), 0]
Setted type SQL_C_STINYINT -> [-26 (SQL_C_STINYINT), -26
(SQL_C_STINYINT), 0]
Setted type SQL_C_ULONG -> [-18 (SQL_C_ULONG), -18 (SQL_C_ULONG), 0]
Setted type SQL_C_USHORT -> [-17 (SQL_C_USHORT), -17 (SQL_C_USHORT), 0]
Setted type SQL_C_UTINYINT -> [-28 (SQL_C_UTINYINT), -28
(SQL_C_UTINYINT), 0]
Setted type SQL_C_GUID -> [-11 (SQL_C_GUID), -11 (SQL_C_GUID), 0]


Setted type SQL_C_CHAR -> [1 (SQL_C_CHAR), 1 (SQL_C_CHAR), 0]
Setted type SQL_C_LONG -> [4 (SQL_C_LONG), 4 (SQL_C_LONG), 0]
Setted type SQL_C_SHORT -> [5 (SQL_C_SHORT), 5 (SQL_C_SHORT), 0]
Setted type SQL_C_FLOAT -> [7 (SQL_C_FLOAT), 7 (SQL_C_FLOAT), 0]
Setted type SQL_C_DOUBLE -> [8 (SQL_C_DOUBLE), 8 (SQL_C_DOUBLE), 0]
Setted type SQL_C_NUMERIC -> [2 (SQL_C_NUMERIC), 2 (SQL_C_NUMERIC), 0]
Setted type SQL_C_TIMESTAMP -> [93 (SQL_C_TYPE_TIMESTAMP), 9
(SQL_C_DATE), 3]
Setted type SQL_C_TYPE_TIMESTAMP -> [93 (SQL_C_TYPE_TIMESTAMP), 9
(SQL_C_DATE), 3]
Setted type SQL_C_BINARY -> [-2 (SQL_C_BINARY), -2 (SQL_C_BINARY), 0]
Setted type SQL_C_BIT -> [-7 (SQL_C_BIT), -7 (SQL_C_BIT), 0]
Setted type SQL_C_TINYINT -> [-6 (SQL_C_TINYINT), -6 (SQL_C_TINYINT), 0]
Setted type SQL_C_GUID -> [-11 (SQL_C_GUID), -11 (SQL_C_GUID), 0]
Setted type SQL_BIGINT -> [-5 (SQL_BIGINT), -5 (SQL_BIGINT), 0]
Setted type SQL_VARBINARY -> [-3 (SQL_VARBINARY), -3 (SQL_VARBINARY), 0]
Setted type SQL_LONGVARBINARY -> [-4 (SQL_LONGVARBINARY), -4
(SQL_LONGVARBINARY), 0]
Setted type SQL_VARCHAR -> [12 (SQL_VARCHAR), 12 (SQL_VARCHAR), 0]
Setted type SQL_LONGVARCHAR -> [-1 (SQL_LONGVARCHAR), -1
(SQL_LONGVARCHAR), 0]
Setted type SQL_DECIMAL -> [3 (SQL_DECIMAL), 3 (SQL_DECIMAL), 0]
Setted type SQL_FLOAT -> [6 (SQL_FLOAT), 6 (SQL_FLOAT), 0]


Starting typeinfo
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
Using ODBC version 2
select cast(getdate() as date)
odbctest
--------

connection parameters:
server:   'mpquant'
user:     'ProductDevelopmentWeb'
password: '????'
database: 'testdb'
use testdb
Using ODBC version 3
select cast(getdate() as date)
Done.

-----------------------------------------
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent 
responsible
for delivering this message to the intended recipient, any review, 
dissemination,
distribution or duplication of this communication is strictly prohibited. If 
you are
not the intended recipient, please contact the sender immediately by reply 
e-mail
and destroy all copies of the original message. Please note that we do not 
accept
account orders and/or instructions by e-mail, and therefore will not be 
responsible
for carrying out such orders and/or instructions.  If you, as the intended 
recipient
of this message, the purpose of which is to inform and update our clients, 
prospects
and consultants of developments relating to our services and products, would 
not
like to receive further e-mail correspondence from the sender, please "reply" 
to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New 
York,
NY 10105.