Thread: [ODBC] Server Closed the connection unexpectedly

On 04/13/2017 12:27 AM, Mehmet Keleş wrote:
> Hello,
> I downloaded odbc driver for mongodb from
> site("psqlodbc_09_06_0200-x64"),  i try to connect to my mongodb server
> via this odbc server(on Windows) but the error which is attached screen

Why are you using a Postgres ODBC driver to connect to MongoDB?

> shot this email
> was occured. while this trying, i can see openned connection on my
> mongodb server.
> I try to find solution on web forums, but I didn't find.
>
> Could you help me for this situation?
>
>
> Best Regards
>
> Mehmet Keles
>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 04/18/2017 08:21 PM, Mehmet Keleş wrote:
>
>
> Hello,
>
> Becouse, i want to connect the mongodb on ms excel.

Still not sure why you would expect a Postgresql driver to work with
MongoDB. I know MongoDB has the BI Connector(I believe that is the right
name) that allows a Postgres database to use MongoDB via an FDW. That is
if I am following the below correctly:

https://www.linkedin.com/pulse/mongodb-32-now-powered-postgresql-john-de-goes

At any rate I do not see where the Postgres ODBC driver plays a role in
this?

I would think you need a MongoDB ODBC driver, or am I missing something?

>
>
>
> Windows 10 telefonumdan gönderildi
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 04/19/2017 10:54 PM, Mehmet Keleş wrote:

Please reply to list also.
Ccing list.
> Hello,
>
> yes it's name is MongoDB BI Connector,

Which version as it seems MongoDB has changed from Postgres to MySQL
between version 1.x and 2.0?

>
> I followed this webinar,
>
> https://www.mongodb.com/blog/post/analyzing-data-in-microsoft-excel-with-the-mongodb-connector-for-bi

That is for the Postgres(BI Connector version 1.x) version. If you are
using that version then the video applies. The important part would be
the port number. In your original post you used 27017 as the port for
the BI Connector(Postgres). 27017 is the default port for MongDB so I
doubt it is the port for the BI Connector as that is a separate server.
If you are indeed using the Postgres version of Bi Connector then you
need to find what port it is running on and use that as the port number
in the ODBC setup.


If you are running BI Connector 2+ then you will need to use the MySQL
ODBC driver. See here:

https://docs.mongodb.com/bi-connector/master/installation/#connect-to-the-bi

>
>
> and download the ODBC driver from
> here: https://www.postgresql.org/ftp/odbc/versions/msi/ but i didn't
> connect via this driver.
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 04/20/2017 07:06 AM, Mehmet Keleş wrote:

Again please reply to list also.

> my mongodb ver. is  *3.4.0,*

The webinar you posted earlier is for 3.2 and my guess is out of date.

>
> psqlodbc ver. is  *9.6.200*

The version information I was looking for was the BI Connector. Given
that you are using MongoDB I am going to assume version 2+, in which
case you are dealing with MySQL not Postgres. Keep in mind this all
educated guesses on my part as I do not use MongoDB nor am I MongoDB
tech support. I would suggest reaching out to MongoDB for tech support
to find out what you are actually dealing with.


>
> ------------------------------------------------------------------------
> *Gönderen:* Mehmet Keleş <mehmetkeles@outlook.com>
> *Gönderildi:* 20 Nisan 2017 Perşembe 08:54:25
> *Kime:* Adrian Klaver
> *Konu:* Ynt: Ynt: [ODBC] Server Closed the connection unexpectedly
>
>
> Hello,
>
> yes it's name is MongoDB BI Connector,
>
> I followed this webinar,
>
> https://www.mongodb.com/blog/post/analyzing-data-in-microsoft-excel-with-the-mongodb-connector-for-bi
>
>
> and download the ODBC driver from
> here: https://www.postgresql.org/ftp/odbc/versions/msi/ but i didn't
> connect via this driver.
>
>
>
> PostgreSQL: File Browser <https://www.postgresql.org/ftp/odbc/versions/msi/>
> www.postgresql.org
> Peripheral Links. Donate; Contact; Home; About; Download; Documentation;
> Community; Developers
>
>
>
> Analyzing Data in Microsoft Excel with the MongoDB ...
> <https://www.mongodb.com/blog/post/analyzing-data-in-microsoft-excel-with-the-mongodb-connector-for-bi>
> www.mongodb.com
> The instructions in the demo assume that you already have a MongoDB
> database running together with a configured instance of the MongoDB
> Connector for BI – the ...
>
>
>
> ------------------------------------------------------------------------
> *Gönderen:* Adrian Klaver <adrian.klaver@aklaver.com>
> *Gönderildi:* 19 Nisan 2017 Çarşamba 07:16:09
> *Kime:* Mehmet Keleş; pgsql-odbc@postgresql.org
> *Konu:* Re: Ynt: [ODBC] Server Closed the connection unexpectedly
>
> On 04/18/2017 08:21 PM, Mehmet Keleş wrote:
>>
>>
>> Hello,
>>
>> Becouse, i want to connect the mongodb on ms excel.
>
> Still not sure why you would expect a Postgresql driver to work with
> MongoDB. I know MongoDB has the BI Connector(I believe that is the right
> name) that allows a Postgres database to use MongoDB via an FDW. That is
> if I am following the below correctly:
>
> https://www.linkedin.com/pulse/mongodb-32-now-powered-postgresql-john-de-goes
>
> At any rate I do not see where the Postgres ODBC driver plays a role in
> this?
>
> I would think you need a MongoDB ODBC driver, or am I missing something?
>
>>
>>
>>
>> Windows 10 telefonumdan gönderildi
>>
>>
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com


--
Adrian Klaver
adrian.klaver@aklaver.com