CODEWITHSUNDEEP
mysqlmacosodbcunixodbc
Manish
Manish

Reputation: 1769

Unable to get unixODBC working on Mac

I am trying to connect to Microsoft MySQL server from a Mac.Debugging it step by step (I basically follow this post)I see that freeTDS works fine.But isql shows an error -

[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[01000][unixODBC][FreeTDS][SQL Server]Unknown host machine name.
[ISQL]ERROR: Could not SQLConnect

I installed freetds using Macports with

sudo port install freetds +mssql +odbc +universal

and created my own odbc.ini and odbcinst.ini files under /opt/local/etc (contents are same as what is shown in the above mentioned link )

I also checked this and this (Not sure how un-install can help when I installed freetds with +odbc).Any suggestions?

Upvotes: 0

Views: 266

Answers (1)

Manish
Manish

Reputation: 1769

If anyone bumps into this I figured out the solution-

Turns out the configuration name provided under freeTDS.conf had to precisely match the one in odbc.ini.

Upvotes: 0

Related Questions