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

How to resolve it?

Reply
Contributor
Posts: 26

How to resolve it?

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

Super User
Posts: 5,437

Re: How to resolve it?

Posted in reply to sravanpathu

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.

Data never sleeps
SAS Employee
Posts: 215

Re: How to resolve it?

Posted in reply to sravanpathu

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.

SAS Employee
Posts: 215

Re: How to resolve it?

Posted in reply to sravanpathu

Hi Sravan,

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

Ask a Question
Discussion stats
  • 3 replies
  • 339 views
  • 0 likes
  • 3 in conversation