[asterisk-users] Fetching Binary data from SQL Server

Sanjay Rajdev sanjay.rajdev at featherstoneinformatics.com
Fri May 16 17:55:07 CDT 2008


Tilghmanm, 

Thanks a lot, I have changed the value in FREETDS and it worked. 


Regards, 
Sanjay Rajdev 

----- Original Message ----- 
From: "Tilghman Lesher" <tilghman at mail.jeffandtilghman.com> 
To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users at lists.digium.com> 
Sent: Saturday, May 17, 2008 4:09:43 AM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi 
Subject: Re: [asterisk-users] Fetching Binary data from SQL Server 

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 

_______________________________________________ 
-- Bandwidth and Colocation Provided by http://www.api-digital.com -- 

asterisk-users mailing list 
To UNSUBSCRIBE or update options visit: 
http://lists.digium.com/mailman/listinfo/asterisk-users 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080517/43a68caa/attachment.htm 


More information about the asterisk-users mailing list