Thread: Issue with ODBC connection when export Database

Issue with ODBC connection when export Database

From

Noushad Mohamed

Date:

08 August 2018, 14:55:56

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

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

M (+971) 547130913

T (+971) 4 3913622

Qanawat FZ L.L.C

P.O.Box 502299

Dubai Media City

United Arab Emirates

noushad@qanawat-me.com

www.qanawat-me.com

Save a tree. Don't print this e-mail unless it's really necessary.

Attachment

Re: Issue with ODBC connection when export Database

From

Clemens Ladisch

Date:

09 August 2018, 02:43:25

Noushad Mohamed wrote:
> I get below error.

Error IM014 indicates a 32-bit/64-bit mismatch.

> ODBC connection I created is with the 64 Bit

Is the export wizard 32 or 64 bits?

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

The version and architecture of the server do not matter for this.


Regards,
Clemens