Re: Ynt: Ynt: Server Closed the connection unexpectedly

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(at)outlook(dot)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(dot)klaver(at)aklaver(dot)com>
> *Gönderildi:* 19 Nisan 2017 Çarşamba 07:16:09
> *Kime:* Mehmet Keleş; pgsql-odbc(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com