O7 – Strange phenomenon with SQL Server (SOLUTION)
Solution found
Source of the problem was command
Set Character Mapping {ANSI}
Real Source of the problem was wrong contents in ANSI.INI
Real Real Source of the problem is that Windows 10 has this funny
behaviour of letting you copy a file to discover that the file isn’t
copied, it goes into some sandbox, appdata, don’t know where but not
where it was meant to be with the result that ANSI.INI was wrong…
Doug, a bit fat thanks to you as you clearly pointed me to this
‘character mapping’ thing. The reason VCS worked and my app not is
because VCS Logon doesn’t issue this command ‘Set Character Mapping’
Omg, what a journey this was…but oh so happy i can work now on my new
shiny new workstation…
Bruno Huyssen
On 11/14/2017 7:36 PM, Doug Easterbrook wrote:
> hey bub.
>
> isn’t there some sort of character mapping that needs to be done with sql servers with omnis classic?
>
>
> the fact that the data you get back is predictable and consistent, even if wrong, might also that the database is set up with some sort of different encoding??
>
>
>
>
> Doug Easterbrook
> Arts Management Systems Ltd.
> mailto:doug@artsman.com
> www.artsman.com
> Phone (403) 650-1978
>
>
>
>
> see you at the third annual users conference
> tickets.proctors.org/TheatreManager/95/online?performance=29086 <tickets.proctors.org/TheatreManager/95/online?performance=29086>
>> On Nov 14, 2017, at 12:11 AM, bub <buppeke@gmail.com> wrote:
>>
>> Thanks Jock, i am happy to see a message 🙂
>>
>> More info on my problem is that i can perfectly use the VCS with my Omnis installation with the VCS being on a remote SQL Server so the problem must be in SQL Server…
>>
>> Bruno
>>
>>
>> On 11/14/2017 12:35 PM, Jock Philip wrote:
>>> Hi Bruno,
>>>
>>> Can’t help you with your question but the list has been silent since the 10th.
>>>
>>> Jo k
>>>
>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>> Jock Philip [jock@visionchips.com] Vision Chips, Inc.
>>> 888.517.7779 x 3563
>>> www.visionchips.com/
>>> Developers of OBserver OB/GYN Ultrasound Reporting and Image Archiving System
>>>
>>> —–Original Message—–
>>> From: omnisdev-en [mailto:omnisdev-en-bounces@lists.omnis-dev.com] On Behalf Of bub
>>> Sent: Monday, November 13, 2017 11:01 PM
>>> To: omnisdev-en@lists.omnis-dev.com
>>> Subject: O7 – Strange phenomenon with SQL Server
>>>
>>> Hi all,
>>>
>>> I didn’t see any email from Underground since 10/11…!!!!????
>>>
>>> I got a brand new computer sent to me by my employer due to new security regulations
>>>
>>> The data i receive from SQL Server is scrambled and i spent the last 24hr trying to find the issue to no avail
>>>
>>> I tried with 2 flavours of SQL Server (2014 and 2016) I tried with different DSN entries (SQL Server, SQL Sever Native, ODBC 13) I tried with different Omnis installations including the one if have used on many, many computers
>>>
>>> I can login, i can transfer data but
>>>
>>> when i do something like
>>>
>>> 1. Perform SQL => USE ProAcc
>>> ok
>>>
>>> 2. Perform SQL => SELECT DBNAME()
>>>
>>> I get “oqn@bb” instead of ProAcc
>>>
>>> Help, help, help
>>>
>>> Bruno Huyssen
>>>
>>> ps: If there have been mails in the last 3 days, please send me a direct message so i know things are wrong…
>>>
>>> —
>>> This email has been checked for viruses by Avast antivirus software.
>>> www.avast.com/antivirus
>>>
>>> _____________________________________________________________
>>> Manage your list subscriptions at lists.omnis-dev.com
>>> _____________________________________________________________
>>> Manage your list subscriptions at lists.omnis-dev.com
>> _____________________________________________________________
>> Manage your list subscriptions at lists.omnis-dev.com
>
>
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
