DS 4.2 Reading SAP table issue with RFC data transfer method

[Former Member]

All,

I am trying to read tables from SAP using ABAP data flow, in SAP data store settings we used data transfer method as RFC and job failing with below error

"ODBC data source <QADB> error message for operation <SQLExecute><[Microsoft][SQL Server Native Client 10.0]Invalid  character value for cast specification>"

when i change Data transfer method from RFC to shared directory , its working fine. I just didn't get it.

can you please help me if you have faced this issue before or any idea about this issue.

Thanks a lot

[DayaJha]

Hi Surya,

Please refer the below thread regarding Micosoft Native Driver Issue

Please refer below thread for RFC configuration

Hope this will help!!!!

Thanks,

Daya

[Former Member]

Thanks Daya !

the above threads are not much related to my issue.