cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
geoffu8
‎11-11-2015
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Configure connection to Sybase where password encryption is enable...

by Calcite | Level 5 in SAS Data Management
‎11-11-2015 04:02 AM
‎11-11-2015 04:02 AM
Can you be more specific? How do I define the connection string? I tried this way :   connect to sybase as link   (noprompt = "Data Source=ServerName;Port=14112;Database=dbname;Uid=userid;Pwd=password;EncryptPassword=2;");     That didn't seem to work. How do I define the connection string, like an ODBC connection ? An example of the connection string would be useful.   Thanks, ... View more

Configure connection to Sybase where password encryption is enabled

by Calcite | Level 5 in SAS Data Management
‎11-08-2015 10:58 PM
‎11-08-2015 10:58 PM
Is anyone familiar with configuring a SQL Pass-through connection in SAS to a Sybase database where password encryption is enabled?   We are using the sample connection: connect to sybase as link (server="dbserver" database="dbname" schema="link" user="userid" password="password"); This is encountering the below error. ERROR: Connection failed. Error Code: -1640 Adaptive Server requires encryption of the login password on the network.   Normally, we would pass (encryptPassword=2) on the connection string. But I'm not familiar with how to pass this value to SAS connection string.   Any help would be appreciated. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-11-2015 04:33 AM
Quick links