02-03-2016 09:18 AM
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.
02-03-2016 09:27 AM
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