Incorrect syntax near '*'.

[Former Member]

Hi,

I got the following error "Incorrect syntax near '*'." during RFC to JDBC ( connection to SQL server) scenario. Please let me know what could be problem.

Appreciated for immediate reply.

Advanced Thanks,

Hari

[Former Member]

I got this erroe in Adapter engine. I did not write SQL statement explicitely. I have assigned INSERT statement to action.

Thanks,

Haricharan

[VijayKonam]

Is your RFC using any select statements? Is this error getting generated while you write to SQL server or getting data from RFC??

VJ

[Former Member]

I am getting error while inserting data into SQL server. There is no problem in RFC side.

Thanks,

Hari

[VijayKonam]

Post you message getting genrated while calling the SQL server..

VJ

[VijayKonam]

Where did this error occured? Adapter engine while calling the SQL statement? If you are using a select * kind of a query in adapter.. check for its validity.. by executing it directly in sql query analzer..

VJ