http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #15 by PICCORO LENZ MCKAY:
some info from freetds git repo:
https://github.com/FreeTDS/freetds/issues/131#issuecomment-313166673
are that info usefully? i cannot understant that freddy77 said!
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #14 by PICCORO LENZ MCKAY:
hi, how its the progress on this?, gambas 3.10 i think could be released soon i
guess/suspect i'm very interesting that of all the reported issues of odbc this
about inmediate query could be
Cris, the mail was generated from bugtracker, so you must answer here to
better follow up of..
and basically u are agree that the patch its "not so ugly", due acepted
that if no sql negative return was, can be treated as success and the patch
for me are very good way to manage that..
2017-06-21
This is in no way "bad behavior of the ODBC and SQL standard", nor a
problem of Microsoft. It is standard practice (I have encountered it in ALL
the dbms with which I have been working through the years) that when a SQL
query returns no data the engine return a SQLCODE 100.
Negative SQLCODES
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #13 by PICCORO LENZ MCKAY:
i think your patch are not so "ugly" due relies on the bad behaviour of the
ODBC and SQL standar, i mean umm jajaja its very confusing that the ODBC paper
said after a "susessfull sql ddl" return
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #12 by zxMarce:
I'm on it, already fixed, but the way I fixed it not only is not elegant, but
also plain ugly.
I would like to get Benoît's opinion on this as well, because the patch
consists in changing a return code
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #11 by PICCORO LENZ MCKAY:
hi, any progress on this?
--
Check out the vibrant tech community on one of the world's most
engaging tech sites,
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #10 by PICCORO LENZ MCKAY:
ok, i understand sorry for the noise, its just that i tested many odbc module
drivers and tested that..
in other words, i tested the condition with sqlite and i confirmed does not
work..
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #9 by zxMarce:
Piccoro,
As I already told you more than once, ODBC will return the row count thanks to
the patch I already made given a couple of conditions that depend on the
low-level driver being correctly configured.
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #8 by PICCORO LENZ MCKAY:
hi, zxMarce, thanks for take a shot.. i hope u can doit more due i now very
busy.. i was thinking.. why odbc to sqlite if there's native sqlite..
well the problem its that must be a standar... odbc
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #7 by zxMarce:
Piccoro,
Got more details. This problem would occur with any statement/query that does
not return data.
For example a CREATE TABLE, DROP TABLE, etc. kind of query.
This occurs when the ODBC SQLExecDirect()
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #6 by zxMarce:
Piccoro,
Found out the statement IS executed, this is, in this case the table IS created
if it did not exist.
You may want to change the bug title, which is misleading.
Anyway, for some reason not yet fully
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #5 by zxMarce:
Piccoro,
Just installed SQLite3 on my home laptop. After some twiddling I got the right
connection string and the test program I once sent you connected OK.
You're correct that there's something wrong when
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #4 by PICCORO LENZ MCKAY:
i'll made your suggestions, but please,
pardom me, zxmarce, burt if are a low level driver manager problem why are
working in console?
with php are working too!
there are other minor problems that
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #3 by zxMarce:
It is unlikely you will see any: If at least one method works, that kind of
proves unixODBC and Gambas work with -at least- these combinations.
Just in case, please enable DEBUG in the ODBC component and try
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #2 by PICCORO LENZ MCKAY:
any progress with this bug? i do not see some work in svn
--
Check out the vibrant tech community on one of the world's
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
PICCORO LENZ MCKAY added an attachment:
error-odbc2.png
--
Check out the vibrant tech community on one of the world's most
engaging tech sites,
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
Comment #1 by PICCORO LENZ MCKAY:
now tested better, works only with odbc/postgres using lasted and any
odbc/mysql, for any odbc/freetds, previous odbc/postgresql or any odbc/sqlite
or any odbc/mdbtools does not work
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-
PICCORO LENZ MCKAY reported a new bug.
Summary
---
ODBC driver problem: driver connects but does not exec query
Type : Bug
Priority : High
Gambas version : 3.9.90 (TRUNK)
Product : ODBC driver
19 matches
Mail list logo
