Re: BUG #8496: psqlODBC driver does not work well via Excel

2013/10/4 Mani Sarkar <manindra(dot)sarkar(at)brightnorth(dot)co(dot)uk>

> Just to provide some additional information, I'm using MS Excel 2011
> running on the Mac running Mountain Lion 10.8.
>
> If the commercial version works fine with the same administrator and
> Excel, and by only switching the postgres driver, it is highly likely its
> the driver on the Mac.
>
>
I don't know ODBC on Mac, I worked on MS Win

Pavel

> Cheers,
> mani
>
>
> On 4 October 2013 10:32, Mani Sarkar <manindra(dot)sarkar(at)brightnorth(dot)co(dot)uk>wrote:
>
>> Hi guys,
>>
>> I have enlisted the issues on this page:
>> http://support.openlinksw.com/support/techupdate.vsp?c=20736
>>
>> When we use the psqlODBC driver via any ODBC administrator, and use
>> Excel's data options to connect to the PostgreSQL database, we get the
>> below response from Excel.
>> 1) An empty table window
>> 2) Running SQL queries gives the below response
>>
>> [image: Inline images 1]I don't get this when using the commercial
>> product or even when trying to connect from an external demo program.
>>
>> Cheers,
>> mani
>>
>>
>>
>> On 4 October 2013 08:24, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>>
>>>
>>>
>>>
>>> 2013/10/4 Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
>>>
>>>> On 02.10.2013 14:57, manindra(dot)sarkar(at)brightnorth(dot)**co(dot)uk<manindra(dot)sarkar(at)brightnorth(dot)co(dot)uk>wrote:
>>>>
>>>>> Excel does not seem to respond with any data - but does give an idea
>>>>> that it
>>>>> has made some sort of a connection with the database. SQL commands
>>>>> fail from
>>>>> being executed.
>>>>>
>>>>
>>> It is strange - I used pg ODBC driver together with MS Excel without any
>>> issue.
>>>
>>> Regards
>>>
>>> Pavel
>>>
>>>
>>>
>>>>
>>>> I'm afraid you'll have to provide a lot more details for anyone to be
>>>> able to help you.
>>>>
>>>>
>>>> - Heikki
>>>>
>>>>
>>>> --
>>>> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
>>>> To make changes to your subscription:
>>>> http://www.postgresql.org/**mailpref/pgsql-bugs<http://www.postgresql.org/mailpref/pgsql-bugs>
>>>>
>>>
>>>
>>
>>
>> --
>> *Manindra Sarkar*
>> Engineer
>> Bright North
>>
>> *t:* +44 20 3598 2217 *m:* *w**:* www.brightnorth.co.uk
>>
>> 1st floor, 33-34 Alfred Place, WC1E 7DP
>> Company number: 08340170
>>
>> Come and see Rob Hick, our very own Chief Data Scientist, present at Econsultancy’s
>> Crunch <http://econsultancy.com/uk/events/crunch> event on 10 October
>> and learn why data’s not just for geeks
>>
>> Find out in our latest whitepaper why we think Meaningful Data is more
>> important than Big Data <http://www.brightnorth.co.uk/meaningfuldata>and how it can help transform your business performance.
>>
>> We are always looking for exceptional people to join our team. If you’re
>> super talented and want to work in a fast moving, evolutionary company, visit
>> our recruitment site <https://brightnorth.recruiterbox.com/>.
>>
>
>
>
> --
> *Manindra Sarkar*
> Engineer
> Bright North
>
> *t:* +44 20 3598 2217 *m:* *w**:* www.brightnorth.co.uk
>
> 1st floor, 33-34 Alfred Place, WC1E 7DP
> Company number: 08340170
>
> Come and see Rob Hick, our very own Chief Data Scientist, present at Econsultancy’s
> Crunch <http://econsultancy.com/uk/events/crunch> event on 10 October and
> learn why data’s not just for geeks
>
> Find out in our latest whitepaper why we think Meaningful Data is more
> important than Big Data <http://www.brightnorth.co.uk/meaningfuldata> and
> how it can help transform your business performance.
>
> We are always looking for exceptional people to join our team. If you’re
> super talented and want to work in a fast moving, evolutionary company, visit
> our recruitment site <https://brightnorth.recruiterbox.com/>.
>