I have SQLServer 2017 instances on Windows 2016 Server installed on Oracle Virtualbox. When I try to connect to the server by isql and FreeTDS driver with wrong user name or password, I get garbled(mojibake) error message as follows. $ isql -v EXP sa Password [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source [37000][unixODBC][FreeTDS][SQL Server]???? 'sa' ?????????????? [ISQL]ERROR: Could not SQLConnect How can I get right error message? I confirmed that I could connect to the...
Add connection pool limits
Merge git change, Fix trace problems #71
Remove more defined lines from unixodbc_conf.h
Pull change over from git
Add check for intptr_t to configure.ac
Fix typo
Call driver functions through prototypes
SQLGetData returns SQL_SUCCESS instead of SQL_SUCCESS_WITH_INFO
From the investigation my colleague has made, the problem is bind to mysql-odbc connector, so this issue can be closed, as unixODBC seems to work fine.
Attaching reproducer. Using mysql With VARCHAR column (500 char data) Table created Data inserted Select Column 1 is name Fetch Get SUCCESS_WITH_INFO 500 255/255 Get SUCCESS 245 245/500 SQLGetData fails (100) Table deleted Done With VARBINARY column (500 char data, thus 1000 hex char result) Table created Data inserted Select Column 1 is name Fetch Get SUCCESS 1000 254/254 Get SUCCESS 746 254/508 Get SUCCESS 492 254/762 Get SUCCESS 238 238/1000 SQLGetData fails (100) Table deleted Done IN the second...
Ok, it sounds to me like a driver issue, so I will need to be able to replicate this to know if its a issue unixODBC needs to look at
Just the PHP test for now, I will work on a reproducer if it is needed.
This sounds like a driver issue, do you have a example that shows the problem?
SQLGetData returns SQL_SUCCESS instead of SQL_SUCCESS_WITH_INFO
Remove VERSION define from unixodbc_conf.h.in
Add line to isql man page
Man page updates
Fix spelling errors
Add unicode connection pooling
Add extra ini exports from odbcinst
use getpwuid_r is available
Buffer length for SQLGetDiagRecW and SQLErrorW is in characters, not bytes.
Update man page version numbers
Add connection attr persistence
Using isql with NLS_LANG set to .UTF returns two values 170,144 for the hebrew letter 'א' instead of one value 224. While sqlplus does return the correct "one" value 224 when using NLS_LANG is .UTF. No matter which NLS_LANG for isql the query select dump('א') from dual always returns 170,144. We are not using unicode. The Oracle server NLS_LANG is IW8ISO8859P8. In odbc.ini the Charset is set to .UTF-8. I would appreciate any ideas. Thanks, Morton
Fix licence version number
Fix problem mixing 2 and 3 verion drivers, and add max col width to iusql
Release 2.3.9
Remode UNIXODBC_SOURCE from unixodbc_conf.h
Move onto 2.3.9pre
Fix some typo's
Release 2.3.8
Fix some leaks
Add null ptr check in iniPropertyInsert
Stop double releaseing iconv handles in pooling
Fix SQL_ATTR_CONNECTION_DEAD arg
Fix lost iconv handle with pooling
Add Missing quotes
Add ICONV variables to config headers
Change default for enable-iconvperdriver
Add iconvperdriver configure option to allow calling unicode_setup in SQLAllocHandle
Thanks very much, I rebuilt isql keeping the readline lib in mind. It seems to be working as expected now.
Hi, Sorry, missed this. I will have to guess. It is clearly to do with how the two distrobutions build their isql, and I suspect it may be related to the use or not of the readline lib. My copy built from source will take the prescense of ";"in the last char of the line as the direction to execute the staement. So, with that in mind, I think the SuSE version is possibly returning a space after the ";" so it requires a explicit "go" to execute. But assuming they both used the same code it has to be...
I'm still looking for a response to this one. I asked the same question in an SAP Hana forum and they directed me to unixODBC for an answer. Does anyone have any ideas?
Try using W error functions first if we have them
Try using W error functions first if we have them
When setting connection attributes set before connect also check if the W entry poins can be used
Update pkg-config templates
Remove trailing space from isql/iusql
Fix some Unicode length issues
Don't include NUL-terminator in length in unicode_to_ansi_alloc
Alter W to A call sequence
Try and fix ini file race condition
Create rpm for Centos7
libodbc1: Truncates "odbc.ini" randomly under high load
Fix pooling seg fault
Add some man page improvements
Fix SQLDataSources terminator character
Fix typo
SQLDriversW is ignoring user configuration
Patch has been added. Thanks.
Added patch from jesusmalo@users.sourceforge.net
Patch fixing the issue has been provided
SQLDriversW is ignoring user configuration
I have two servers, one Red Hat and one SuSE. Both have the ODBC for SAP Hana client installed, and both have an ODBC DSN configured to connect into the same Hana database. I'm able to use unixODBC isql on either system to connect into the database and run queries. However, I notice a difference in behavior when I use the -n option in isql. On Red Hat, when I end a line with a semicolon, it executes the statement. On SuSE, a "GO" command is still needed after the semicolon. I'm running the same version...
Add checks to show sizeof( SQLLEN ) problems via logging
Add checks to show sizeof( SQLLEN ) problems via logging
Tidy up some errors
Build fails with BSD make
Not heard back, wo will assume fixed.
SQL Server money precision must be 4
Not a unixODBC issue (I believe)
Hi, I think the proiblem is likely to be with the driver (freeTDS I think) not the driver manager, I would ask the freTDS folk about this.
SQL Server money precision must be 4
Move to 2.3.8pre and add editline support
Release 2.3.7
Connection pooling: Fix liveness check for Unicode drivers
bug fix when SQLGetPrivateProfileString() is called to get a list of sections or a list of keys
Update ChangeLog
improve diag record handling with the behavior of Windows DM and export SQLCancelHandle
Spelling mistakes and remove some exports. If the exports are needed, fix in a clearner way
Change header test
Just commited a change that I hope will fix the problem
try and remove use of gmake CURDIR
Thanks, I will look into this.
Build fails with BSD make
THanks, I will look into this.
Build fails with BSD make
Another typo to fix
Small speeling fixes
Wow, that was a lightning fast fix. :-) Thanks!
update version in manpages
cannot build with QT-2.2.4 - needs QTextEdit
Moved in the gui parts