Is it possible to connect to a PostgreSQL server using FreeTDS driver and tsql?

Question

Can I make a connection to a PostgreSQL server using FreeTDS, more specifically tsql command?

I've been trying for a few days now, using many different configurations. Even though I am able to connect to the DB using isql and PostgreSQL odbc driver, I can't to make it work for tsql (it also doesn't seem to use odbc.ini or odbcinst.ini). So, I was wondering if tsql only works with MSSQL.

If you want, I can post the files freetds.conf, odbc.ini and odbcinst.ini.

Thanks.

Good question but probably the wrong site. Should this be on Stackoverflow? — Avery Payne, Nov 18 '15 at 20:02
@AveryPayne, I thought here was more appropriate. But I'll give it a try over there. Thanks. — brunodea, Nov 18 '15 at 20:04

score 3 · Accepted Answer · answered Nov 18 '15 at 19:12

Different databases use different network protocols.

tsql only works with MS SQL and Sybase. That's actually an exception to the general rule, because they historically came from the same codebase.

For Postgres, you need the command-line client psql, or (as you mentioned already) the Postgres ODBC driver, or a program build using the Postgres C client library, or a java program using the Postgres JDBC driver, or a .NET program using the PGNP OLEDB driver...

Is it possible to connect to a PostgreSQL server using FreeTDS driver and tsql?

1 Answers1