<html><head><style type='text/css'>p { margin: 0; }</style><style type='text/css'>body { font-family: 'Times New Roman'; font-size: 12pt; color: #000000}</style></head><body>Tilghmanm,<br><br>Thanks a lot, I have changed the value in FREETDS and it worked.<br><br><br>Regards,<br>Sanjay Rajdev<br><br>----- Original Message -----<br>From: "Tilghman Lesher" <tilghman@mail.jeffandtilghman.com><br>To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com><br>Sent: Saturday, May 17, 2008 4:09:43 AM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi<br>Subject: Re: [asterisk-users] Fetching Binary data from SQL Server<br><br>On Friday 16 May 2008 16:10:22 Sanjay Rajdev wrote:<br>> I am trying to write a customized app using C that would fetch voice file<br>> from SQL Server 2000 using ODBC and FREETDS.<br>><br>> Currently I am only able to fetch first 63 KB chunk from the DB, and not<br>> able to fetch the rest of the file, below is the code that i am using to do<br>> so,<br><br>Actually, if you Google, you'll find that in freetds.conf, the default 'text <br>size' parameter is set to exactly 64512, which is the limit that FreeTDS<br>itself is placing on the data. You might try increasing that (to a maximum<br>of 2GB) and see if that works better for you.<br><br>-- <br>Tilghman<br><br>_______________________________________________<br>-- Bandwidth and Colocation Provided by http://www.api-digital.com --<br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> http://lists.digium.com/mailman/listinfo/asterisk-users<br></body></html>