Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2005
    Posts
    4

    Unanswered: [SOLVED] Error -85 : SQLSTATE = 08S01

    Hi all,

    I have aproblem with one of my application.
    I have 5 identically applications, all running on the same server, with sybase base.
    All are quasi identically, only data and name differs.

    Everything ran great but yesterday, an error appear when clicking on a button of our appli.

    Here is the error :

    Error -85 : SQLSTATE = 08S01

    here is the log from ODBC tracer:

    Code:
    appli_v7     ca8-c14    ENTER SQLExtendedFetch
            HSTMT               02111450
            UWORD                        1 <SQL_FETCH_NEXT>
            SQLLEN                     1
            SQLULEN *           0x0012F760
            UWORD *             0x03570A28
    
    appli_v7     ca8-c14    EXIT  SQLExtendedFetch  with return code -1 (SQL_ERROR)
            HSTMT               02111450
            UWORD                        1 <SQL_FETCH_NEXT>
            SQLLEN                     1
            SQLULEN *           0x0012F760
            UWORD *             0x03570A28
    
            DIAG [08S01] [Sybase][ODBC Driver][Adaptive Server Anywhere]Communication link failure: Communication error (-85)
    
    appli_v7     ca8-c14    ENTER SQLErrorW
            HENV                021112A0
            HDBC                02111348
            HSTMT               02111450
            WCHAR *             0x0012F6F0 (NYI)
             SDWORD *            0x0012F738
            WCHAR *             0x0012F2F0
            SWORD                      512
            SWORD *             0x0012F740
    here is the trace from the appli :

    Code:
    (2020670): PREPARE:
    (2020670):   SELECT DISTINCT  "tcollaborateur"."nom" ,           "tcollaborateur"."prenom" ,           "tcollaborateur"."type_collab" ,           "tcollaborateur"."date_embauche" ,           "tcollaborateur"."date_naiss" ,           "tcollaborateur"."valid" ,           "tcollaborateur"."lieu_naiss" ,           "tcollaborateur"."cd_pays_naiss" ,           "tcollaborateur"."adr_lieu_dit" ,           "tcollaborateur"."adr_num_voie" ,           "tcollaborateur"."adr_btq" ,           "tcollaborateur"."adr_rue" ,           "tcollaborateur"."adr_bureau" ,           "tcollaborateur"."adr_localite" ,           "tcollaborateur"."adr_cp" ,           "tcollaborateur"."tel" ,           "tcollaborateur"."loisirs" ,           "tcollaborateur"."cd_qualif_embauche" ,           "tcollaborateur"."date_modif_cont" ,           "tcollaborateur"."cd_qualif_modif_cont" ,           "tcollaborateur"."cd_collab_paye" ,           "tcollaborateur"."salaire_embauche" ,           "tcollaborateur"."salaire_modif_cont" ,           "tcollaborateur"."cd_pays_nationalite" ,           "tcollaborateur"."cd_situation" ,           "tcollaborateur"."nb_enfant" ,           "tcollaborateur"."cdf" ,           "tcollaborateur"."nb_cv" ,           "tcollaborateur"."sexe" ,           "tcollaborateur"."date_sortie" ,           "tcollaborateur"."cd_collab"     FROM "tcollaborateur"     (0 MilliSeconds)
    (2020670): BIND SELECT OUTPUT BUFFER (DataWindow): (0 MilliSeconds)
    (2020670): ,len=27,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=17,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=30,type=DATE,pbt=7,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=30,type=DATE,pbt=7,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=27,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=5,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=34,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=44,type=FLOAT,pbt=3,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=28,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=28,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=28,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=7,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=17,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=52,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=6,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=30,type=DATE,pbt=7,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=6,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=44,type=FLOAT,pbt=3,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=88,type=DECIMAL,pbt=4,dbt=0,ct=0,prec=0,scale=2
    (2020670): ,len=88,type=DECIMAL,pbt=4,dbt=0,ct=0,prec=0,scale=2
    (2020670): ,len=5,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=44,type=FLOAT,pbt=3,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=44,type=FLOAT,pbt=3,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=30,type=DATE,pbt=7,dbt=0,ct=0,prec=0,scale=0
    (2020670): ,len=44,type=FLOAT,pbt=3,dbt=0,ct=0,prec=0,scale=0
    (2020670): EXECUTE: (0 MilliSeconds)
    (2020670): FETCH NEXT: (16 MilliSeconds)
    (2020670): 
     Error -85 (rc -1) : SQLSTATE = 08S01
    [Sybase][ODBC Driver][Adaptive Server Anywhere]Communication link failure: Communication error
    (2020670): CANCEL: (0 MilliSeconds)
    (2020670): PREPARE:
    (2020670):   SELECT DISTINCT  "tcollaborateur"."nom" ,           "tcollaborateur"."prenom" ,           "tcollaborateur"."type_collab" ,           "tcollaborateur"."date_embauche" ,           "tcollaborateur"."date_naiss" ,           "tcollaborateur"."valid" ,           "tcollaborateur"."lieu_naiss" ,           "tcollaborateur"."cd_pays_naiss" ,           "tcollaborateur"."adr_lieu_dit" ,           "tcollaborateur"."adr_num_voie" ,           "tcollaborateur"."adr_btq" ,           "tcollaborateur"."adr_rue" ,           "tcollaborateur"."adr_bureau" ,           "tcollaborateur"."adr_localite" ,           "tcollaborateur"."adr_cp" ,           "tcollaborateur"."tel" ,           "tcollaborateur"."loisirs" ,           "tcollaborateur"."cd_qualif_embauche" ,           "tcollaborateur"."date_modif_cont" ,           "tcollaborateur"."cd_qualif_modif_cont" ,           "tcollaborateur"."cd_collab_paye" ,           "tcollaborateur"."salaire_embauche" ,           "tcollaborateur"."salaire_modif_cont" ,           "tcollaborateur"."cd_pays_nationalite" ,           "tcollaborateur"."cd_situation" ,           "tcollaborateur"."nb_enfant" ,           "tcollaborateur"."cdf" ,           "tcollaborateur"."nb_cv" ,           "tcollaborateur"."sexe" ,           "tcollaborateur"."date_sortie" ,           "tcollaborateur"."cd_collab"     FROM "tcollaborateur"     (0 MilliSeconds)
    (2020670): 
     Error -308 (rc -1) : SQLSTATE = S1000
    [Sybase][ODBC Driver][Adaptive Server Anywhere]General error: Connection was terminated
    (2020670): CANCEL: (0 MilliSeconds)
    (2020670): COMMIT: (0 MilliSeconds)
    (2020670): 
     Error -308 (rc -1) : SQLSTATE = S1000
    [Sybase][ODBC Driver][Adaptive Server Anywhere]General error: Connection was terminated
    (2020670): DISCONNECT: (0 MilliSeconds)
    (2020670): SHUTDOWN DATABASE INTERFACE: (0 MilliSeconds)
    I try to change the base whit one which work but the error appear again !

    So the problem isn't from the database... ?

    With an empty base, it works...

    Here is my ini file :
    Code:
    [Database]
    DBMS=TRACE ODBC
    Enginename=
    Database=
    UserID=
    DatabasePassword=
    LogId=
    LogPassword=
    DbParm=Connectstring='DSN=mybase_v70',DisableBind=1
    AutoCommit=FALSE
    
    [reporting]
    importpath=c:\reporting\import\
    exportpath=c:\reporting\export\
    Arg, any help is welcome...

    PS : Sorry for my poor english
    Last edited by foobar47; 12-30-05 at 06:36. Reason: [SOLVED]

  2. #2
    Join Date
    Dec 2005
    Posts
    4

    Question

    Note that the client is ran from the server.

    The assistants connect the server via Terminal Server and launch application on the server...

    I tried to connect from another computer with the application on this computer with success ! but just twice...


  3. #3
    Join Date
    Dec 2005
    Posts
    6

    Base ?

    HI foobar,
    What do you mean by base? It seems like you had a network issue. Even though you are running the client and server on the same machine if the listener port is blocked you could get the error.

    Harki

  4. #4
    Join Date
    Dec 2005
    Posts
    4

    Red face

    Quote Originally Posted by harki
    What do you mean by base? It seems like you had a network issue. Even though you are running the client and server on the same machine if the listener port is blocked you could get the error.

    Harki
    Hi,

    Firsrt, thanks to reply...

    The "base" is a Adaptive Server Anywere database 7.0...

    There is one database for one application.

    We have 7 application, just one is bugging...

    When i add a new application by duplicating database and application which are not bugging, it still bug...

    I reboot my server, without any change...
    I restart service without any more change...

    I don't think there is a port issue... I launch application from another computer which connect to the server database successfully...


    Thanks for help...

  5. #5
    Join Date
    Dec 2005
    Posts
    4

    Thumbs up [solved]

    Ok,

    I solved it by increasing the buffer size in the ODBC parameters...

    Thanks and happy new year...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •