Skip to Content
avatar image
Former Member

DBMS sybase is not supported in your current installation

Hello!

I looked everywhere for this error and didnt find anything, could someone help me with it?

Every time I try to run my powerbuilder application, I get this error "DBMS Sybase is not supported in your current installation". This is a Sql Error, but my database connection is all set with SQLOLEDB and I get a successful msg when I test it in the powerbuilder DB Profile.

Thank you!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 02 at 08:19 PM

    Assuming this is the exact error, the cause is that the transaction object DBMS property is set as sybase. There is no PB database driver of that name. The DBMS property must be set with the first three characters of the driver OLE if the connection is to use an OLE DB based connection.

    If you get this error with a valid DBMS property value, it is caused by

    • missing or not found PB database driver i.e, pbole126.dll for the PB12.6 OLE DB driver
    • missing or not found DBMS OLE DB client software

    As a side note, there are many Sybase DBMS options - ASE, SQL Anywhere, IQ, and Advantage. If you have problems with the client software, you will need to be more specific about the DBMS being used.

    Add comment
    10|10000 characters needed characters exceeded

    • The error that you posted cannot be based on this transaction object. The error replaces the %1 with the value contained in the transaction object DBMS property (stripped of 'TRACE ' if specified).

      DBMS %1 is not supported in your current installation

      The error you reported is

      DBMS Sybase is not supported in your current installation

      That means the DBMS property for the failing connection is 'Sybase' not 'OLE DB'.

      Also note that the SQLOLEDB provider is for MSS. I would search your code for DBMS and debug/verify the value. It might be that the is a custom transaction object being used.

      I am going to recommend that you add TRACE to the DBMS line and post the generated log when this error is encountered. Here is the change:

      SQLCA.DBMS = "TRACE OLE DB"

      This log will include the error DBMS %1 is not supported in your current installation if it is encountered. Here is an example:

      /*---------------------------------------------------*/

      /* 5/4/2018 09:51 */

      /*---------------------------------------------------*/

      DBMS SYBASE is not supported in your current installation



  • May 02 at 05:42 PM

    Hi Erika;

    That probably means that one of the following is missing ...

    1. The PowerBuilder OLEDB DB driver did not get distributed with your App's EXE (PBOLEnnn.DLL - where nnn = your PB release number)
    2. The OLE DB client for the Sybase DBMS was not installed on your App's EXE deployed PC.

    HTH

    Regards ... Chris

    Add comment
    10|10000 characters needed characters exceeded

    • No Need ... just make sure that you deploy the proper components (aka run-time) with your application EXE.

      Also ... make sure that your App is setting the proper DB driver ... for example:

      • SQLCA.DBMS = "OLE"

      Note: Both ASE and PB support a much faster native driver. You can use that mechanism, as follows:

      • SQLCA.DBMS = "ASE"
  • avatar image
    Former Member
    May 07 at 12:46 PM

    Thank you for everything, Chris Keating and Former Member.

    The problem was that the application uses the INI file to set the database and without this file the connection options are established during runtime, hardcoded. That's why I was getting the DBMS Sybase instead of the OLE DB I had configured.

    Thank you!

    Add comment
    10|10000 characters needed characters exceeded