Desktop productivity for business analysts and programmers

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

Reply
Contributor
Posts: 28

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

 

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. 

Esteemed Advisor
Posts: 6,706

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

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 1 reply
  • 205 views
  • 0 likes
  • 2 in conversation