Hello,

Can anybody help me out....I am getting following error 'Optional
feature not implemented' when i try to connect to SQL Server database
using SQL Server ODBC Driver Version 2000.85.1117.0. I am using SQL
Server 2000. Following code is a place where actually the output
returned is -1. All the parameters are passed correctly. Still i am
getting this error.

I have changed this piece of code since my application is UNICODE
enabled application.
Type of m_strQualifierParam, m_strOwnerParam, m_strNameParam,
m_strTypeParam is CString.


TRY
{
OnSetOptions(m_hstmt);
AllocStatusArrays();

// call the ODBC catalog function with data member params

AFX_SQL_ASYNC(this, (::SQLTables)(m_hstmt,
(m_strQualifierParam.IsEmpty()? (_TUCHAR FAR *)NULL: (_TUCHAR FAR
*)(const _TCHAR*)m_strQualifierParam), SQL_NTS,
(m_strOwnerParam.IsEmpty()? (_TUCHAR FAR *)NULL: (_TUCHAR FAR
*)(const _TCHAR*)m_strOwnerParam), SQL_NTS,
(m_strNameParam.IsEmpty()? (_TUCHAR FAR *)NULL: (_TUCHAR FAR
*)(const _TCHAR*)m_strNameParam), SQL_NTS,
(m_strTypeParam.IsEmpty()? (_TUCHAR FAR *)NULL: (_TUCHAR FAR
*)(const _TCHAR*)m_strTypeParam), SQL_NTS));



if (!Check(nRetCode))
ThrowDBException(nRetCode, m_hstmt);

// Allocate memory and cache info
AllocAndCacheFieldInfo();
AllocRowset();

// Fetch the first row of data
MoveNext();

// If EOF, result set is empty, set BOF as well
m_bBOF = m_bEOF;
}

This code works fine when i connect with ORACLE but fails with SQL
Server.
Guidance from anybody would be highly appreciated.

Thanks
Nishith Sheth