Thread: connect to MS SQL server

connect to MS SQL server

From
"dhninh"
Date:
Hi !
Sorry for my English!
 
I'm a beginner Linux and PostgreSQL, so I haven't much experience.
I'm using Redhat Linux 7.0

Now I want to use Postgres as frontend to connect  to MS SQL server on a Windows machine . Is it possible ?
If you know , please guide me.

Many thanks in advance

RE: connect to MS SQL server

From
László Tibor
Date:
> Now I want to use Postgres as frontend to connect  to MS SQL server
> on a Windows machine . Is it possible ?

No. In your terms Postgres is a backend, not a frontend. What you've
installed with RedHat is a PostgreSQL server (backend). Of course
you can write, use frontends (there are some with the ditribution,
eg. psql) with PostgreSQL from the Linux box or from any Windows
machine, but only for accessing PostgreSQL backends. This list is
only for these issues.

The PostgreSQL backend uses its own backend protocol as the M$ SQL
Server does. They are absolutely incompatible. So use a backend for
M$ SQL on Windows. You needn't use any PostgreSQL related thing...
Please refer your SQL Server documentation, or visit
http://www.microsoft.com/Servers/

Regards,

Tibor Laszlo
ltibor@mail.tiszanet.hu