I am writing a .NET windows application which utilizes the DataDirect 4.1 SQL 92 ODBC Driver.
I am getting a strange error when I run select statements against some tables. I can query _user just fine, but when I run a select (select * from pub.oeeh) on a different table I typically get this error:
System.Data.Odbc.OdbcException: ERROR [HY000] [DataDirect][ODBC PROGRESS driver][PROGRESS]Column keyindex in table PUB.oeeh has value exceeding its max length or precision.
I am running this query as sysprogress so there should'nt be any issues with permission. Now if I have the DBA run this query from character mode, he gets the result set without error.
What could be causing this strange error??
I am getting a strange error when I run select statements against some tables. I can query _user just fine, but when I run a select (select * from pub.oeeh) on a different table I typically get this error:
System.Data.Odbc.OdbcException: ERROR [HY000] [DataDirect][ODBC PROGRESS driver][PROGRESS]Column keyindex in table PUB.oeeh has value exceeding its max length or precision.
I am running this query as sysprogress so there should'nt be any issues with permission. Now if I have the DBA run this query from character mode, he gets the result set without error.
What could be causing this strange error??