ODBC Driver Issues

Posted by Admin on 23-Feb-2007 12:48

I posted this question in another forum and they told me to try here.... Let's try.

Hello there,

I'm not a Progress developer, but I'm using Progress from some .Net applications through ODBC connection and having some problems.

I need to query the _File table, and when I'm querying

select "_File-name", "_Desc" from pub."_File"

I have the error:

=== SQL Exception 1 ===

SQLState=HY000

ErrorCode=-210012

:Column Desc in table PUB.File has value exceeding its max length or precision.

(This happens in SQL Explorer too).

When I export a .df from this database, I notice that the DESCRIPTION of one table is ~200 chars. In the dictionary this field has 144 chars. Anyway to workaround this problem without doing some modifications to the database?

Is there any way to truncate the field without taking this error? Or to set the SQL Width through ODBC?

Thanks in Advance,

Eric Lemes

All Replies

Posted by Alon Blich on 23-Feb-2007 13:06

Have a look at the DBTOOL utility in the Database Administration doc, though, I don't know how it will work with the schema tables.

http://www.psdn.com/library/entry.jspa?externalID=1913&categoryID=462

http://www.psdn.com/library/servlet/KbServlet/download/1913-102-2616/dmadm.pdf

Reference Chapter > Other Database Administration Utilities > DBTOOL utility

HTH

This thread is closed