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

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

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

bugtracker
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



------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Reply | Threaded
Open this post in threaded view
|

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

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

Comment #1 by PICCORO LENZ MCKAY:

odbc documentation was update by me and splited for better:

* notes in connection class host property: http://gambaswiki.org/wiki/comp/gb.db/_connection/host



------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Reply | Threaded
Open this post in threaded view
|

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

bugtracker
In reply to this post by bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1104&from=L21haW4-

Comment #2 by zxMarce:

Piccoro,

I don't have any Sybase servers to test. I will, nonetheless, try first with both MSSql 2005 and Firebird.
Is there any chance that I get access to a Sybase test DB of your property if I need it for debugging?

Regards,
zxMarce.



------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Reply | Threaded
Open this post in threaded view
|

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

bugtracker
In reply to this post by bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1104&from=L21haW4-

Comment #3 by PICCORO LENZ MCKAY:

Its same protocol for mocosoft sql server as sybase was the original software behind of... so TDS protocol its the used for sybase and mocosoft sql server, only mocosoft added changes to the protocol since version 5.0 to the lasted 8.X, so does'n matter the server type..



------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user