Very Computer

Hi,

I have written an extended stored procedure dll for SQL server 6.5 which
I use to run select statements on an Oracle Database using a system DSN.

I use the following functions:

SQLColAttribute(hstmt, i, SQL_DESC_CONCISE_TYPE,  NULL, 0, NULL,
(SQLPOINTER) &SQLType);

- returns the ODBC SQL type in variable SQLType (e.g. SQL_VARCHAR)

SQLBindCol(hstmt, i, SQLType, data[i], ColLen[i], &ColLenT[i]);

- needs the ODBC C data type in SQLType (e.g. SQL_C_CHAR);

how can I convert the ODBC SQL data type to an ODBC C data type ?

Besides that, the extended stored procedure will return the data in a result
set
which I use the following function:

srv_describe(srvproc, i, &ColName[i], SRV_NULLTERM, SQLType[i], (DBINT)
ColLen[i], SQLType[i], (DBINT) ColLen[i], (BYTE *) NULL);

How can I convert the ODBC SQL data type or ODBC C data type to ODS data
type (e.g. SRVCHAR) ?

thanks in advance

Robbert Veldhuijsen

I now use a switch statement in which I convert SQL_VARCHAR to SQL_C_CHAR
and set the ODS data type to SVRVARCHAR

Also I use SQLColAttribute with 'SQL_DESC_OCTET_LENGTH' to determine the
maximum
size of the varchar column.

This doesn't work with the Oracle ODBC driver ('Descriptor type is out of
range' - probably wrong ODBC version) nor with the SQL server ODBC driver:

the varchar colum length returned with SQL_DESC_LENGTH or
SQL_DESC_OCTET_LENGTH are the same value, that is, the length of the Column
Name (? 8-)

With the Oracle ODBC driver, SQL_DESC_LENGTH on varchar2 (which is returned
as type SQL_VARCHAR) does work (but should not as described by microsoft)

Does anyone know what might be wrong ?

thanks in advance

Quote:> Hi,

> I have written an extended stored procedure dll for SQL server 6.5 which
> I use to run select statements on an Oracle Database using a system DSN.

> I use the following functions:

> SQLColAttribute(hstmt, i, SQL_DESC_CONCISE_TYPE,  NULL, 0, NULL,
> (SQLPOINTER) &SQLType);

> - returns the ODBC SQL type in variable SQLType (e.g. SQL_VARCHAR)

> SQLBindCol(hstmt, i, SQLType, data[i], ColLen[i], &ColLenT[i]);

> - needs the ODBC C data type in SQLType (e.g. SQL_C_CHAR);

> how can I convert the ODBC SQL data type to an ODBC C data type ?

> Besides that, the extended stored procedure will return the data in a
result
> set
> which I use the following function:

> srv_describe(srvproc, i, &ColName[i], SRV_NULLTERM, SQLType[i], (DBINT)
> ColLen[i], SQLType[i], (DBINT) ColLen[i], (BYTE *) NULL);

> How can I convert the ODBC SQL data type or ODBC C data type to ODS data
> type (e.g. SRVCHAR) ?

> thanks in advance

> Robbert Veldhuijsen