search

codio / boxparts

Simple package manager
https://codio.com
Other
29 stars 26 forks source link

Add the FreeTDS ./configure that worked locally #228

Closed jondkinney closed 9 years ago

jondkinney commented 9 years ago

We're having issues with openssl working properly on Codio with FreeTDS where we do not have that issue locally when installing FreeTDS from Homebrew on a mac. These are the configure flags that homebrew used and we can successfully connect locally on a mac with tsql.

peteonrails commented 9 years ago

Specifically, this configuration can be used to connect to a Microsoft Azure cloud hosted SQL instance.

ksimuk commented 9 years ago

is it a reason why this flags can't be used for building default freetds package?

jondkinney commented 9 years ago

FreeTDS can connect to Sybase and MS SQLServer, but not with the same TDS Version. The other box part compiles tsql to TDS version 5.0 which only connects to Sybase. We need to configure to TDS version 7.2 for SQL Server 2005+ support. (though we were only able to get 7.1 to connect for our use case, so we reverted to that).

There is some weirdness with the version numbering as well, more details here - http://www.freetds.org/userguide/tdshistory.htm

jondkinney commented 9 years ago

I tested this box part install using the instructions provided for testing custom box part installs and was able to connect to our Azure SQL instance.

We've already run these commands locally on our dev box, so we're up and running, but it could save some other folks some time to add this azure compatible version.

ksimuk commented 9 years ago

thank you, I've merged changes and compiled the binary, also now php5-mssql uses azure version of freetds by default.