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

On 02.10.2013 14:57, manindra.sarkar@brightnorth.co.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.

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

2013/10/4 Heikki Linnakangas <hlinnakangas@vmware.com>

On 02.10.2013 14:57, manindra.sarkar@brightnorth.**co.uk<manindra.sarkar@brightnorth.co.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

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.stehule@gmail.com> wrote:

2013/10/4 Heikki Linnakangas <hlinnakangas@vmware.com>

On 02.10.2013 14:57, manindra.sarkar@brightnorth.**co.uk<manindra.sarkar@brightnorth.co.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/**mailpref/pgsql-bugs&lt;http://www.postgresql.org/mailpref/pgsql-bugs&gt;

--
*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&gt; 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&gt; 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/&gt;.

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.sarkar@brightnorth.co.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.stehule@gmail.com> wrote:

2013/10/4 Heikki Linnakangas <hlinnakangas@vmware.com>

On 02.10.2013 14:57, manindra.sarkar@brightnorth.**co.uk<manindra.sarkar@brightnorth.co.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/**mailpref/pgsql-bugs&lt;http://www.postgresql.org/mailpref/pgsql-bugs&gt;

--
*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&gt; 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&gt; 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/&gt;.

--
*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&gt; 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&gt; 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/&gt;.

2013/10/4 Mani Sarkar <manindra.sarkar@brightnorth.co.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

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.stehule@gmail.com> wrote:

2013/10/4 Mani Sarkar <manindra.sarkar@brightnorth.co.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.sarkar@brightnorth.co.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.stehule@gmail.com> wrote:

2013/10/4 Heikki Linnakangas <hlinnakangas@vmware.com>

On 02.10.2013 14:57, manindra.sarkar@brightnorth.**co.uk<manindra.sarkar@brightnorth.co.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/**mailpref/pgsql-bugs&lt;http://www.postgresql.org/mailpref/pgsql-bugs&gt;

--
*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&gt; 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&gt;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/&gt;.

--
*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&gt; 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&gt;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/&gt;.

--
*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&gt; 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&gt; 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/&gt;.