cancel
Showing results for 
Search instead for 
Did you mean: 

DBMS sybase is not supported in your current installation

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

chris_keating
Advisor
Advisor

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.

Former Member
0 Kudos

Hello!

Thank you for the reply!

chris.keating,how do I change the transaction object DBMS property? I'm using pbole125.dll

This is my database connection syntax:

SQLCA.DBMS = "OLE DB"

SQLCA.LogPass = <********>

SQLCA.LogId = "mylogid"

SQLCA.AutoCommit = False SQLCA.DBParm="PROVIDER='SQLOLEDB',PROVIDERSTRING='database=dbname',DATASOURCE='datasourcename',PBCatalogOwner='dbo',INTEGRATEDSECURITY='sspi'"

chris_keating
Advisor
Advisor
0 Kudos

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



Answers (2)

Answers (2)

Former Member

Thank you for everything, chris.keating and chris.pollach.

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!

cpollach
Explorer

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

Former Member
0 Kudos

Hello!

Thank you for the reply!

So the best option here would be to install powerbuilder again?

chris.pollach cpollach, can I install the OLE DB client separately? Sorry, I'm new installing and setting everything up for powerbuilder.

cpollach
Explorer
0 Kudos

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"