Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    2

    Unanswered: migrating Sybase System 11 to 12.5 ASE ODBC drivers

    Hello,
    I'm trying to upgrade ODBC drivers from System 11 to ASE 12.5. I have several existing DSNs and Access/Excel queries created using the old ODBC driver. However I can not get these queries to work with the 12.5 driver, even after recreating the DSNs.

    Does anyone know of a way to "migrate" these DSNs to use the new driver without having to manually recreate each one?

    How do I get my existing Access/Excel queries to work with the new driver?

    The applications crash whenever I try to edit/view my sql statements or view linked tables. The only way I can get this to work is to recreate both the DSN and query(ies) with ASE 12.5 ODBC - that is basically everything.

    I'm at a loss - Sybase doesn't give a clear indication of an ODBC upgrade path from 11.9x to 12.x.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    paste the following to a file.reg and modify it according to your needs
    (the driver row) Description ..

    REGEDIT4

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TEST04]
    "Driver"="X:\\Sybase\\12_5\\ODBC\\syodase.dll"
    "Description"="Sybase on TEST04"
    "ServerName"=""
    "Servers"=""
    "Database"=""
    "Databases"=""
    "LogonID"=""
    "InterfacesFile"=""
    "Charset"=""
    "WorkStationID"=""
    "Language"=""
    "ApplicationName"=""
    "OptimizePrepare"="1 - Partial"
    "ArraySize"="50"
    "SelectMethod"="0 - Cursor"
    "PacketSize"="0"
    "CursorCacheSize"="1"
    "PasswordEncryption"="0"
    "ApplicationUsingThreads"="1"
    "EnableQuotedIdentifiers"="0"
    "SecurityServiceProvider"=""
    "DirectoryServiceProvider"=""
    "InitializationString"=""

    possibly you will need to modify the HKLM/software/odbc/odbc.ini odbc datasource entry appropiately

  3. #3
    Join Date
    Mar 2003
    Posts
    2
    Thanks for the info! This worked great for Access!
    This does a few quirky things: while it allows a relatively smooth transition in Access (linked tables remain intact); Excel and the ODBC Manager don't fare as well.
    Since the DSN parameters are embedded in the workbook - the server (SRVR) field has changed for the Sybase 12.x driver where now it looks for network address (NA). For some reason Excel refuses to work even with the registry fix when it included both entries from the old and new formats.
    The ODBC Manager fails to display the settings for the 11 driver.
    "Could not load translator or setup library"
    This is most likely caused by the System 11 key not properly pointing to the correct .dll. This should be relatively easy to correct.

    Right now probably I'm going to keep the 11 driver with the new 12.x OpenClient and ODBC driver. Slowly migrate any desktop apps that use the old driver to the new, this will involve quite a bit of work to change everything over. Unfortunately I haven't any other "elegant" way of doing this.

Posting Permissions

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