Skip to Content
avatar image
Former Member

ERRORS in connect to Sybase DB in ABAP

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


dbco.JPG (46.9 kB)
error.JPG (103.5 kB)
st04.JPG (136.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 05, 2015 at 07:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded