Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dear Manoj ,
pls Try with OLEDB , it will work fine in my case.
Regards,
Sunil Jain.
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;
In my case, the problem was the column name length.