What are some ways of accessing Microsoft SQL Server from Linux?

by

FreeTDS + unixODBC or iODBC

Install first FreeTDS, then configure one of the two ODBC engines to use FreeTDS as its ODBC driver. Then use the commandline interface of the ODBC engine.

unixODBC has isql, iODBC has iodbctest

You can also use your favorite programming language (I’ve successfully used Perl, C, Python and Ruby to connect to MSSQL)

I’m personally using FreeTDS + iODBC:

$more /etc/freetds/freetds.conf
[10.0.1.251]
    host = 10.0.1.251
    port = 1433
    tds version = 8.0

$ more /etc/odbc.ini
[ACCT]
Driver = /usr/local/freetds/lib/libtdsodbc.so
Description = ODBC to SQLServer via FreeTDS
Trace = No
Servername = 10.0.1.251
Database = accounts_ver8

More Related Contents:

  1. If condition in SQL Server 2008
  2. How to get the last row from a table in SQL Server?
  3. Comma separated results in SQL
  4. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  5. Which are more performant, CTE or temporary tables?
  6. Storing a file in a database as opposed to the file system?
  7. Preferred Method of Storing Passwords In Database
  8. How do you count the number of occurrences of a certain substring in a SQL varchar?
  9. Why is it considered bad practice to use cursors in SQL Server?
  10. Import Excel spreadsheet columns into SQL Server database
  11. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  12. SQL WHERE.. IN clause multiple columns
  13. Query to list all stored procedures
  14. How do I search an SQL Server database for a string?
  15. WHERE clause on SQL Server “Text” data type
  16. SQL Server – parameter sniffing
  17. Does the order of columns in a WHERE clause matter?
  18. How can I select from list of values in SQL Server
  19. Configure Lucene.Net with SQL Server
  20. SQL Server tables: what is the difference between @, # and ##?
  21. Forcing a query timeout in SQL Server
  22. Sql Server – connect with windows authentication
  23. SQL Rows to Columns
  24. SQL Server – Auto-incrementation that allows UPDATE statements
  25. What is the best way to implement Polymorphic Association in SQL Server?
  26. Set option 9 in SQL Server stored procedure using WinHttp.WinHttpRequest.5.1 for TLS 1.2
  27. How to maintain the order of insertion in SQL Server
  28. SQL SERVER – Understanding how MIN(text) works
  29. How to convert text column to datetime in SQL
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment