9.0.01 ODBC driver return values changed for sqlGetTypeInfo

9.0.01 ODBC driver return values changed for sqlGetTypeInfo

am 27.10.2010 01:08:29 von the6campbells

--20cf301d3ed0df92eb04938d2fbc
Content-Type: text/plain; charset=ISO-8859-1

http://msdn.microsoft.com/en-us/library/ms714632(v=VS.85).as px

Using 8.4.2 driver on Windows

SQL_SUCCESS = SQLGetTypeInfo(StatementHandle = 0x36017c0,DataType
= SQL_ALL_TYPES)
SQL_SUCCESS = SQLBindCol(Statement Handle = 0x36017c0,ColumnNumber
= 1,TargetType = SQL_C_CHAR ,TargetValuePtr = 0x12c0b4,BufferLength =
1028,StrLen_or_IndPtr = 2084091336)
......
SQL_SUCCESS = SQLBindCol(Statement Handle = 0x36017c0,ColumnNumber
= 19,TargetType = SQL_C_SHORT ,TargetValuePtr = 0x12d544,BufferLength =
2,StrLen_or_IndPtr = 1230120)
SQL_SUCCESS = SQLFetch(StatementHandle = 0x36017c0)
Row=0,TYPE_NAME ,Type=SQL_C_CHAR ,bufLen=1028,size=4,data=int8
Row=0,DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
Row=0,COLUMN_SIZE ,Type=SQL_C_LONG ,bufLen=4,size=4,data=19
Row=0,LITERAL_PREFIX ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,LITERAL_SUFFIX ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,CREATE_PARAMS ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,NULLABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=1
Row=0,CASE_SENSITIVE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,SEARCHABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=2
Row=0,UNSIGNED_ATTRIBUTE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,FIXED_PREC_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,AUTO_UNIQUE_VALUE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,LOCAL_TYPE_NAME ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,MINIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,MAXIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,SQL_DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
Row=0,SQL_DATETIME_SUB ,Type=SQL_C_LONG ,bufLen=4,size=-1,data=(NULL)
Row=0,NUM_PREC_RADIX ,Type=SQL_C_LONG ,bufLen=4,size=4,data=10
Row=0,INTERVAL_PRECISION ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0


Using 9.0.01 driver on Windows

SQL_SUCCESS = SQLBindCol(Statement Handle = 0x36017c0,ColumnNumber
= 19,TargetType = SQL_C_SHORT ,TargetValuePtr = 0x12d544,BufferLength =
2,StrLen_or_IndPtr = 1230120)
SQL_SUCCESS = SQLFetch(StatementHandle = 0x36017c0)
Row=0,TYPE_NAME ,Type=SQL_C_CHAR ,bufLen=1028,size=4,data=int8
Row=0,DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
Row=0,COLUMN_SIZE ,Type=SQL_C_LONG ,bufLen=4,size=4,data=19
Row=0,LITERAL_PREFIX ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,LITERAL_SUFFIX ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,CREATE_PARAMS ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,NULLABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=1
Row=0,CASE_SENSITIVE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,SEARCHABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=2
Row=0,UNSIGNED_ATTRIBUTE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,FIXED_PREC_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,AUTO_UNIQUE_VALUE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,LOCAL_TYPE_NAME ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,MINIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,MAXIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,SQL_DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
Row=0,SQL_DATETIME_SUB ,Type=SQL_C_LONG ,bufLen=4,size=4,data=-5
<--------- DIFF
Row=0,NUM_PREC_RADIX ,Type=SQL_C_LONG ,bufLen=4,size=4,data=10
Row=0,INTERVAL_PRECISION ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0

--20cf301d3ed0df92eb04938d2fbc
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

..aspx">http://msdn.microsoft.com/en-us/library/ms714632(v=3 DVS.85).aspx=

Using 8.4.2 driver on Windows

<=
div>
SQL_SUCCESS =A0 =A0 =A0 =A0 =A0 =3D SQLGetTypeInfo(StatementHandle =3D 0x36=
017c0,DataType =3D SQL_ALL_TYPES)
SQL_SUCCESS =A0 =A0 =A0 =A0 =A0=
=3D SQLBindCol(Statement Handle =3D 0x36017c0,ColumnNumber =3D 1,TargetTyp=
e =3D SQL_C_CHAR =A0 =A0 ,TargetValuePtr =3D 0x12c0b4,BufferLength =3D 1028=
,StrLen_or_IndPtr =3D 2084091336)

.....
SQL_SUCCESS =A0 =A0 =A0 =A0 =A0 =3D SQLBindCol(Stateme=
nt Handle =3D 0x36017c0,ColumnNumber =3D 19,TargetType =3D SQL_C_SHORT =A0 =
=A0,TargetValuePtr =3D 0x12d544,BufferLength =3D 2,StrLen_or_IndPtr =3D 123=
0120)
SQL_SUCCESS =A0 =A0 =A0 =A0 =A0 =3D SQLFetch(StatementHandl=
e =3D 0x36017c0)

=A0Row=3D0,TYPE_NAME =A0 =A0 =A0 =A0 =A0,Type=3DSQL_C_CHAR =A0 =A0 ,bu=
fLen=3D1028,size=3D4,data=3Dint8
=A0Row=3D0,DATA_TYPE =A0 =A0 =A0=
=A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D-5
>=A0Row=3D0,COLUMN_SIZE =A0 =A0 =A0 =A0,Type=3DSQL_C_LONG =A0 =A0 ,bufLen=
=3D4,size=3D4,data=3D19
=A0Row=3D0,LITERAL_PREFIX =A0 =A0 ,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=
=3D1028,size=3D-1,data=3D(NULL)
=A0Row=3D0,LITERAL_SUFFIX =A0 =A0=
,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=3D1028,size=3D-1,data=3D(NULL)
v>=A0Row=3D0,CREATE_PARAMS =A0 =A0 =A0,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=3D=
1028,size=3D-1,data=3D(NULL)
=A0Row=3D0,NULLABLE =A0 =A0 =A0 =A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bu=
fLen=3D2,size=3D2,data=3D1
=A0Row=3D0,CASE_SENSITIVE =A0 =A0 ,Typ=
e=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0
=A0Row=3D0,S=
EARCHABLE =A0 =A0 =A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,d=
ata=3D2

=A0Row=3D0,UNSIGNED_ATTRIBUTE ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,s=
ize=3D2,data=3D0
=A0Row=3D0,FIXED_PREC_SCALE =A0 ,Type=3DSQL_C_SH=
ORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0
=A0Row=3D0,AUTO_UNIQUE_V=
ALUE =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0

=A0Row=3D0,LOCAL_TYPE_NAME =A0 =A0,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=
=3D1028,size=3D-1,data=3D(NULL)
=A0Row=3D0,MINIMUM_SCALE =A0 =A0 =
=A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0
=A0Ro=
w=3D0,MAXIMUM_SCALE =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=
=3D2,data=3D0

=A0Row=3D0,SQL_DATA_TYPE =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=
=3D2,size=3D2,data=3D-5
=A0Row=3D0,SQL_DATETIME_SUB =A0 ,Type=3DS=
QL_C_LONG =A0 =A0 ,bufLen=3D4,size=3D-1,data=3D(NULL)
=A0Row=3D0,=
NUM_PREC_RADIX =A0 =A0 ,Type=3DSQL_C_LONG =A0 =A0 ,bufLen=3D4,size=3D4,data=
=3D10

=A0Row=3D0,INTERVAL_PRECISION ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,s=
ize=3D2,data=3D0


Using 9.0.01=
driver on Windows

SQL_SUCCESS =A0 =A0 =A0 =
=A0 =A0 =3D SQLBindCol(Statement Handle =3D 0x36017c0,ColumnNumber =3D 19,T=
argetType =3D SQL_C_SHORT =A0 =A0,TargetValuePtr =3D 0x12d544,BufferLength =
=3D 2,StrLen_or_IndPtr =3D 1230120)

SQL_SUCCESS =A0 =A0 =A0 =A0 =A0 =3D SQLFetch(StatementHandle =3D 0x360=
17c0)
=A0Row=3D0,TYPE_NAME =A0 =A0 =A0 =A0 =A0,Type=3DSQL_C_CHAR =
=A0 =A0 ,bufLen=3D1028,size=3D4,data=3Dint8
=A0Row=3D0,DATA_TYPE =
=A0 =A0 =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D-=
5

=A0Row=3D0,COLUMN_SIZE =A0 =A0 =A0 =A0,Type=3DSQL_C_LONG =A0 =A0 ,bufL=
en=3D4,size=3D4,data=3D19
=A0Row=3D0,LITERAL_PREFIX =A0 =A0 ,Type=
=3DSQL_C_CHAR =A0 =A0 ,bufLen=3D1028,size=3D-1,data=3D(NULL)
=A0R=
ow=3D0,LITERAL_SUFFIX =A0 =A0 ,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=3D1028,siz=
e=3D-1,data=3D(NULL)

=A0Row=3D0,CREATE_PARAMS =A0 =A0 =A0,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=
=3D1028,size=3D-1,data=3D(NULL)
=A0Row=3D0,NULLABLE =A0 =A0 =A0 =
=A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D1
=
=A0Row=3D0,CASE_SENSITIVE =A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,si=
ze=3D2,data=3D0

=A0Row=3D0,SEARCHABLE =A0 =A0 =A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufL=
en=3D2,size=3D2,data=3D2
=A0Row=3D0,UNSIGNED_ATTRIBUTE ,Type=3DSQ=
L_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0
=A0Row=3D0,FIXED_P=
REC_SCALE =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0 >
=A0Row=3D0,AUTO_UNIQUE_VALUE =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2=
,size=3D2,data=3D0
=A0Row=3D0,LOCAL_TYPE_NAME =A0 =A0,Type=3DSQL_=
C_CHAR =A0 =A0 ,bufLen=3D1028,size=3D-1,data=3D(NULL)
=A0Row=3D0,=
MINIMUM_SCALE =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,da=
ta=3D0

=A0Row=3D0,MAXIMUM_SCALE =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=
=3D2,size=3D2,data=3D0
=A0Row=3D0,SQL_DATA_TYPE =A0 =A0 =A0,Type=
=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D-5
=A0Row=3D0,S=
QL_DATETIME_SUB =A0 ,Type=3DSQL_C_LONG =A0 =A0 ,bufLen=3D4,size=3D4,data=3D=
-5 <--------- DIFF

=A0Row=3D0,NUM_PREC_RADIX =A0 =A0 ,Type=3DSQL_C_LONG =A0 =A0 ,bufLen=
=3D4,size=3D4,data=3D10
=A0Row=3D0,INTERVAL_PRECISION ,Type=3DSQL=
_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0



--20cf301d3ed0df92eb04938d2fbc--

Re: 9.0.01 ODBC driver return values changed for sqlGetTypeInfo

am 27.10.2010 21:28:12 von Hiroshi Inoue

Thanks for the report.
Could you please try the drivers on testing for 9.0.0102 at
http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/
?

regards,
Hiroshi Inoue

(2010/10/27 8:08), the6campbells wrote:
> http://msdn.microsoft.com/en-us/library/ms714632(v=VS.85).as px
>
> Using 8.4.2 driver on Windows
>
> SQL_SUCCESS = SQLGetTypeInfo(StatementHandle =
> 0x36017c0,DataType = SQL_ALL_TYPES)
> SQL_SUCCESS = SQLBindCol(Statement Handle =
> 0x36017c0,ColumnNumber = 1,TargetType = SQL_C_CHAR ,TargetValuePtr =
> 0x12c0b4,BufferLength = 1028,StrLen_or_IndPtr = 2084091336)
> .....
> SQL_SUCCESS = SQLBindCol(Statement Handle =
> 0x36017c0,ColumnNumber = 19,TargetType = SQL_C_SHORT ,TargetValuePtr
> = 0x12d544,BufferLength = 2,StrLen_or_IndPtr = 1230120)
> SQL_SUCCESS = SQLFetch(StatementHandle = 0x36017c0)
> Row=0,TYPE_NAME ,Type=SQL_C_CHAR
> ,bufLen=1028,size=4,data=int8
> Row=0,DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
> Row=0,COLUMN_SIZE ,Type=SQL_C_LONG ,bufLen=4,size=4,data=19
> Row=0,LITERAL_PREFIX ,Type=SQL_C_CHAR
> ,bufLen=1028,size=-1,data=(NULL)
> Row=0,LITERAL_SUFFIX ,Type=SQL_C_CHAR
> ,bufLen=1028,size=-1,data=(NULL)
> Row=0,CREATE_PARAMS ,Type=SQL_C_CHAR
> ,bufLen=1028,size=-1,data=(NULL)
> Row=0,NULLABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=1
> Row=0,CASE_SENSITIVE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
> Row=0,SEARCHABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=2
> Row=0,UNSIGNED_ATTRIBUTE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
> Row=0,FIXED_PREC_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
> Row=0,AUTO_UNIQUE_VALUE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
> Row=0,LOCAL_TYPE_NAME ,Type=SQL_C_CHAR
> ,bufLen=1028,size=-1,data=(NULL)
> Row=0,MINIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
> Row=0,MAXIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
> Row=0,SQL_DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
> Row=0,SQL_DATETIME_SUB ,Type=SQL_C_LONG
> ,bufLen=4,size=-1,data=(NULL)
> Row=0,NUM_PREC_RADIX ,Type=SQL_C_LONG ,bufLen=4,size=4,data=10
> Row=0,INTERVAL_PRECISION ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
>
>
> Using 9.0.01 driver on Windows
>
> SQL_SUCCESS = SQLBindCol(Statement Handle =
> 0x36017c0,ColumnNumber = 19,TargetType = SQL_C_SHORT ,TargetValuePtr
> = 0x12d544,BufferLength = 2,StrLen_or_IndPtr = 1230120)
> SQL_SUCCESS = SQLFetch(StatementHandle = 0x36017c0)
> Row=0,TYPE_NAME ,Type=SQL_C_CHAR
> ,bufLen=1028,size=4,data=int8
> Row=0,DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
> Row=0,COLUMN_SIZE ,Type=SQL_C_LONG ,bufLen=4,size=4,data=19
> Row=0,LITERAL_PREFIX ,Type=SQL_C_CHAR
> ,bufLen=1028,size=-1,data=(NULL)
> Row=0,LITERAL_SUFFIX ,Type=SQL_C_CHAR
> ,bufLen=1028,size=-1,data=(NULL)
> Row=0,CREATE_PARAMS ,Type=SQL_C_CHAR
> ,bufLen=1028,size=-1,data=(NULL)
> Row=0,NULLABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=1
> Row=0,CASE_SENSITIVE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
> Row=0,SEARCHABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=2
> Row=0,UNSIGNED_ATTRIBUTE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
> Row=0,FIXED_PREC_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
> Row=0,AUTO_UNIQUE_VALUE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
> Row=0,LOCAL_TYPE_NAME ,Type=SQL_C_CHAR
> ,bufLen=1028,size=-1,data=(NULL)
> Row=0,MINIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
> Row=0,MAXIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
> Row=0,SQL_DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
> Row=0,SQL_DATETIME_SUB ,Type=SQL_C_LONG ,bufLen=4,size=4,data=-5
> <--------- DIFF
> Row=0,NUM_PREC_RADIX ,Type=SQL_C_LONG ,bufLen=4,size=4,data=10
> Row=0,INTERVAL_PRECISION ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc