Solved TD 6.1 SP5 SqlODB32 SqlGetErrorTextX returns special chars

Discussion forum about all things SqlBase.
greg
Germany
Posts: 28
Joined: 01 Nov 2017, 12:50
Location: Germany

TD 6.1 SP5 SqlODB32 SqlGetErrorTextX returns special chars

Post by greg » 14 May 2014, 11:13

In TD 6.1 SP5 SqlGetErrorTextX only returns special characters. It doesn´t happens with SP4.
You do not have the required permissions to view the files attached to this post.

VEspinal

Re: TD 6.1 SP5 SqlODB32 SqlGetErrorTextX returns special chars

Post by VEspinal » 16 May 2014, 22:35

Hi:

It is working for me.

Please see attached video.

Thanks
Victor
You do not have the required permissions to view the files attached to this post.

Kumuthini Ragavan

Re: TD 6.1 SP5 SqlODB32 SqlGetErrorTextX returns special chars

Post by Kumuthini Ragavan » 18 May 2014, 14:31

I agree with Victor. I see the correct error message as well.
Could it be that some setting changed at the backend? Just a wild guess.
Kumuthini Ragavan

User avatar
markus.essmayr
Site Admin
Site Admin
Austria
Posts: 892
Joined: 06 Mar 2017, 06:07
Location: Austria

Re: TD 6.1 SP5 SqlODB32 SqlGetErrorTextX returns special chars

Post by markus.essmayr » 18 May 2014, 17:00

Looks like the message was damaged by a ANSI/UNICODE conversion issue.

Max
Markus Eßmayr
teamdeveloper@t-mx.com

wwasilew
Germany
Posts: 28
Joined: 06 Mar 2017, 07:33
Location: Dortmund / Germany

Re: TD 6.1 SP5 SqlODB32 SqlGetErrorTextX returns special chars

Post by wwasilew » 19 May 2014, 07:53

We have same problem here, but with chinese characters in the message:
Unbenannt.jpg
A Problem with german Windows?

Windows 7 64Bit German

sql.ini - Section
[odbcrtr]
enablemultipleconnections=off
odbctrace=off
remotedbname=mydb,driver=SQL Server;server=dbhost;database=mydb; trusted_connection=no
You do not have the required permissions to view the files attached to this post.
Wladislaw Wasilewitsch
---------------------------------------------------
Software Developer
Materna TMT GmbH

greg
Germany
Posts: 28
Joined: 01 Nov 2017, 12:50
Location: Germany

Re: TD 6.1 SP5 SqlODB32 SqlGetErrorTextX returns special chars

Post by greg » 19 May 2014, 08:56

lrcuess wrote:Looks like the message was damaged by a ANSI/UNICODE conversion issue.

Max
Seems so .. but I only use SqlGetErrorText. In the video it works! Maybe it is a localisation-problem.

greg
Germany
Posts: 28
Joined: 01 Nov 2017, 12:50
Location: Germany

Re: TD 6.1 SP5 SqlODB32 SqlGetErrorTextX returns special chars

Post by greg » 04 Sep 2014, 10:30

It is a unicode-problem. It appears with SP5. This solved this issue:

Set sErrorMsgUnreadable=SqlGetErrorTextX( nError )
Call SalStrToWideChar(sMsg,sMessageReadable,ENC_UTF7)

Have fun!

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests