schema name like aaa\bbb giving CLI error: Incorrect syntax near '\' in libname statement

[ksachar]

I am declaring a library as follow:

libname r sqlsvr datasrc=sqlsvrdw qualifier=Analytics schema='Classic\zzzz' user='classic\yyyy' password='xxx';

(Note: zzz and yyy are like ksachar)

I am getting an error 

ERROR: CLI describe error: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Incorrect syntax near '\'.

I can access other schemas in analytics database where teh schema name is like "schema" anything that has '\' is giving error. 

[Kurt_Bremser]

AFAIK, the backslash cannot be used in a regular identifier in MS SQL server, but it may be used in a delimited identifier (means the identifier is enclosed in angular brackets).

So if somebody managed to create the schema by using a delimited identifier, and you have no means to transfer the delimiters through the ODBC engine, you cannot access the schema.

- try using angular brackets

- have the schema renamed with a valid regular identifier

see

Database Identifiers