Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (5)

Resolved Could not connect to sybase db from powerbuilder

  1. How-to
0
Votes
Undo
  1. sharmistha sinha
    sharmistha sinha
  2. PowerBuilder
  3. Monday, 5 August 2019 06:47 AM UTC

Hello I am trying to migrate powerbuilder 12.6 to powerbuilder 2017. But I get some problem while connectiong to database. I use SYBASE DB.  The error which I get id "Error loading client library DLLs. Unable to connect to server" Can you please help me with this? I am not sur ehow to load DLLs. Am I missing something?

 

Thx a lot!

Sharmistha

  1. Database Driver
  2. PowerBuilder (Appeon)
Set TreeView image background for predefined image...
Opening a centered Response Window - it flickers
Responses (5)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 5 August 2019 12:59 PM UTC
  2. PowerBuilder
  3. # 1

It should work exactly like 12.5 does. You don't have to 'load dlls', it is handled by the ASE or SYC database driver.

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 6 August 2019 03:26 AM UTC
Hi Sharmistha;

Your App should be using PBASE170.dll as your application should have the setting ...

SQLCA.DBMS = "ASE"

(Unless you have a very old ASE version)

Regards ... Chris
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Tuesday, 6 August 2019 13:27 PM UTC
PBODB170.DLL is for ODBC. Position 3-5 of the DLL name matches the first 3 of sqlca.DBMS.



When you say 'SYBASE DB', are you talking about Sybase ASE or SQL Anywhere? They are two completely different things.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 6 August 2019 13:51 PM UTC
Hi Roland;

Good point. Also the version of the DBMS can make a difference as well. We need to know more DB details.

Regards ... Chris
  1. Helpful
There are no comments made yet.
sharmistha sinha
sharmistha sinha Accepted Answer Pending Moderation
  1. Tuesday, 6 August 2019 10:07 AM UTC
  2. PowerBuilder
  3. # 2
Thanks a lot for replying. I can see PBASE170.DLL in my powerbuilder folder. I also installed Sybase SDK SP140 X64 15.7 001 on my machine. Now I get the error ct_connect(): directory service layer: internal directory control layer error: Requested server name not found. What should be the server name here?
Do I need to add my server name somewhere to connect successfully?
Comment
Load more comments
sharmistha sinha
  1. sharmistha sinha
  2. Wednesday, 7 August 2019 03:15 AM UTC
Sorry but where can I add SQLCA.DBMS = "SYC" ?

  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 7 August 2019 13:18 PM UTC
Use the "Search" feature in the IDE and search for the keyword ".DBMS". Your application may or may not use the class name "sqlca".
  1. Helpful
sharmistha sinha
  1. sharmistha sinha
  2. Thursday, 8 August 2019 01:51 AM UTC
Hi, I could resolve the issue by adding my server entry in SQL.INI file. Thx for helping
  1. Helpful
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 6 August 2019 14:00 PM UTC
  2. PowerBuilder
  3. # 3

Sharmistha,

Please clarify what database you are using. All you told us was 'SYBASE DB' which could be several completely different things. Is it Sybase ASE or SQL Anywhere? What version?

Roland

Comment
There are no comments made yet.
sharmistha sinha
sharmistha sinha Accepted Answer Pending Moderation
  1. Wednesday, 7 August 2019 02:03 AM UTC
  2. PowerBuilder
  3. # 4

Hi,

I tried to compile/deploy my powerbuilder project which written in pervious version 12.5 but over PowerBuilder 2017 (kind of migration), it prompt me the database connection before I can compile/deploy.

Each time, when I try to connect my Sybase database via Powerbuilder 2017, I have the following error

ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.

If I am using Sybase client to connect the same db, there is no issue.

So, I suspect there are issues on powerbuilder 2017 database driver. Can you suggest how to diagnose it? 

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 7 August 2019 02:34 AM UTC
The Ct_Connect error typically means that you did not install the Sybase ASE client (what PB App's want to connect to). Remember that the IDE & Apps require the 32 bit ASE client. These DB client installs come with your ASE installation. Check with your DBA.
  1. Helpful
sharmistha sinha
  1. sharmistha sinha
  2. Wednesday, 7 August 2019 06:49 AM UTC
I have installed the Sybase client Sybase SDK SP140 X64 15.7 001. This is client available for Sybase.
  1. Helpful
There are no comments made yet.
sharmistha sinha
sharmistha sinha Accepted Answer Pending Moderation
  1. Wednesday, 7 August 2019 07:33 AM UTC
  2. PowerBuilder
  3. # 5

Hello,

 

I could resolve the issue by adding my server entry in SQL.INI file. Thx for helping

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.