[Bug 253952] Re: SELECT don't work in libqt4-sql-odbc with IBM ISeries driver
The problem was fixed in UBUNTU 9.04. Tanks! -- SELECT don't work in libqt4-sql-odbc with IBM ISeries driver https://bugs.launchpad.net/bugs/253952 You received this bug notification because you are a member of Kubuntu Bugs, which is subscribed to qt4-x11 in ubuntu. -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
[Bug 253952] Re: SELECT don't work in libqt4-sql-odbc with IBM ISeries driver
Ehm! 10.04 non 9.04... Excuse me! -- SELECT don't work in libqt4-sql-odbc with IBM ISeries driver https://bugs.launchpad.net/bugs/253952 You received this bug notification because you are a member of Kubuntu Bugs, which is subscribed to qt4-x11 in ubuntu. -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
[Bug 253952]
affects ubuntu/libqt4-sql-odbc status fixreleased -- SELECT don't work in libqt4-sql-odbc with IBM ISeries driver https://bugs.launchpad.net/bugs/253952 You received this bug notification because you are a member of Kubuntu Bugs, which is subscribed to qt4-x11 in ubuntu. -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
[Bug 253952] Re: SELECT don't work in libqt4-sql-odbc with IBM ISeries driver
** Changed in: qt4-x11 (Ubuntu) Status: New = Fix Released -- SELECT don't work in libqt4-sql-odbc with IBM ISeries driver https://bugs.launchpad.net/bugs/253952 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 253952] Re: SELECT don't work in libqt4-sql-odbc with IBM ISeries driver
similar problem ubuntu 9.10 (with all updates), in which is qt 4.5.3 (marked as version 4.5.3really4.5.2-0ubuntu1) and iodbc 3.52.6-3ubuntu1 as database i am using Sql Anywhere 11.0.1.2324 odbc is set to use odbc driver /opt/sqlanywhere11/lib32/libdbodbcansi11_r.so i can connect to database using iodbctest, launch queries on it, all works as it should. qt applications i tried (sql browser demo, my own application) fail to get any results. first() returns false in iodbc trace log first problem is [00.151926] sqlbrowser B7728970 EXIT SQLFetchScroll with return code -1 (SQL_ERROR) SQLHSTMT 0x85c3be0 SQLUSMALLINT 1 (SQL_FETCH_NEXT) SQLLEN0 is it this bug, or is it something new? its also reported here: http://bugreports.qt.nokia.com/browse/QTBUG-3114 attached odbc trace log is created while using SqlBrowser from qt demos result of these operations 1) launch qt demo sql browser 2) connect to odbc source 3) submit query which should return ~200 rows. it returns none 4) closed sql browser application i hope it will help ** Attachment added: iodbc trace log http://launchpadlibrarian.net/35463984/odbctrace_.log -- SELECT don't work in libqt4-sql-odbc with IBM ISeries driver https://bugs.launchpad.net/bugs/253952 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 253952] [NEW] SELECT don't work in libqt4-sql-odbc with IBM ISeries driver
Public bug reported:
Binary package hint: libqt4-sql-odbc
I tested whit ISeriesAccess ODBC driver for linux 1.4 and 1.6 both 32bit.
Whit QT4.2 compiled myself worked, but they used unixODBC and not iODBC.
qDebug show regulary connection to database, but when I tray to do a
SELECT, the result of debug is :
Query active : true QSqlError(-1, , )
Is Select : true QSqlError(-1, , )
And after query.exec() and query.next()
QSqlError(0, QODBC3: Unable to fetch first, [iODBC][Driver
Manager]Optional feature not implemented)
If I tray the same query in iodbctest it worked.
[EMAIL PROTECTED]:~/src/g-suite-std-qt4/orfor$ iodbctest DSN=GAD
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0607.1008
Driver: 05.04.0070 (libcwbodbc.so)
SQLSELECT NRORD FROM TEORF00F WHERE NRORD=800300
NRORD
-
800300
result set 1 returned 1 rows.
Code in C++ is:
db.setDatabaseName(GAD);
if(db.open())
{
QSqlQuery query(db);
query.prepare(SELECT NRORD FROM TEORF00F WHERE NRORD=:i1);
query.bindValue(:i1,numero);
query.exec();
qDebug() Query active : query.isActive() query.lastError();
qDebug() Is Select : query.isSelect() query.lastError();
if(query.next())
{
qDebug() query.lastError();
nrord=query.value(0).toInt();
qDebug() I'am on a record : nrord query.lastError();
}
qDebug() query.lastError();
if(num.toInt()==nrord)
attivo=true;
}
** Affects: qt4-x11 (Ubuntu)
Importance: Undecided
Status: New
** Description changed:
Binary package hint: libqt4-sql-odbc
+
+ I tested whit ISeriesAccess ODBC driver for linux 1.4 and 1.6 both 32bit.
+ Whit QT4.2 compiled myself worked, but they used unixODBC and not iODBC.
qDebug show regulary connection to database, but when I tray to do a
SELECT, the result of debug is :
Query active : true QSqlError(-1, , )
Is Select : true QSqlError(-1, , )
And after query.exec() and query.next()
QSqlError(0, QODBC3: Unable to fetch first, [iODBC][Driver
Manager]Optional feature not implemented)
If I tray the same query in iodbctest it worked.
[EMAIL PROTECTED]:~/src/g-suite-std-qt4/orfor$ iodbctest DSN=GAD
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0607.1008
Driver: 05.04.0070 (libcwbodbc.so)
SQLSELECT NRORD FROM TEORF00F WHERE NRORD=800300
NRORD
-
800300
result set 1 returned 1 rows.
Code in C++ is:
db.setDatabaseName(GAD);
if(db.open())
{
QSqlQuery query(db);
query.prepare(SELECT NRORD FROM TEORF00F WHERE NRORD=:i1);
query.bindValue(:i1,numero);
query.exec();
qDebug() Query active : query.isActive() query.lastError();
qDebug() Is Select : query.isSelect() query.lastError();
if(query.next())
{
qDebug() query.lastError();
nrord=query.value(0).toInt();
qDebug() I'am on a record : nrord query.lastError();
}
qDebug() query.lastError();
if(num.toInt()==nrord)
attivo=true;
}
--
SELECT don't work in libqt4-sql-odbc with IBM ISeries driver
https://bugs.launchpad.net/bugs/253952
You received this bug notification because you are a member of Kubuntu
Team, which is subscribed to qt4-x11 in ubuntu.
--
kubuntu-bugs mailing list
[EMAIL PROTECTED]
https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
