1. sharmistha sinha
  2. PowerBuilder
  3. Monday, 05 August 2019

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

sharmistha sinha Accepted Answer Pending Moderation
1
Votes
Undo

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.
  1. Wednesday, 7 August 2019
  2. PowerBuilder
  3. # 1
sharmistha sinha Accepted Answer Pending Moderation
0
Votes
Undo

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
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. Chris Pollach
  2. Wednesday, 7 August 2019
I have installed the Sybase client Sybase SDK SP140 X64 15.7 001. This is client available for Sybase.
  1. sharmistha sinha
  2. Wednesday, 7 August 2019
There are no comments made yet.
  1. Wednesday, 7 August 2019
  2. PowerBuilder
  3. # 2
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Tuesday, 6 August 2019
  2. PowerBuilder
  3. # 3
sharmistha sinha Accepted Answer Pending Moderation
0
Votes
Undo
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
Sorry but where can I add SQLCA.DBMS = "SYC" ?

  1. sharmistha sinha
  2. Wednesday, 7 August 2019
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. Chris Pollach
  2. Wednesday, 7 August 2019
Hi, I could resolve the issue by adding my server entry in SQL.INI file. Thx for helping
  1. sharmistha sinha
  2. Thursday, 8 August 2019
There are no comments made yet.
  1. Tuesday, 6 August 2019
  2. PowerBuilder
  3. # 4
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

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
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. Chris Pollach
  2. Tuesday, 6 August 2019
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. Roland Smith
  2. Tuesday, 6 August 2019
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. Chris Pollach
  2. Tuesday, 6 August 2019
There are no comments made yet.
  1. Monday, 5 August 2019
  2. PowerBuilder
  3. # 5
  • Page :
  • 1


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