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

Resolved Protocol drive error when connecting to DB

  1. How-to
0
Votes
Undo
  1. sharmistha sinha
    sharmistha sinha
  2. PowerBuilder
  3. Thursday, 15 August 2019 07:53 AM UTC

Hello,

When I try to connect to Sybase ASE database through my PB application I get the below error:- 

ct_connect(): network packet layer: internal net library error: Protocol driver call to parse connection information failed.  I can connect successfully to the database when I use the isql command.

Please help. The strange thing is that I can connect to the same DB using one PB exe. It does not work for other exe's.

 

Thanks in advance!

Sharmistha

  1. PowerBuilder
  2. PowerBuilder (Appeon)
Connecting to Microsoft Open XML SDK
Create EXE file using PBC without PBD or DLL files
Accepted Answer
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Thursday, 15 August 2019 12:17 PM UTC
  2. PowerBuilder
  3. # Permalink

I wonder whether path contains all required files for the DB connection.

If not, then having additional files in current folder, have AppPath defined in registry for the app, or have specific environment settings for specific app may help one app but other apps with different settings or in different folders would suffer.

HTH /Michael

Comment
sharmistha sinha
  1. sharmistha sinha
  2. Friday, 16 August 2019 03:43 AM UTC
Hello



I got this resolved by deploying app in C drive. Apparently my other drives cannot connect to DB
  1. Helpful
There are no comments made yet.
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 15 August 2019 14:30 PM UTC
  2. PowerBuilder
  3. # 1

Hi Sharmistha;

   That typically means that you may not have installed the ASE DB client drivers on your PC, the ASE driver you installed were of the wrong bitness or the protocol / settings that you chose in your SQLCA transaction object are incorrect for ASE.

Regards... Chris

Comment
sharmistha sinha
  1. sharmistha sinha
  2. Friday, 16 August 2019 01:28 AM UTC
I have installed the latest Sybase driver which serves for 32 bit and 64 bits both, so that should not be a problem.

Where can I check the protocol or settings for the SQLCA transaction please? I am new to powerbuilder.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 16 August 2019 02:32 AM UTC
// Example DB Connection Profile for ASE

SQLCA.DBMS = "ASE"

SQLCA.Database = "Chris"

SQLCA.LogPass =

SQLCA.ServerName = "Localhost"

SQLCA.LogId = "sa"

SQLCA.AutoCommit = False

SQLCA.DBParm = "Release='16'"



Search for SQLCA in your PB Application an see what values are being assigned.
  1. Helpful
sharmistha sinha
  1. sharmistha sinha
  2. Friday, 16 August 2019 03:43 AM UTC
Hello



I got this resolved by deploying app in C drive. Apparently my other drives cannot connect to DB
  1. Helpful
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.