[asterisk-users] Fetching Binary data from SQL Server

Tilghman Lesher tilghman at mail.jeffandtilghman.com
Fri May 16 17:39:43 CDT 2008


On Friday 16 May 2008 16:10:22 Sanjay Rajdev wrote:
> I am trying to write a customized app using C that would fetch voice file
> from SQL Server 2000 using ODBC and FREETDS.
>
> Currently I am only able to fetch first 63 KB chunk from the DB, and not
> able to fetch the rest of the file, below is the code that i am using to do
> so,

Actually, if you Google, you'll find that in freetds.conf, the default 'text 
size' parameter is set to exactly 64512, which is the limit that FreeTDS
itself is placing on the data.  You might try increasing that (to a maximum
of 2GB) and see if that works better for you.

-- 
Tilghman



More information about the asterisk-users mailing list