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

Connection to Sybase ASE 12.5.0.3 from Windows Server 2008

May I ask if it's possible to connect to ASE 12.5.0.3 from Windows Server 2008? We need to install the client but there's no response after we double clicked the installation program in 2008.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Dec 12, 2013 at 03:31 AM

    Generally speaking you should be able to connect to an ASE dataserver anywhere on your network assuming a) your local interfaces/sql.ini file has the correct address for the dataserver (or alternatively you have a valid ODBC data source defined) and b) you have OS-certified software loaded/configured locally that can create the necessary network connection to the dataserver. ("Duh, Mark!" ?)

    What's not clear (to me) is what you're trying to do ...

    - is this Windows2008 32bit or 64bit?

    - are you trying to install ASE 12.5.0.3 on Windows2008 and if so, what's the name of the installation program and where did you get it from? [need to determine if you've got a valid installation program and whether it's supported on Windows2008; platform certification @ sybase.com seems to indicate you need 12.5.4 ESD 4+ if running ASE on Windows2008]

    - are you trying to install a client application/program on Windows2008 and if so, what is the name and version of the client application/program and where did you get it from? [need to know if this is a Sybase installation program vs a 3rd party application; will then need to determine if said software is certified on Windows2008]

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Carl,

      Were you able to resolve this issue by using a newer version of the SDK?

      I would assume you are running into a compatibility issue.

      You could always try to run the installation in console mode.

      example:

      open cmd prompt

      cd <where setup located>

      SDK 12.x

      setup.exe -i console

      or

      setup.exe -console

      SDK 15.x

      setupConsole.exe -i console

      This might only be an issue with the GUI installer.

      I would suggest to use SDK 15.5 ESD#12.

      Also, don't forget to upgrade the MDA scripts on the ASE.

      More information this is found in the README file when downloading SDK client.

      Regards,

      Ryan

  • Posted on Dec 26, 2013 at 10:07 PM

    12.5.3 is rather old for now.

    But you can still use it in win2008. I assume you have installed ODBC components in your ASE database server on windows system.

    All the thing you need do is to copy the subdir ODBC from %SYBASE%

    into the target win2008 machine, like:

    d:\SybaseASE_ODBC, and the ODBC is its subdir.

    Then you can populate the following registry entry by execute it with admin privilege.



    1. Windows Registry Editor Version 5.00
    2. [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers]
    3. "SYBASE ASE ODBC Driver"="Installed"
    4. [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Sybase ASE ODBC Driver]
    5. "AltDefaults"="1"
    6. "APILevel"="1"
    7. "ConnectionFunctions"="YYY"
    8. "CPTimeout"="60"
    9. "DriverODBCVer"="04.10"
    10. "FileUsage"="0"
    11. "SQLLevel"="0"
    12. "Driver"="d:\\SybaseASE_ODBC\\ODBC\\SYODASE.DLL"
    13. "Setup"="d:\\SybaseASE_ODBC\\ODBC\\SYODASES.DLL"
    14. "HelpRootDirectory"="d:\\SybaseASE_ODBC\\ODBC\\help"

    For 32bit win2008, please remove Wow6432Node from the above reg path.

    After poplute the above .reg,

    On 32bit win2008, you can use odbcad32 to configure ODBC directly.

    On 64bit win2008, just run c:\windows\syswow64\odbcad32 to configure ODBC DSN.

    Hope it can help.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 30, 2013 at 05:51 PM

    Hi Carl,

    If your MSSQL 2008 is 64 bit you need to use our 64 bit drivers. If your MSSQL 2008 is 32 bit you can use the 32 bit drivers.

    Sybase didn't offer 64 bit drivers until the later version 15.0.

    So please see what bit your MSSQL 2008 is.

    Then from there you can decide what to install.

    PC-Client 15.5 and SDK 15.5 and higher are certified for a Windows 2008 machine.

    When you install the PC-Client or SDK(Software Developers Kit for ASE) you need to make sure right click the autorun or setup.exe and run as administrator or the registery entries will not be put in due to the security on the Windows 2008 machine.

    Once you get the drivers installed you also need to make sure the MDA scripts on the ASE are updated to your most current version of the drivers. These MDA scripts for odbc and oledb/ado.net contain fixes and improved performance for connectivity to the new drivers and the applications that use these drivers.There was a great ISUG article written by Wayne Smith called 'Hitching a ride' from 2008 that explains this whole procedure step by step.

    Thanks,

    Dawn

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 06:17 PM

    Hi Carl,

    I don't know if you have been able to get the version 12.5.x client software installed yet.

    However, there is an old problem with the installer in version 12.5.x where when you clicked on the setup.exe in the Windows Explorer, it would show a command window for about 1/2 second and then dissapear. The workaround for that problem was to go into the directory from a command prompt. Then set this environment variable.

    set JAVA_COMPILER=NONE

    Then run setup.exe from the command prompt.

    That might resolve your problem.

    Thank you,

    Kevin

    Add a comment
    10|10000 characters needed characters exceeded

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.