[Gambas-user] [Gambas Bug Tracker] Bug #1104: ODBC driver misc 1: if name, login or pass are specified connection does not open

[bugtracker at ...3416...]

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

PICCORO LENZ MCKAY reported a new bug.

Summary
-------

ODBC driver misc 1: if name, login or pass are specified connection does not open

Type             : Bug
Priority         : Low
Gambas version   : 3.9
Product          : ODBC driver


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

in the following piece of code a DSN string connection are used, 
but apart only the type and host a user and pass was already defined, 

...so if more properties thant the host and type are defined, the connection fails to happen:


Public Function getConexionodbc()
  
  $conexionodbc = New Connection
  $conexionodbc.Type = "odbc"   'esto siempre va en minusculas: always must be lowercase
  $conexionodbc.Host = "Driver=FreeTDS;TDS_Version=5.0;Server=10.10.200.10;Port=2638;UId=dba;Pwd=sql;Database=sybasedemo"
  $conexionodbc.Login = "dba"
  $conexionodbc.Password = "sql"  ' sybase defaults
  
  Try $conexionodbc.Open
  
  If Error Then
    $conexionodbc = Null
  Endif  
  
End


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

[System]
Gambas=3.9.1
OperatingSystem=Linux
Kernel=3.2.0-0.bpo.4-686-pae
Architecture=x86
Distribution=debian 6.1
Desktop=
Theme=VenenuX
Language=es_VE.UTF-8
Memory=1695M

[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-SDLMZFhfxe,guid=e84bee4349323ab2fdd0e833000d3724
DESKTOP_SESSION=openbox
DISPLAY=:0.0
GB_GUI=gb.qt4
GDMSESSION=openbox
GDM_LANG=es_VE.UTF-8
GDM_XSERVER_LOCATION=local
GNOME_KEYRING_CONTROL=/tmp/keyring-F6Av2Z
GNOME_KEYRING_PID=28945
HOME=<home>
LANG=es_VE.UTF-8
LOGNAME=<user>
PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games:<home>/.rvm/bin
PWD=<home>
SHELL=/bin/bash
SSH_AGENT_PID=28992
SSH_AUTH_SOCK=/tmp/ssh-MIgmw28954/agent.28954
TZ=:/etc/localtime
USER=<user>
USERNAME=<user>
WINDOWPATH=7:8:8:8:8
XAUTHORITY=<home>/.Xauthority
XDG_DATA_DIRS=/usr/local/share/:/usr/share/:/usr/share/gdm/
XDG_SESSION_COOKIE=b7d14e28769c4139a06b6f990000000c-1493388004.744958-1810097376