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

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

ksachar — Wed, 03 Feb 2016 14:18:07 GMT

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.

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

Kurt_Bremser — Wed, 03 Feb 2016 14:27:42 GMT

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