c1fuller
asked on
A VC++ using ODBC / MS-SQL Server implementaion question...
SQLGetDiagRec returns the following error message from SQLBindParameter call:
HYC00 0 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented
This is while attempting to bind variables using the following conversion:
struct bind_list
{
SQLSMALLINT iotype;
SQLPOINTER valueptr;
int updateable;
SQLSMALLINT paramtype;
SQLINTEGER bufferlen;
};
struct bind_list PMT_Bndlst[] =
{
{SQL_C_CHAR , pmtfl_currpay_dt , FALSE, SQL_TYPE_DATE, (SDWORD)(sizeof(pmtfl_curr pay_dt))},
{SQL_C_CHAR , pmtfl_lastpay_dt , TRUE , SQL_TYPE_DATE, (SDWORD)(sizeof(pmtfl_last pay_dt))},
{SQL_C_CHAR , pmtfl_nextpay_dt , TRUE , SQL_TYPE_DATE, (SDWORD)(sizeof(pmtfl_next pay_dt))}, ...
sample delcaration of variable is as folows:
char pmtfl_lastpay_dt[24];
The data being queried is from MS-SQL Server, in a datetime field, appearing as follows:
1996-01-25 00:00:00.000
I have read the ODBC help docs and am unable to solve. Is this driver related? I need a solution to this problem.
HYC00 0 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented
This is while attempting to bind variables using the following conversion:
struct bind_list
{
SQLSMALLINT iotype;
SQLPOINTER valueptr;
int updateable;
SQLSMALLINT paramtype;
SQLINTEGER bufferlen;
};
struct bind_list PMT_Bndlst[] =
{
{SQL_C_CHAR , pmtfl_currpay_dt , FALSE, SQL_TYPE_DATE, (SDWORD)(sizeof(pmtfl_curr
{SQL_C_CHAR , pmtfl_lastpay_dt , TRUE , SQL_TYPE_DATE, (SDWORD)(sizeof(pmtfl_last
{SQL_C_CHAR , pmtfl_nextpay_dt , TRUE , SQL_TYPE_DATE, (SDWORD)(sizeof(pmtfl_next
sample delcaration of variable is as folows:
char pmtfl_lastpay_dt[24];
The data being queried is from MS-SQL Server, in a datetime field, appearing as follows:
1996-01-25 00:00:00.000
I have read the ODBC help docs and am unable to solve. Is this driver related? I need a solution to this problem.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.