How to resolve it?

[sravanpathu]

Hi Everyone,

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.

Regards,

Sravan

[LinusH]

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.

[JBailey]

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.

[JBailey]

Hi Sravan,

Any news on this issue? Were you able to get your connection to work?