VoIP Mailing List Archives
Mailing list archives for the VoIP community |
|
| View previous topic :: View next topic |
| Author |
Message |
tilghman at mail.jeffa...
Guest
|
 Posted: Fri May 16, 2008 5:27 pm Post subject: [asterisk-users] Fetching Binary data from SQL Server |
 |
|
On Friday 16 May 2008 16:10:22 Sanjay Rajdev wrote:
| Quote: | 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,
//Trying to fetch data in chunks
for (offset = 0; offset < colsize; offset += CHUNKSIZE) {
|
What is your value of CHUNKSIZE?
--
Tilghman |
|
| Back to top |
|
 |
tilghman at mail.jeffa...
Guest
|
| Posted: Fri May 16, 2008 5:39 pm Post subject: [asterisk-users] Fetching Binary data from SQL Server |
|
|
On Friday 16 May 2008 16:10:22 Sanjay Rajdev wrote:
| Quote: | 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 |
|
| Back to top |
|
|
sanjay.rajdev at feath...
Guest
|
| Posted: Fri May 16, 2008 5:55 pm Post subject: [asterisk-users] Fetching Binary data from SQL Server |
|
|
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:
| Quote: | 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 |
|
| Back to top |
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
Search
