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
[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.*
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 |