SqlDbx Forum

Tym

Member

ODBC issue with concatenation

I use an ODBC to an Access database, on an older version (3.47) I have no problems to concatenate strings :

SELECT FieldA+'/'+FieldB AS CONCAT FROM Table

On the newer version of SqlDbx, the application just crashes when I launch the query.

I don't know if this happens woth other ODBC pilots.

Please ask if you need more details, logs or examples!

Last edited by Tym (2012-06-30 13:05:17)

sqldbxhelp

Administrator

Re: ODBC issue with concatenation

I am not able to reproduce this behavior.
Are you using the latest version (3.57)?

Tym

Member

Re: ODBC issue with concatenation

Yes I'm using 3.57, I think the issue is related to the length of the fields : on older versions of SqlDbx you get a warning telling you the string has been truncated and the result field is empty.
I'm talking about strings at least 100 chars long.

Crashes with Access ODBC driver

SELECT
'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'+'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
AS Concat
FROM Table1

Same thing with Excel ODBC driver

SELECT 
'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'+'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
AS Concat
 FROM "Feuil2$"

Tested with direct MS Sql Server and MS Sql ODBC driver : no issue.

Last edited by Tym (2012-07-04 03:40:27)

sqldbxhelp

Administrator

Re: ODBC issue with concatenation

Thanks, Tym
I was able to reproduce the error. It will be fixed in a next release.