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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.