DevHeads.net

Issue with ODBC connection when export Database

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
<a href="https://www.postgresql.org/ftp/odbc/versions/msi/" title="https://www.postgresql.org/ftp/odbc/versions/msi/">https://www.postgresql.org/ftp/odbc/versions/msi/</a>, 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. ... 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

<a href="mailto:noushad@qanawat-me.com">noushad@qanawat-me.com</a>

<a href="http://www.qanawat-me.com" title="www.qanawat-me.com">www.qanawat-me.com</a>

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

Comments

Re: Issue with ODBC connection when export Database

By Clemens Ladisch at 08/08/2018 - 16:43

Noushad Mohamed wrote:
Error IM014 indicates a 32-bit/64-bit mismatch.

Is the export wizard 32 or 64 bits?

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

Regards,
Clemens