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
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
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?
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..