on 12-31-2014 6:47 AM
Dear experts:
I need to connect to a sybase database for development,so firstly I create it in "DBCO" as below shows:
my format of conn. info is:SYBASE_DBNAME=<name> SYBASE_DBOWNER=dbo SYBASE_SERVER=<ip> SYBASE_PORT=<port>
and I write these codes to make a test and get below error:
TYPES:
BEGIN OF itob,
costcenterno LIKE ZIT_CC_USER-COSTCENTERNO, "ZIT_CC_USER is a DB table in my abap system.
end of itob.
DATA: itab TYPE TABLE OF itob,
wa TYPE itob.
EXEC SQL PERFORMING test.
SELECT *
INTO :wa-costcenterno
FROM ZIT_CC_NEWUSER@SYBASE-TEST "ZIT_CC_NEWUSER is the database in Sybase
WHERE SAPID = 'I004218'.
endexec.
FORM test.
WRITE:/ wa-costcenterno.
APPEND WA to itab.
CLEAR itab.
ENDFORM.
the error is this:
I cheak it in ST04 and it says:-- ERROR Database connection SYBASE-TEST: SQL error 4002 [ASE Error SQL4002:28000]SQL Anywhere Error -103: Invalid user ID or password.
BUT I cheak my Sybase DB's username&password and find no matters with it!
What should I do for this scenario?
Thanks a lot!!
Regards
Cao
Hello Zhiyu,
As mentioned previously in , SQL Anywhere isn't currently a supported target for DBCO (dbacockpit) connections.
---
The specific reason for it failing to log in in this context is that you're currently trying the ASE ODBC driver ("SQL error 4002 [ASE Error SQL4002:28000]") with a SQL Anywhere database server ("SQL Anywhere Error -103: Invalid user ID or password").
Regards,
Jeff Albion
SAP Active Global Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.