Issue with ODBC connection when export Database

Noushad Mohamed <[email protected]> Wed, 8 Aug 2018 12:55:56 +0400
Newsgroups gmane.comp.db.postgresql.odbc
Message-ID <[email protected]>
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:[email protected]]*





M  (+971) 547130913

T    (+971) 4 3913622



*Qanawat FZ L.L.C*

P.O.Box 502299

Dubai Media City

United Arab Emirates



[email protected]

www.qanawat-me.com

[image: Description: Description: Description: Description: Description:
cid:[email protected]]*S**ave a tree. Don't print this e-mail
unless it's really necessary.*
image001.jpg (image/jpeg, 2.2 KB) - not displayed
image002.jpg (image/jpeg, 1.3 KB) - not displayed
image003.png (image/png, 59.8 KB) - not displayed