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

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