FreeTDS + MSSQL, sqlQuery is active, but no result when use next() func

[Pirus]

Client program sources on Qt.
Task: Find a "free" way to work with MSSQL under Linux.
I found FreeTDS (QTDS) and unixODBC + FreeTDS (QODBC), chose the option of working through QTDS plugin.

Qt: 4.8.4

Client OS:
Distributor ID: SUSE LINUX
Description: openSUSE 11.1 (i586)

FreeTDS: 0.91
./configure -prefix=/usr/local/freeTDS -enable-msdblib -with-tdsver=8.0
make install

QTDS plugin:
cd %QTDIR%/src/plugins/sqldrivers/tds
qmake -o Makefile "INCLUDEPATH=/usr/local/freeTDS/include" "LIBS=-L/usr/local/freeTDS/lib -lsybdb"
make install

Data MSSQL Server:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)

freetds.conf
[Global]
****# TDS protocol version
; Tds version = 4.2

# Whether to write a TDSDUMP file for diagnostic purposes
# (Setting this to /tmp is insecure on a multi-user system)
; Dump file = /tmp/freetds.log
; Debug flags = 0xffff

# Command and connection timeouts
; Timeout = 10
; Connect timeout = 10

# If you get out-of-memory errors, it may mean that your client
# Is trying to allocate a huge buffer for a TEXT field.
# Try setting 'text size' to a more reasonable limit
text size = 64512

[mycar1]
host = mycar1
port = 51451
tds version = 8.0

Test Project Code

#include <QtSql>
#include <QtCore/QCoreApplication>
#include <QTextCodec>
int main(int argc, char* argv[])
{
  QCoreApplication a(argc, argv);
  QSqlDatabase db = QSqlDatabase::addDatabase("QTDS");
  db.setDatabaseName("master");
  db.setHostName("MYCAR1");
  db.setUserName("admin");
  db.setPassword("");
  if (!db.open())
  {
    qDebug() << db.lastError().text();
    return 1;
  }
 
  QString queryS = "declare @i int set @i=123 select @i";
  //QString queryS = "select 123";
 
  qDebug() << queryS;
  QSqlQuery query;
  query.exec(queryS);
  //QTextCodec* codec1251 = QTextCodec::codecForName("CP1251");
  if (query.isActive())
  {
	qDebug() << "Active";
	if (query.next())
	{
		//QString res = codec1251->toUnicode(query.value(0).toByteArray());
		//qDebug() << res;
		qDebug() << query.value(0).toString();
	}
	else qDebug() << "No result";
  }
  else
  {
	qDebug() << query.lastError().text();
  }
  return 0;
}

#include <QtSql>
#include <QtCore/QCoreApplication>
#include <QTextCodec>
int main(int argc, char* argv[])
{
  QCoreApplication a(argc, argv);
  QSqlDatabase db = QSqlDatabase::addDatabase("QTDS");
  db.setDatabaseName("master");
  db.setHostName("MYCAR1");
  db.setUserName("admin");
  db.setPassword("");
  if (!db.open())
  {
    qDebug() << db.lastError().text();
    return 1;
  }

  QString queryS = "declare @i int set @i=123 select @i";
  //QString queryS = "select 123";

  qDebug() << queryS;
  QSqlQuery query;
  query.exec(queryS);
  //QTextCodec* codec1251 = QTextCodec::codecForName("CP1251");
  if (query.isActive())
  {
	qDebug() << "Active";
	if (query.next())
	{
		//QString res = codec1251->toUnicode(query.value(0).toByteArray());
		//qDebug() << res;
		qDebug() << query.value(0).toString();
	}
	else qDebug() << "No result";
  }
  else
  {
	qDebug() << query.lastError().text();
  }
  return 0;
}

To copy to clipboard, switch view to plain text mode 

Step by step:
1) I have installed Qt - Opensource, shared libs.
2) Installed the FreeTDS
3) Сompiled QTDS plugin
4) Сonfigured freetds.conf
5) export LD_LIBRARY_PATH = /usr/local/freeTDS/lib
6) Run a test project with a query "select 123", the result is "123" (excellent!)
7) Run a test project with a query "declare @i int set @i = 123 select @i", project returns "No result" (function isActive() returns true, function next() returns false - no data)

I do not understand what's wrong = (

I tried to execute queries through tsql - all excellent.
I tried work through QODBC plugin (unixODBC + freeTDS), problem is the same - a query is active, but no data.
isql like tsql executes queries and returns data correctly.

I think the trouble is somewhere in plugins.

Have any ideas?

[Lesiok]

whether the query should look like this

declare @i; int set @i = 123; select @i;

declare @i; int set @i = 123; select @i;

To copy to clipboard, switch view to plain text mode 

semicolons.
P.S.
You should test the result of exec(). If it is false dump error message.

[Pirus]

Now code looks like:

#include <QtSql>
#include <QtCore/QCoreApplication>
#include <QTextCodec>
int main(int argc, char* argv[])
{
  QCoreApplication a(argc, argv);
  qDebug() << "Prepearing...";
  QSqlDatabase db = QSqlDatabase::addDatabase("QTDS");
  db.setDatabaseName("master");
  db.setHostName("MYCAR1");
  db.setUserName("admin");
  db.setPassword("");
  qDebug() << "Opening...";
  if (!db.open())
  {
    qDebug() << db.lastError().text();
    return 1;
  }
 
  QString queryS = "declare @i int;\r\n\
set @i=123;\r\n\
select @i;";
 
  qDebug() << queryS;
  QSqlQuery query;
  qDebug() << "Execute query...";
  if (query.exec(queryS))
  {
    qDebug() << "good exec";
    if (query.isActive())
    {
  	qDebug() << "Active";
  	if (query.next())
  	{
  		qDebug() << query.value(0).toString();
  	}
  	else qDebug() << "No result";
    }
  }
  qDebug() << query.lastError().text();
  return 0;
}

#include <QtSql>
#include <QtCore/QCoreApplication>
#include <QTextCodec>
int main(int argc, char* argv[])
{
  QCoreApplication a(argc, argv);
  qDebug() << "Prepearing...";
  QSqlDatabase db = QSqlDatabase::addDatabase("QTDS");
  db.setDatabaseName("master");
  db.setHostName("MYCAR1");
  db.setUserName("admin");
  db.setPassword("");
  qDebug() << "Opening...";
  if (!db.open())
  {
    qDebug() << db.lastError().text();
    return 1;
  }

  QString queryS = "declare @i int;\r\n\
set @i=123;\r\n\
select @i;";

  qDebug() << queryS;
  QSqlQuery query;
  qDebug() << "Execute query...";
  if (query.exec(queryS))
  {
    qDebug() << "good exec";
    if (query.isActive())
    {
  	qDebug() << "Active";
  	if (query.next())
  	{
  		qDebug() << query.value(0).toString();
  	}
  	else qDebug() << "No result";
    }
  }
  qDebug() << query.lastError().text();
  return 0;
}

To copy to clipboard, switch view to plain text mode 

output:
Prepearing...
Opening...
"declare @i int;
set @i=123;
select @i;"
Execute query...
good exec
Active
No result
" "

So, problem persists (((