Error while Importing SQL Table's Metadata

[Former Member]

Hi

I am creating an External defination of category "dbtab". when i try to import the table in 3rd step i get this error.

"Error occurred while attempting to connect to database".

I checked the JDBC channel, in the channel getting this error "Error processing request in sax parser: Error when executing statement for table/stored proc. 'metadataRequest' (structure 'statement'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode."

Please help

[former_member181962 · Accepted solution]

Hi,

Check this discussion.

Also try setting AutoCommit = true (Check box in the JDBC adapter)

Regards,

Ravi Kanth Talagana

Edited by: Ravi Kanth Talagana on Oct 27, 2009 11:07 AM

[Former Member]

Thanks a lot.

I just set the AutoCommit = true (Check box in the JDBC adapter) and it worked