From: | loref85 <loref85(at)yahoo(dot)com(dot)ar> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Read tables of sql server with postgres |
Date: | 2014-02-21 13:50:43 |
Message-ID: | 1392990643091-5793046.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to access sql server tables through postgres, I tried using this
wrapper for databases with this ODBC driver
<http://www.postgresonline.com/journal/archives/249-ODBC-Foreign-Data-wrapper-to-query-SQL-Server-on-Window---Part-2.html>
, but the lastest version is compatible only with the 9.1 version of
Postgresql
I need a odbc driver for Postgresql 9.3
This is my sql shell (psql) when I try to do a CREATE EXTENSION statement
postgres=# CREATE EXTENSION odbc_fdw;
ERROR: biblioteca «C:/Archivos de programa/PostgreSQL/9.3/lib/odbc_fdw.dll»
inc
ompatible: versión no coincide
DETALLE: Servidor tiene versión 9.3, biblioteca es versión 9.1.
postgres=#
The error says "library «C:/Archivos de
programa/PostgreSQL/9.3/lib/odbc_fdw.dll» inc ompatible: version doesn't
match DETAIL: the server version is 9.3 and the lib version is 9.1"
Then I realized I can't use or compile the 9.1 version because of this
<http://www.postgresql.org/message-id/28812.1337278335@sss.pgh.pa.us>
So I found this version by another author, the code is adapted to postgres
9.2+ versions. I compiled in 9.2.6 and 9.3.2 versions and I get this error
in both versions when I try to make a select into a foreign table:
ERROR: odbc_fdw::odbcGetTableSize: Could not retrieve table size
Is there another path to follow? the problem is not odbc, I just need to
read sql server tables (but I didn't found a sqlserver connector though)
My second option is access sqlserver tables across linked server in
sqlserver, but I want to discard all the options from the postgres side
pd: If there's any grammar mistakes, sorry
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Read-tables-of-sql-server-with-postgres-tp5793046.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-02-21 14:40:47 | Re: semi-variable length type |
Previous Message | Torsten Förtsch | 2014-02-21 08:17:47 | How to continue streaming replication after this error? |