01-24-2014 10:49 PM
I had oracle server, i have converted it into ODBC. Am able to connect this ODBC through BASE - SAS. But when i am trying through Management console studio it is showing invalid Login. Here am using same login id.
Please help me.
01-27-2014 09:03 AM
You give us very little to work on.
First, have you tried the ODBC connection from another client (than SAS) from the same server, i.e. Excel?
Then, you need to describe in more detail what/how you have defined your database server, schema and library in SMC. And how you defined the login, the authentication domain, user (groups) etc.
01-31-2014 09:27 AM
Have you displayed the LIBNAME statement that is being generated so that you know you are using the same userid? It may be picking up something entirely different. @LinusH mentions authentication domains - that is a very good area to review.