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

My question was about the Mac version which isn't functioning fully.

If anyone else has any experience would be great, can we pass these
messages to the bugs mailing list - my messages are bouncing because I'm
not a member yet.

I\m happy to share any technical details which would help mend the driver -
so everyone can benefit its full functionality close to the commercial
version.

Cheers,
mani

On 4 October 2013 11:41, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:

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

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