[Gambas-bugtracker] Bug #2171: gb.db.odbc: unable to convert date

[bugtracker at gambaswiki.org]

http://gambaswiki.org/bugtracker/edit?object=BUG.2171&from=L21haW4-

Gianluigi GRADASCHI reported a new bug.

Summary
-------

gb.db.odbc: unable to convert date

Type             : Bug
Priority         : Medium
Gambas version   : Unknown
Product          : ODBC driver


Description
-----------

A friend of ours from the Italian site says:
I have recently installed the new version of Gambas, 3.16.0, and on sql requests with Odbc driver the result returns the error in summary.
The program does not crash but by recalling the value of the data field of the result it returns me null.


System information
------------------

[System]
Gambas=3.16
OperatingSystem=Linux
Kernel=5.4.0-70-generic
Architecture=x86_64
Distribution=Ubuntu 20.04.2 LTS
Desktop=KDE5
Font=Noto Sans,10
Scale=8
Theme=breeze
Language=it_IT.UTF-8
Memory=15774M

[Libraries]
Cairo=libcairo.so.2.11600.0
Curl=libcurl.so.4.6.0
DBus=libdbus-1.so.3.19.11
GDK2=libgdk-x11-2.0.so.0.2400.32
GDK3=libgdk-3.so.0.2404.16
GStreamer=libgstreamer-1.0.so.0.1602.0
GTK+2=libgtk-x11-2.0.so.0.2400.32
GTK+3=libgtk-3.so.0.2404.16
OpenGL=libGL.so.1.7.0
Poppler=libpoppler.so.97.0.0
QT5=libQt5Core.so.5.12.8
SDL=libSDL-1.2.so.0.11.4
SQLite=libsqlite3.so.0.8.6

[Environment]
DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/1000/bus
DEFAULTS_PATH=/usr/share/gconf/plasma.default.path
DESKTOP_SESSION=plasma
DISPLAY=:0
GB_GUI=gb.qt5
GPG_AGENT_INFO=/run/user/1000/gnupg/S.gpg-agent:0:1
GTK2_RC_FILES=/etc/gtk-2.0/gtkrc:<home>/.gtkrc-2.0:<home>/.config/gtkrc-2.0
GTK_RC_FILES=/etc/gtk/gtkrc:<home>/.gtkrc:<home>/.config/gtkrc
HOME=<home>
KDE_FULL_SESSION=true
KDE_SESSION_UID=1000
KDE_SESSION_VERSION=5
LANG=it_IT.UTF-8
LANGUAGE=it_IT.UTF-8
LC_ALL=it_IT.UTF-8
LOGNAME=<user>
MANDATORY_PATH=/usr/share/gconf/plasma.mandatory.path
PAM_KWALLET5_LOGIN=/run/user/1000/kwallet5.socket
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin
PWD=<home>
QT_ACCESSIBILITY=1
QT_AUTO_SCREEN_SCALE_FACTOR=0
QT_LOGGING_RULES=*.debug=false
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/1392,unix/<hostname>:/tmp/.ICE-unix/1392
SHELL=/bin/bash
SHLVL=0
SSH_AGENT_PID=1331
SSH_AUTH_SOCK=/tmp/ssh-VfD5zOM9PSec/agent.1287
TZ=:/etc/localtime
USER=<user>
XAUTHORITY=/tmp/xauth-1000-_0
XCURSOR_THEME=Breeze_Snow
XDG_CONFIG_DIRS=/etc/xdg/xdg-plasma:/etc/xdg:/usr/share/kubuntu-default-settings/kf5-settings
XDG_CURRENT_DESKTOP=KDE
XDG_DATA_DIRS=/usr/share/plasma:/usr/local/share:/usr/share:/var/lib/snapd/desktop
XDG_RUNTIME_DIR=/run/user/1000
XDG_SEAT=seat0
XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0
XDG_SESSION_CLASS=user
XDG_SESSION_DESKTOP=KDE
XDG_SESSION_ID=3
XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session1
XDG_SESSION_TYPE=x11
XDG_VTNR=1
force_s3tc_enable=true