O$6.1.3: Omnis ODBC driver and Win7

[Grzegorz (Greg) Pasternak]

OK, having gone through all this trouble I still have no connectivity.
The Excel is reporting either different architecture error, or (on a different computer) it is saying that the password is not correct.
This is on Win7.

I am about to give up on this. 


On Feb 24, 2017, at 9:45 AM, Grzegorz (Greg) Pasternak <grzegorz at niagara.com> wrote:

> Alain;
> Great, I have the ODBSUSER table now with the user/pswd entry.
> 
> Thank you.
> Greg
> 
> On Feb 24, 2017, at 9:24 AM, Alain Stouder Omnis <omnis at smartway.ch> wrote:
> 
>> If you use tools/addons/ODBC admin the Omnis IDE will create it for you.
>> 
>> ---
>> Learn something new every day!
>> 
>>> On 24 Feb 2017, at 15:11, Grzegorz (Greg) Pasternak <grzegorz at niagara.com> wrote:
>>> 
>>> Alain;
>>> 
>>> Where do I find ODBCUSERS table?
>>> I don't see it anywhere in the datafiles.
>>> I have verified that the ODBC mask is set on all files.
>>> 
>>> Greg
>>> 
>>> 
>>> 
>>>> On Feb 24, 2017, at 8:27 AM, Alain Stouder Omnis <omnis at smartway.ch> wrote:
>>>> 
>>>> A user and password that you’ve entered in the ODBCUSERS table of the datafile !
>>>> 
>>>>> On 24 Feb 2017, at 14:19, Grzegorz (Greg) Pasternak <grzegorz at NIAGARA.COM> wrote:
>>>>> 
>>>>> I think the odic masks & users are set.
>>>>> However, there is something I am not sure about.  On the ODBC configuration screen there is user name field and password entry field.
>>>>> What are the for?  Is it needed to populate them with something?  If so, what do I put in?
>>>>> 
>>>>> 
>>>>>> On Feb 24, 2017, at 12:34 AM, Alain Stouder Omnis <omnis at smartway.ch> wrote:
>>>>>> 
>>>>>> Grzegorz,
>>>>>> 
>>>>>> Have you set the odbc masks & users of the target datafile?
>>>>>> 
>>>>>> Regards,
>>>>>> Alain
>>>>>> ---
>>>>>> Learn something new every day!
>>>>>> 
>>>>>>> On 23 Feb 2017, at 21:46, Grzegorz (Greg) Pasternak <grzegorz at niagara.com> wrote:
>>>>>>> 
>>>>>>> Excel is simply waiting and waiting and waiting, nothing happens.
>>>>>>> I have installed Unicode 64 bit version.
>>>>>>> Also what is confusing, the only file I see in <C:\Windows\SysWOW64\Omnis> is <omodbcu32.dll>
>>>>>>> 
>>>>>>> The other files included in the zipped patch like: <omodbc64.dll> or <Omodbc32.dll> are not there.
>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>>>>> On Feb 23, 2017, at 3:39 PM, Alan Schmidt <alan at goconnected.com> wrote:
>>>>>>>> 
>>>>>>>> We have clients that use it so it must work. Can you even see the tables when you try to do a query in Excel?
>>>>>>>> 
>>>>>>>> -Alan
>>>>>>>> 
>>>>>>>> 
>>>>>>>> On 2/23/17, 12:23 PM, "omnisdev-en on behalf of Grzegorz (Greg) Pasternak" <omnisdev-en-bounces at lists.omnis-dev.com on behalf of grzegorz at niagara.com> wrote:
>>>>>>>> 
>>>>>>>> Can somebody confirm that the Omnis ODBC driver available for download actually works on Win7 against Omnis Studio 6.1.3 datafile?
>>>>>>>> It seems that the it is impossible to pull any data into Excel using this ODBC source.
>>>>>>>> 
>>>>>>>> Please share your bad/good experience.
>>>>>>>> 
>>>>>>>> Greg 
>>>>>>>> _____________________________________________________________
>>>>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>>>>>> 
>>>>>>>> 
>>>>>>>> 
>>>>>>>> 
>>>>>>>> 
>>>>>>>> _____________________________________________________________
>>>>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>>>>> 
>>>>>>> 
>>>>>>> _____________________________________________________________
>>>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>>>> 
>>>>>> 
>>>>>> _____________________________________________________________
>>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>>> 
>>>>> 
>>>>> _____________________________________________________________
>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>> 
>>>> 
>>>> _____________________________________________________________
>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>> 
>>> 
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>> 
>> 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com