Hi,
I am using otl lib for database related operations. I am trying to get the table schema using sqlcolumns (provided for odbc supported databases for getting table columns information). I am getting an error "Optional feature not implemented". Please help me out in this matter.

Thanks,
Asif

Hi Asif,

>> I am using otl lib for database related operations.

Did you install the right ODBC driver?

http://www.oracle.com/technology/software/...odbc/index.html

****************************************************
>> I am getting an error "Optional feature not implemented".

OK, please paste-in the call and the whole error message!

Thanks for responding.
I have used this call "$SQLColumns $1:'dbname' $:'' $3:'tablename'" . Sqlcolumns is provided for getting the table columns from any database that supports odbc. This is not oracle version of sqlcolumns.The error is "Optional features not implemented". I have downloaded the latest driver but getting the same error even after installing the driver. Waiting for your positive reply.

Thanks,
Asif

I was doing R&D on this and i found that the catalog options is by default off(disable). Do you know something about this ? How can I Enable Catalog options ? I think that this is creating problem in my case.

>> can I Enable Catalog options ?

Read the docs, it;s there:

http://www.datadirect.com/products/odbc/or...r_faq/index.ssp

"click the Advanced and Performance tabs to specify data source settings such as Default User Name, Array Size, Lock Timeout, Default Buffer Size for Long/LOB Columns, and Catalog Options"