schoen wrote:
> Hi,
>
> When will a new version of the ODBC driver be
> available for Windows?
>
> Will the next version return any rows when calling
> SQLGetTypeInfo with SQL_DATE, SQL_TIMESTAMP
> and/or SQL_TYPE_DATE?
> The SAP DB Linux ODBC driver does...
Well, i've worked around this particular problem by
inserting the missing rows into the systemtables:
---8<-----8<-----8<---SNIP--
insert into
sysdba.sysodbctypes(type_name,data_type,nullable,case_sensitive,searchable,money,sql_data_type,precision,literal_prefix,literal_suffix,local_type_name)
values ('DATE', 91, 1,0,2,0,91,10,'''','''','DATE');
insert into
sysdba.sysodbctypes(type_name,data_type,nullable,case_sensitive,searchable,money,sql_data_type,precision,literal_prefix,literal_suffix,local_type_name)
values ('TIME', 92, 1,0,2,0,92,8,'''','''','TIME');
insert into
sysdba.sysodbctypes(type_name,data_type,nullable,case_sensitive,searchable,money,sql_data_type,precision,literal_prefix,literal_suffix,local_type_name)
values ('TIMESTAMP', 93, 1,0,2,0,93,26,'''','''','TIMESTAMP');
---8<-----8<-----8<---SNAP--
You'll see it yourself if you enable the ODBC-Trace and
inspect for which data the ODBC-driver is asking for.
Best Regards,
Peter
--
[EMAIL PROTECTED]
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
