DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
lkevin1210
Participant



Joined: 13 Dec 2018
Posts: 5

Points: 169

Post Posted: Wed Dec 25, 2019 9:56 pm Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi, our datastage server is version 9.1.2 on AIX.
We have a very simple job to get the data from source database sql server and load to target database DB2.
In the SQL server, we have recently applied a security fix on it to enable TLS1.2 and disable SSL2.0 and SSL3.0.

After the security fix is applied, we could not connect to the sql server with ODBC connector.
When we test the data source connection in the ODBC connector, it prompts the following error:
ODBC function "SQLConnect" reported: SQLSTATE=08001; Native Error Code=0: Msg=[IBM(DataDirect OEM)][ODBC SQL Server Wire Protocol driver]SSL Negotiation failed.

Then, in the datastage engine server, we upgraded the data direct OEM SQL Server wire protocol driver from 7.1.0 to 7.1.6 and test the connection again, this time it prompts the following error:
ODBC function "SQLConnect" reported: SQLSTATE=28000; Native Error Code=18,456: Msg=[IBM(DataDirect OEM)][ODBC SQL Server Wire Protocol driver]Login failed for user 'user1'.

Our .odbcini is as simple as following:
[data_source]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMsqls00.so
Description=SQL Server connection
Database=mydb1
ConnectionRetryCount=3
Address=10.7.134.131,1433
LogonID=user1
Password=Abcd!234
QuotedID=No
AnsiNPW=No
EncryptionMethod=1
ValidateServerCertificate=0

Has anyone encountered similar issues? Thanks in advance.
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2881
Location: USA
Points: 21864

Post Posted: Thu Dec 26, 2019 4:11 am Reply with quote    Back to top    

I think it means your connection works OK now but you have a bad user/password combination. Verify it works outside of the ODBC driver first.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours