SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Case sensitive Schema in Libname statement when connectiong to SQL tables with AD account?

Accepted Solution Solved
Reply
Regular Contributor
Posts: 171
Accepted Solution

Case sensitive Schema in Libname statement when connectiong to SQL tables with AD account?

Hi All,

 

    I have difficulty to understand why the schema is case sensitive in libname statement when connecting to SQL tables with AD account.

 

For example:   

LIBNAME test SQLSVR DATASRC='SQL_Server_name' qualifier=SQL_Database_name SCHEMA=dbo USER='domain\windows_ID' PASSWORD='windows_Password';

 

here the schema dbo is case sensitive, but the SQL server name and SQL database name are not case sensitive. Do you know the reason of that?

 

Thank you!

Jade

 

 


Accepted Solutions
Solution
‎07-28-2017 01:11 PM
PROC Star
Posts: 1,167

Re: Case sensitive Schema in Libname statement when connectiong to SQL tables with AD account?

It has caused a bunch of people problems through the years. I don't believe this has anything to do with SAS; I think that SAS just passes this through to the SQL Server engine, and this case sensitivity is a feature of SQL Server.

 

Tom

View solution in original post


All Replies
Solution
‎07-28-2017 01:11 PM
PROC Star
Posts: 1,167

Re: Case sensitive Schema in Libname statement when connectiong to SQL tables with AD account?

It has caused a bunch of people problems through the years. I don't believe this has anything to do with SAS; I think that SAS just passes this through to the SQL Server engine, and this case sensitivity is a feature of SQL Server.

 

Tom

Regular Contributor
Posts: 171

Re: Case sensitive Schema in Libname statement when connectiong to SQL tables with AD account?

Thank you TomKari!

The thing I do not understand are:

1) The schema is not case sensitive in SQL Studio, just like the database name etc.

2) The database name and the server name are not case sensitive in SAS Libname statement

 

Combine 1) and 2), I did not see anything special about schema, then why only schema is case sensitive in SAS Libname statement?

 

Thanks,

Jade

PROC Star
Posts: 1,167

Re: Case sensitive Schema in Libname statement when connectiong to SQL tables with AD account?

I agree with you that it's odd. Unfortunately, there's no way for us to tell whether it's still case sensitive in SQL Studio, and the product adapts for that, or whether SAS is doing something odd. Just one of those things we have to live with.

 

However, I can report that the same behaviour exists with at least one other database product (can't remember which, it was years ago), so that leads me to think it's the first option.

 

Tom

Regular Contributor
Posts: 171

Re: Case sensitive Schema in Libname statement when connectiong to SQL tables with AD account?

Thank you, Tom!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 349 views
  • 1 like
  • 2 in conversation