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@xxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
