Oracle ODBC driver SQLBindCol & SQLBindParameter pbs

From: vincent terrisse <vterrisse_at_infovista.fr>
Date: Tue, 17 Aug 1999 09:08:23 +0200
Message-ID: <37B90A67.93708456@infovista.fr>

I work with an ODBC C++ application that makes request to Oracle 8 server ( using Oracle ODBC driver).

I've got two questions:

-The Oracle driver does not seem to fill the SQL_TIMESTAMP_STRUCT buffer
that was bound calling SQLBindCol on a smalldatetime column. In fact, i observed that the timestamps are only retrieved as char calling SQLBindCol with SQL_C_CHAR instead of SQL_C_TYPE_TIMESTAMP for C data type attribute.
Does the use of a SQL_TIMESTAMP_STRUCT as a C buffer is driver dependent and can i ask the driver if it is capable for this?

-I can't execute a statement with a binding parameter on a unicode
string column.
I've tried to set SQLBindParameter with SQL_WCHAR as SQL data type but it crashes the driver (i've even tried to set C data type to SQL_CHAR and SQL_WCHAR as SQL data type but i get a "Character set mismatch" error).

have you experienced this before?
What can i do?
The ODBC application works fine with SQL Server 7 (so i think the application makes correct ODBC calls).

thanks a lot
vincent Received on Tue Aug 17 1999 - 02:08:23 CDT