Skip to Content
avatar image
Former Member

Unable to connect to Sybase DB from PowerBuilder Version 7.0.3

We are trying to connect to Sybase DB from PowerBuilder Version 7.0.3. While trying to create a new DB profile it is giving the error "Unable to load the requested Database Interface. Please make sure both the interface and client software are installed properly".

We have tried re-installing the PowerBuider IDE which didnt help us.

PowerBuider is installed in Windows 7 environment. Also we are able to connect to Oracle database from the same installation.

NB: Upgrading the PowerBuilder version is not currently feasible as there are lot of dependencies related to it.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 26, 2013 at 06:47 PM

    Assuming that "Sybase DB" is Sybase ASE, it was unable to find pbsyc70.dll which should be in C:\Program Files (x86)\Sybase\Shared\PowerBuilder. If by "Sybase DB" you meant SQL Anywhere (Also known as ASA depending on the version) then it was unable to find pbodb70.dll.

    Make sure your ...Shared\PowerBuilder folder is in the system path and that the driver file mentioned above is in there. If not, follow Jerry's suggestion to re-install with Custom and make sure the driver is selected for install.

    In PB7, the list of installed drivers is located in the pb.ini file. There is a Vendors setting in the Database section. It should look something like this:

    Vendors=ODBC,MSS MS SQL Server 6.X,SYC Adaptive Server Enterprise,O84 Oracle 8.0.4/8.0.5,IN9 Informix V9.X,DIR Direct Connect Interface,JDB JDBC

    The first three characters (ODB, MSS, SYC, O84, IN9, DIR, JDB) correspond to position 3-5 of the driver file name.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi.

      As you said your database is ASE, so, except what Dale Shipman and Roland Smith mentioned about installing the open client, be aware that pb 7 is really old, and depending on the version of the client you will install you may experience some troubles.

      I'm using PB 9 to connect to an ASE 15.7 ESD#4 server. Powerbuilder 9 is to old (also) and cannot communicate using v. 15 and later versions of ASE clients (this happens because some library names changed). There is a batch file in the script folder under the \SYBASE\OCS-15_0 folder, and there is a copylib.bat wich fixes this issue. This worked for me, and I'm able to connect using PB 9 to ASE 15.x... Don't know what version of the open client you installed, and if this work with PB 7... I cannot test it as the lower version of PB that I use is 9. If you still have issues after open client installation, try to run that batch file and I hope it will work.

      Andreas.

  • avatar image
    Former Member
    Jun 26, 2013 at 05:17 PM

    Install the Sybase SYC drivers (also known as Open Client).

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Back when PowerBuilder 8.0 first came out I tried creating a PB 8 client to front-end a PB 7 DPB server and ran into a train-wreck load of issues.  Yes, I was able to get it to connect, but yikes, beyond that...

  • avatar image
    Former Member
    Jun 26, 2013 at 07:47 PM

    Hi.

    Can you be more specific when you say Sybase DB?

    Andreas.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 28, 2013 at 11:19 AM

    Hi All,

    Appreciate all the help and suggestions!!

    I was able to resolve the issue by adding the dll path to the Systems Path variable.

    The entry i made is :

    "C:\Program Files (x86)\Sybase\Shared\Open Client\dll"

    Providing the answer so that others to make use of it if in need.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 09, 2013 at 05:17 AM

    Intial issue is resolved and it is now taking a different turn. While trying to connect to the Sybase Database afte providing the required credentials ( SYC Sybase Adaptive Enterprise ), we are getting the error "Unable to Initialize Client Library Context".

    To Answer Andreas question about: I am not sure about the version of Open Client. How to identify it?

    Any help would be much appreciated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2015 at 11:06 AM

    Hi, I am not sure if you already found solution for this issue. I found this discussion today when I myself got the same problem and was lost. I was able to fix this issue after copying the 'NTWDBLIB.DLL' file to the sybase\shared\powerbuilder\ folder.

    regards,

    Arjun.

    Add comment
    10|10000 characters needed characters exceeded