ODBC read fails

[#1]

Hello,

I am facing a strange problem. I am connecting to my microsoft sql server using ODBC and the connection is successful. I am able to select tables and am able to see the data in the table rows and columns. But when I save and load, the read fails giving me an error

ODBC read failed
SQL SELECT *
FROM "TMS_Data".dbo.billingterms

Can someone help on what's going on?

regards,

Manoj Agrawal

[suniljain]

Dear Manoj ,

pls Try with OLEDB , it will work fine in my case.

Regards,

Sunil Jain.

[#3]

I took this error ,

if you take scritp in db ,  your colomn name musn't similar , you have to give alias this column.

select

   a.name,

   b.name ,

   a.aaa,

   b.dfdfd,

   b.aaa

from a ,b;

[#4]

In my case, the problem was the column name length.