SAS Connection to SQL error via ODBC

[Jade_SAS]

No, they can not

[Jade_SAS]

Do you know the exact reason? Where I can find the reference of this ?

[JBailey]

This is most likely a configuration issue. It is best to call SAS Tech Support.

[Jade_SAS]

Thank you!

[anja]

Hallo Jade,

The error message seems to be missing some info. What comes behind the error:[ ?

Are you using Access to ODBC, and if yes, what bitness?

What is the bitness of your OS?

Thanks

Anja

[Jade_SAS]

@anja Sorry I missed this reply.

That's all the Error said.

yes, I am using access ODBC to connect to Microsoft sql tables, I think it is 32 bit.

Talking OS, I may need to ask the SAS admin, as we using SAS server.

Thank you!

[Kurt_Bremser]

I merged the identical questions into one thread in General SAS Programming.

Please post ERROR messages and such as text, using the {i} button. MS Office documents can contain malware and are therefore blocked in many places. For screenshots, use the png format, but text is always preferred.

[Jade_SAS]

@Kurt_Bremser

Could you please let me know the link of the thread you talked about? Thank you!

[Kurt_Bremser]

---

@Jade_SAS wrote:

@Kurt_Bremser

Could you please let me know the link of the thread you talked about? Thank you!

---

The other thread no longer exists, as it has been merged into this one.

[Jade_SAS · Accepted solution]

Contacted with SAS Support, and it turned out there is system setting up problem with the SAS linux.

1)Try to insert the following line to $SASROOT/bin/sasenv_local file:

export EASYSOFT_U NICODE=YES

2)Restart SAS on server

Then everything is fixed.