search

tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Other
381 stars 102 forks source link

error create tds_fdw...help me #85

Open sugerdudu opened 8 years ago

sugerdudu commented 8 years ago

I install fdw long time,step error last. Help, follow code: postgres=# create extension tds_fdw; ERROR: could not load library "/home/program/pgsql9.5.4/lib/tds_fdw.so": /home/program/pgsql9.5.4/lib/tds_fdw.so: undefined symbol: dbresults

please question this what? How to solve? think you

sugerdudu commented 8 years ago

This is file existed. /home/program/pgsql9.5.4/lib/tds_fdw.so

centos 7

GeoffMontee commented 8 years ago

dbresults is a FreeTDS function. You most likely did not properly link tds_fdw with FreeTDS. If you have FreeTDS installed in a non-standard location, don't forget to populate SHLIB_LINK in the Makefile.

sugerdudu commented 8 years ago

Thinks GeoffMontee

image

My comments here, does it matter? Whether SHLIB_LINK is specified at compile time? I'll try.

sugerdudu commented 8 years ago

thinks GeoffMontee

test=# create extension tds_fdw;
CREATE EXTENSION

I have test successfully.

good

GeoffMontee commented 8 years ago

Hi @sugerdudu,

It's working for you now? Awesome!

sugerdudu commented 8 years ago

@GeoffMontee
Yes, is successed. Good. The data may be read.

But the Chinese garbled,I also in solving. Do you know this problem?

sugerdudu commented 8 years ago

Chinese garbled question,I have been solved. install freetds need remove --disable-libiconv ex. ./configure --prefix=/home/program/freetds --with-tdsver=7.4 --enable-msdblib