debugging odbc connections in Linux

[jdlong]

ok.. if I hand roll my connection string in R the bloody thing works.

so this is a bug in my library that handles my credentials & logging in.

so I went through that code and I discovered that after I set up the connection I send a single command over that connection:

odbc::dbSendQuery(con, "SET QUOTED_IDENTIFIER ON")

Well it looks like that quoted identifiers bit was carried over from this experience:

Changing the table quoting with SQL Translation

I'm using RJDBC to access a SQL Server database. Everything works pretty well except for one thing (that keeps it from working at all). dbplyr is defaulting to quoting table aliases in the resulting SQL like this: SELECT top 5 * FROM mydb.myschema.mytable "mt" join mydb.myschema.myothertable "mot" on "mt".key = "mot".key My SQL Server thinks that's a really bad idea and desperately wants me to put table aliases in square brackets: SELECT top 5 * FROM mydb.myschema.mytable [mt] join mydb.myschema.myothertable [mot] on [mt].key = [mot].key I can see from the documentation that DBI:: dbQuoteIdentifier() is involved in this process, but I can't figure out how to tell it to use square …

It looks like TDS does quoting by default so I need to not pass this param. Though I have no idea why it used to work and now breaks.