Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error while Importing SQL Table's Metadata

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 Member
replied

Hi,

Check this discussion.

JDBC Channel : Connection reset

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question