Обсуждение: postgres -> ms sql7 odbc driver

Hi all

I'm new to this list, so please excuse me if I asked a question asked
many times before.

Is there a driver available that runs on a Linux box (or freeBSD)  that
I can use to access
data in a ms Sql database.  (The opposite of the odbc driver that you
install under windows
that gives you access to the Postgres database from windows programs
like access and delphi.

Thanking you

Stephen Wright

SJ Wright wrote:
> 
> Hi all
> 
> I'm new to this list, so please excuse me if I asked a question asked
> many times before.

AFAIK it was asked once (on was off-topic then too ;)

> Is there a driver available that runs on a Linux box (or freeBSD)  that
> I can use to access data in a ms Sql database. 
> (The opposite of the odbc driver that you install under windows
> that gives you access to the Postgres database from windows programs
> like access and delphi.

Try FreeTDS

http://metalab.unc.edu/freetds/faq.html

And if this does not work, set up a small proxy on the NT box that runs 
the server and access that ;)

----------------
Hannu

abdelkrim wrote:

> hello
>
> i use the :
>
> >> postmaster -B 128 -i &
>
> and i have the same problem:
>
> *******************************************************************************
>
> QUERY: INSERT INTO test_complex VALUES ('(1.0, 2.5)', '(4.2, 3.55 )');
>
> *******************************************************************************
>
> press return to continue
>
> assertion "u.hdr.e_phentsize == sizeof(Elf_Phdr)" failed: file
> "/usr/src/libexec/rtld-elf/map_object.c", line 118
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally before or
> while processing the request.
> We have lost the connection to the backend, so further processing is
> impossible.  Terminating.
> postgres@kosovo>> IpcMemoryCreate: shmget failed (Invalid argument)
> key=5432101, size=1365584, permission=600
> FATAL 1:  ShmemCreate: cannot create region