BizTalk - Oracle ODBC Adapter not generating schema

When you try to generate schema for Oracle table/procedures using the Oracle ODBC adapter, it generates only one schema with a suffix _obj. It doesn't generate the actual schema with the table/procedure columns. See your event log if it has an error similar to this:

Exception occurred: HYC00 :
[Microsoft][ODBC driver for Oracle]Driver not capable

You are using a wrong ODBC driver. Do not use "Microsoft ODBC for Oracle", rather use the native driver ("Oracle in OraHome....") provided with Oracle Client tools.

No comments: