Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Posts
    2

    Unanswered: VB6 connection to Sybase not working after upgrade to 12.5 client

    I have recently upgraded to the 12.5 sybase client and the ADO connection to sybase has ceased to work. Upgrade was from 12.0 to 12.5.
    Using the following type of connection string (which should work at both levels) produces a 'Insufficient Information to Connect to the DataSource" error. This worked with the 12.0 driver but not with 12.5... Any ideas?

    cnSQL.ConnectionString = "Driver={Sybase ASE ODBC Driver};" & _
    "Srvr=" & m_strServerName & ";" & _
    "Db=" & m_strDataBaseName & ";" & _
    "Uid=" & g_strUserId & ";" & _
    "Pwd=" & m_strPasswd

    thanks in advance for your help.

  2. #2
    Join Date
    Feb 2006
    Posts
    4
    Going from what we observed when moving to 12.5 from 12.0, it is likely to be the charset.
    So you will have to set the charset for the client.

  3. #3
    Join Date
    Apr 2006
    Posts
    2
    Just in case wanted to let you know that I know understand that the actual driver version that still works with is 3.5 and it seems 4.10 and up is having problem.
    I will take your input to a DBA here (as I'm not exactly sure what you are referring to).... let me know if there is anything else that might be helpful in communicating this with him/her.

    thanks again.

Posting Permissions

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