Package: unixodbc Version: 2.3.11-2 Severity: normal File: /usr/bin/iusql X-Debbugs-Cc: j...@nahmias.net
Hello, I was trying to connect to an MSSQL database using unixodbc/iusql with the FreeTDS driver. The password for the login was randomly generated and contained a semicolon ";" in it. This worked fine when using the FreeTDS tools tsql and fisql. However, the iusql tool from unixodbc failed as follows: $ iusql myDSN myLogin 'Y&MI%4VtL?C@OuUwmWkksL;+!#V$JSo6' -v [FreeTDS][SQL Server]Unable to connect to data source [FreeTDS][SQL Server]Login failed for user 'myLogin'. [ISQL]ERROR: Could not SQLDriverConnect Changing the password in the database worked around the issue, but I guess iusql needs to do better escaping of special characters in the password. --Joe -- System Information: Debian Release: bookworm/sid APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'unstable'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 5.18.0-2-amd64 (SMP w/1 CPU thread; PREEMPT) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages unixodbc depends on: ii libc6 2.33-7 ii libodbc2 2.3.11-2 ii libodbcinst2 2.3.11-2 ii libreadline8 8.1.2-1.2 unixodbc recommends no packages. unixodbc suggests no packages. -- no debconf information