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