I've got a working Azure SQL instance running, and I'm trying to connect using FreeTDS over command line with my config as:
[azure] host = ********.database.windows.net port = 1433 tds version = 7.2 database = ********
Using 7.2 as that's the only version that seems to allow me to connect; anything else prints there was an issue connecting to the server. Once connected, trying to run a query like:
1> SELECT * FROM CourseSchema.Members 2> GO
Msg 208 (severity 16, state 1) from ******** Line 1: "Invalid object name 'CourseSchema.Members'."
I've noticed that the object name seems to be treating the schema and table name as the same object, with an empty block after the following dot, and am not sure if this is perhaps something to do with the issue.
I've tried multiple configurations trying to sort this out, to no avail - any ideas?