http://gambaswiki.org/bugtracker/edit?object=BUG.1113&from=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 Description ----------- The following simple code does not execute, when used a driver different rather than Mysql odbc driver module for ODBC type connections: Public Sub Main() Dim $con As New Connection Try $con.Close() ' $con.Type = "odbc" ' $con.Host = "testdb" ' $con.Login = "" ' $con.Password = "" ' $con.Open() ' Try $con.Exec("CREATE TABLE IF NOT EXISTS tabla1 ( columna1 VARCHAR(20), columna2 VARCHAR(20))") Print Error.Text End If the ODBC connection tipe are using a ODBC mysql driver the code will work, but with any other type will fails always, i tested in each gambas version since 3.5, tested with 3.4 and 3.8 and 3.9 and trunk the connection string are tested, the ODBC definition are globally at the /etc/odbc.ini and its: [testdb] Description=Mysql3 Driver=SQLite3 Database=/home/systemas/TEST # optional lock timeout in milliseconds Timeout=2000 the connection was tested and working sucessfully with UnixODBC isql command line tool: isql testdb +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> CREATE TABLE IF NOT EXISTS tabla1 ( columna1 TEXT, columna2 TEXT) SQLRowCount returns 0 SQL> select * from tabla1 +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | columna1 | columna2 | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ SQLRowCount returns 0 SQL> DROP TABLE tabla1 SQLRowCount returns 0 SQL> the Gambas code due driver implementation does not return why get and error, in second comment i attached image for gambas ide variables in execution System information ------------------ [System] Gambas=3.9.1 OperatingSystem=Linux Kernel=2.6.38-bpo.2-686 Architecture=x86 Distribution=<hostname> 6.1 Desktop= Theme=Gtk Language=es_VE.UTF-8 Memory=2958M [Libraries] Cairo=libcairo.so.2.11000.2 Curl=libcurl.so.4.2.0 DBus=libdbus-1.so.3.4.0 GStreamer=libgstreamer-0.10.so.0.27.0 GTK+2=libgtk-x11-2.0.so.0.2000.1 Poppler=libpoppler.so.5.0.0 QT4=libQtCore.so.4.7.4 SDL=libSDL-1.2.so.0.11.4 SQLite=libsqlite3.so.0.8.6 [Environment] DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-vBmVAKTmAe,guid=ab802896e9e02a1f9130b5430000020a DESKTOP_SESSION=openbox DISPLAY=:0.0 GB_GUI=gb.qt4 GDMSESSION=openbox GDM_LANG=es_VE.UTF-8 GDM_XSERVER_LOCATION=local HOME=<home> LANG=es_VE.UTF-8 LOGNAME=<user> ORBIT_SOCKETDIR=/tmp/orbit-<user> PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games PWD=<home> SHELL=/bin/bash SSH_AGENT_PID=3169 SSH_AUTH_SOCK=/tmp/ssh-ufENJB3126/agent.3126 TZ=:/etc/localtime USER=<user> USERNAME=<user> WINDOWPATH=7:7:7:7 XAUTHORITY=<home>/.Xauthority XDG_DATA_DIRS=/usr/local/share/:/usr/share/:/usr/share/gdm/ XDG_MENU_PREFIX=lxde- XDG_SESSION_COOKIE=e95ad835c51ba625379e246200000423-1494956351.268990-1110310328 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user