Skip to Content.
Sympa Menu

freetds - [freetds] Problem with FreeTDS and Sybase Anywhere

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Ing. David Hübner - eBRÁNA s.r.o. <hubner AT ebrana.cz>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Problem with FreeTDS and Sybase Anywhere
  • Date: Wed, 14 Feb 2007 13:19:18 +0100

Hello,

I have problem with textfields length when I am recieving data from Sybase
Anywhere server version 7. I am using TDS version 5.0. Everything is working
perfectly, but all textfield are cutted to size of 4kB.

I have tried to set TEXTSIZE to greater value, but it is not working and
server is returning SQL error ASA Error -131: Syntax error near 'use' on
line 1, here is the log record:

09:27:49.894717 Sending packet
0000 0f 01 00 2f 00 00 00 00-21 22 00 00 00 00 73 65 |.../.... !"....se|
0010 74 20 74 65 78 74 73 69-7a 65 20 31 36 37 37 37 |t textsi ze 16777|
0020 32 31 36 20 75 73 65 20-4d 53 43 32 30 30 34 |216 use MSC2004|

09:27:49.917126 Received header
0000 04 01 00 5a 00 00 00 00- |...Z....|

09:27:49.917195 Received packet
0000 e5 46 00 66 00 00 00 00-0f 05 34 32 57 30 34 00 |.F.f.... ..42W04.|
0010 01 00 31 00 41 53 41 20-45 72 72 6f 72 20 2d 31 |..1.ASA Error -1|
0020 33 31 3a 20 53 79 6e 74-61 78 20 65 72 72 6f 72 |31: Synt ax error|
0030 20 6e 65 61 72 20 27 75-73 65 27 20 6f 6e 20 6c | near 'u se' on l|
0040 69 6e 65 20 31 00 00 00-00 fd 02 00 01 00 00 00 |ine 1... ........|
0050 00 00 - |..|

09:27:49.917242 processing result tokens. marker is e5(EED)
09:27:49.917278 tds_process_default_tokens() marker is e5(EED)
09:27:49.917306 tds_get_string: reading 49 from wire to give 49 to client.
09:27:49.917369 processing result tokens. marker is fd(DONE)
09:27:49.917393 tds_process_end: more_results = 0
was_cancelled = 0
error = 1
done_count_valid = 0
09:27:49.917416 tds_process_end() state set to TDS_IDLE
09:27:49.917440 tds_free_all_results()

If I set texsize manually after ODBC connect directly as SQL command, it is
processed, but without expecting result.

Can you help me with this text size problem (max 4kB), please?

Thanks David Hubner.



  • [freetds] Problem with FreeTDS and Sybase Anywhere, Ing . David Hübner - eBRÁNA s . r . o ., 02/14/2007

Archive powered by MHonArc 2.6.24.

Top of Page