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

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.

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/>.