Skip to Content
author's profile photo Former Member
Former Member

Need help in connecting/working with Chinese Sybase ASE database

i have question regarding problem i'm facing while working with Chinese Sybase ASE database

I'm trying to connect to a Chinese Sybase Adaptive Server on a machine with OS regional setting as China.

I'm connecting using ODBC from different Windows machine, so when using the regular ODBC connection string for connecting

( Such as: “DRIVER={Adaptive Server Enterprise};SERVER=SYB-SRV;port=5000;UID=sa;DB=;”)

It fails with the following error message:

“RetCode: SQL_ERROR SqlState: 08S01 NativeError: 30016 Message: [Sybase][ODBC Driver]Bad TDS response stream received from server. Unexpected end of reponse during login negotiation.”

When adding “charset=utf8” to the connection string i succeed to connect but, then I'm facing problems with calling other functions of the ODBC like SQLTables
which is returning no data instead of returning existing tables and schemas.

can you elaborate.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2013 at 10:00 PM

    Hi Said,

    I see this post in another SCN, but I am curious about why SQLTables isn't retrieving the data - can you elaborate?

    - What ASE ODBC Driver version

    - What sort of application details? Is it custom, console based? Gui?

    - Can you run with odbc trace?

    Cheers,

    -Paul

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Said,

      You can enable the ODBC APOI tracing with the built-in Windows utility odbcad32.exe.

      First determine if you're using 32 or 64-bit ASE ODBC Driver.

      For 32-bit the odbcad32.exe resides in \windows\SysWOW64

      64-bit in \windows\system32

      In the tool go to tracing tab, set filename, turn on trace, and apply/ok. A trick I learned is to immediately go back in the utility, and click tracing tab to activate the trace - make sure your ODBC Application IS NOT running when you set this tracing on.

      Also, please provide the version of the driver used.

      Cheers,

      -Paul

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.