Re: MemoryError using Sybase, FreeTDS, MS SQL
Dave Cole <[email protected]>
| Newsgroups | gmane.comp.python.sybase |
|---|---|
| Message-ID | <[email protected]> |
> Knowing this, I've tried a similar query on a table that does not > have a text column and I get a different error. Here is part of the > output, the full output is attached in "output2". [snip] > ct_command(cmd1, CS_LANG_CMD, "SELECT * FROM FEMMD_AtomicInfo", CS_NULLTERM, CS_OPT_AUTHOFF) -> CS_SUCCEED [snip] > ct_describe(cmd1, 1, &fmt) -> CS_SUCCEED, datafmt0=[name:"guid" type:CS_FORCE_CLOSE status:CS_FALSE format:CS_FMT_UNUSED count:1 maxlength:16 scale:0 precision:0] Hmm... My debug code tries to convert the reported type of the column back into a text string and comes up with CS_FORCE_CLOSE!?! The debug code groups binary values into categories. When doing a lookup, it tries to resolve the value in the VAL_TYPE category and fails. It then just returns anything which matches the value. Looking at the FreeTDS header, this value corresponds to the type CS_UNIQUE_TYPE (which I don't have in my module). Maybe I should download the latest Sybase packages. Try building statements which select one column at a time to see which column types are causing the module to trip up. - Dave -- http://www.object-craft.com.au