Salesforce

Unable to connect a 11.7 client to a 11.3 DataServer Broker.

« Go Back

Information

 
TitleUnable to connect a 11.7 client to a 11.3 DataServer Broker.
URL Nameunable-to-connect-a-11-7-client-to-a-11-3-dataserver-broker
Article Number000119396
EnvironmentProduct: OpenEdge
Version: 11.7, 11.3
OS: Linux, Windows
Other: DataServer
Question/Problem Description
Unable to connect a 11.7 client to a 11.3 DataServer Broker.
11.3 client to 11.3 DataServer broker works fine.
If the client version is 11.7 it does not work.
The only thing changing is the client version.
OE compatability articles indicate that this configuration should work.
Error message mentioned a username that appears to be encrypted. 
 
Steps to Reproduce
Clarifying Information
Clients are on Linux, both schema holder and DataServer broker are on Windows, same machine.
11.7 client is using the same connection string as 11.7.  
Error MessageDEBUG [Thread-2] STDOUT - Login was denied because of an authorization error. (6179)
28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'oech1::########'.
Failed to connect to the MSS database. (6142)
28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'oech1::########'.
Failed to connect to the MSS database. (6142)
Defect Number
Enhancement Number
Cause
On OE 11.4 that was a change to encrypt the username and password when connecting to MSS Dataserver broker.
The 11.7 client has this change, when connecting to a 11.3 DataServer Broker, the broker does not know how to decrypt the information that is provided.
Hence the error with the encrypted user name.
Resolution
Upgrade the DataServer Broker version to match the client version.
Workaround
Use the -znoencrypt parameter which reverts the behaviour to pre 11.4.
 
Note: The -znoencrypt parameter does not work in a ABL connect statement.
The following error is returned:

 Warning: -znoencrypt is not a database parameter and was ignored. (1402)

This parameter must be used as a client startup parameter. 

 
Notes
Keyword Phrase
Last Modified Date9/23/2022 1:35 PM

Powered by