Issue with ODBC connection when export Database

From: Noushad Mohamed <noushad(at)qanawat-me(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Issue with ODBC connection when export Database
Date: 2018-08-08 08:55:56
Message-ID: 1f2db2cebfecd620127a2b90f757403a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Dears

I am trying to export my DB that was on SQL 2008 to 2017 SQL server & I
succeeded, and I am trying to connect the exported database into odoo(Ver
11) by making link server to PostgreSQL. Iam succeed in this part as well.

Now the issue is when I try to export the database from SQL2017 to Odoo
bridged server using export wizard I get below error.

ODBC connection I created is with the 64 Bit by downloading from
https://www.postgresql.org/ftp/odbc/versions/msi/, ODBC driver I downloaded
and installed is *psqlodbc_09_06_0500-x64.zip*
<https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_06_0500-x64.zip>

PostgreSQL Version on odoo server is 9.6.9 , I assume is it could be
because the ODCB driver is 9.6.05 & version of SQL is 9.6.9, or is it
something I need to change some settings on PostgreSQL side in order to
work.

Kindly confirm if we need to install same version of odbc connection driver
as PostgreSQL server version & where is it available.

Appreciate your help on this.

*Noushad Mohammed*

*[image: cid:image001(dot)jpg(at)01CEE6A2(dot)AA925410]*

M (+971) 547130913

T (+971) 4 3913622

*Qanawat FZ L.L.C*

P.O.Box 502299

Dubai Media City

United Arab Emirates

noushad(at)qanawat-me(dot)com

www.qanawat-me.com

[image: Description: Description: Description: Description: Description:
cid:image006(dot)png(at)01D000CC(dot)638BA950]*S**ave a tree. Don't print this e-mail
unless it's really necessary.*

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Clemens Ladisch 2018-08-08 20:43:25 Re: Issue with ODBC connection when export Database
Previous Message Jürgen E. Fischer 2018-08-02 07:38:15 Re: Patch to support service parameter & german translation