cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase Connection Error - cannot establish database connection

Former Member
0 Kudos

BO Data Services Tool -> Creation of new Data Store -> Sybase ASE

When I tried to create a sybase datastore(New connection), I've got this error message. But I am able to connect to sybase database with client application with same connection parameter. I appreciate if someone come across same issue.

ERROR MESSAGE

*WARNING: Cannot establish database connecton.

u2018Sybase connecton error: <Sybase ASE Server message number <1640> State <2> Severity <16> From Server <tstlS03>: Message Text is:

Adaptve Server requires encrypton of the login password on the network.

Sybase ASE Server message number <4002> State <1> Severity <14> From Server <tstlSO3>: Message Text is: Login failed.

Sybase CS Library message number <6717S468> Severity <4>: Message Text is: ct_connectO: protocol specific layer: external error: The attempt to connect to the server failed.>.u2019 lODI- 1111341)

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I tried to create repositories for sybase, it failed. But it succeeded when created datastore. The procedures's as follow:

1. Create ODBC for this sybase connection, and it should display "Connection successful" when you click "Test connection".

(you need to specify several parameters like user id & password, server,database name and file, etc.)

2. Create datastore by using ODBC connection.