Re^18: install_driver(ODBC) mac mojave 10.14.2

Replies are listed 'Best First'.
Re^19: install_driver(ODBC) mac mojave 10.14.2 by poj (Abbot) on Jan 25, 2019 at 15:43 UTC
Seems strange that this works tsql -S servername.xxxx.xxxx.net -U username -P password -D dbname but this doesn't tsql -S MYMSSQL -U username -P password -D dbname Try enable logging and using just server name in freetds.conf `# Whether to write a TDSDUMP file for diagnostic purposes # (setting this to /tmp is insecure on a multi-user system) [global] dump file = /tmp/freetds.log debug flags = 0xffff [MYMSSQL] host = servername.xxxx.xxxx.net` [download] poj	[reply] [d/l]
Re^19: install_driver(ODBC) mac mojave 10.14.2 by marto (Cardinal) on Jan 25, 2019 at 14:45 UTC
`mysql --version mysql Ver 8.0.13 for osx10.14 on x86_64 (Homebrew)` [download] mysql is not the same thing as MS SQL Server.	[reply] [d/l]
Re^20: install_driver(ODBC) mac mojave 10.14.2 by raventheone (Novice) on Jan 25, 2019 at 14:49 UTC
`how would i see the version installed?` [download]	[reply] [d/l]
Re^21: install_driver(ODBC) mac mojave 10.14.2 by marto (Cardinal) on Jan 25, 2019 at 14:53 UTC
Assuming you can connect in some other fashion `SELECT @@version` should work. Failing that you could ask your systems administrator. Your initial post mentions 'Azure Data Studio'. I'm sure Azure has some UI to show you what you're running.	[reply] [d/l]
Re^20: install_driver(ODBC) mac mojave 10.14.2 by raventheone (Novice) on Jan 25, 2019 at 15:28 UTC
`DESKTOP-J2QR254:etc raventheone$ sqlcmd -S Server -U user -P pw + Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Can't open li +b 'ODBC Driver 17 for SQL Server' : file not found.` [download]	[reply] [d/l]
Re^21: install_driver(ODBC) mac mojave 10.14.2 by marto (Cardinal) on Jan 25, 2019 at 15:34 UTC
If your Mac can't connect to the server you're trying to connect to (isn't this what you're trying to fix?) you're going to have to find another way external to this, as per my previous statement.	[reply]