0

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.

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

1 Answer 1

Reset to default
3

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...

Improve this answer
0

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.