Why can I get max 4096 characters of data from the database?

Mucahit

Hello everyone,

I successfully connect to the database and can receive data, but I can receive data at maximum 4096 characters. What is the reason of this ? I would be happy if anyone help. Thank you .My code is below :

QSqlDatabase db=QSqlDatabase::addDatabase("QODBC","myAwsomDatabase");
db.setDatabaseName("DRIVER={FreeTDS};SERVER=192.168.1.39;PORT=1433;DATABASE=name,UID=name,PWD=name");

if(db.open())
{
qDebug()<<"connected";
}
else
{
qDebug()<<"error";
}

QSqlQuery qry(db); // database query 


if(qry.exec("select top 1 Base from Resto64 where respath=''"))
{
while(qry.next())
{
qDebug()<<qry.value(0);
}
}
else
{
qDebug()<<db.lastError();
}

hskoglund

Hi, FreeTDS 7.0+ has 4096 as the default packet size, that's probably why you get that many characters in one row.
What happens if you change your query to "select top 2 Base from Resto64 where respath=''"?

Mucahit

Hi,

Is there anyway to increase this packet size by any properties or is there any otherway to get more data except FreeTDS ?

hskoglund

Have you tried Microsoft's native Linux ODBC drivers (instead of FreeTDS)?

Mucahit

I took the data on multiple lines as it will take time to install different drivers. Thank you.