• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Connection error executing PB2017 against sql server 2016

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

Resolved Connection error executing PB2017 against sql server 2016

  1. How-to
0
Votes
Undo
  1. Dede Koueviakoe
    Dede Koueviakoe
  2. PowerBuilder
  3. Friday, 22 November 2019 10:41 AM UTC

hello,

with these parameters in my configuration file, I get "login failed for user ..." and sqlstate = 28000 error

 

DBMS = "SNC SQL Native Client(OLE DB)"
ServerName = "server\instance,1522"
LogId = "adm"
LogPass = mst
DBParm = "Provider='SQLNCLI11',Database='REC1',DelimitIdentifier=1,StaticBind=0,DisableBind=0,NCharBind=0"

 

with the same user and password, I can connect to the database from sql server management studio.

can anyone help me out ?

thanks in advance

Account already logged in error
PSR to PDF conversion using FOP (PB12.6)
Responses (2)
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Friday, 22 November 2019 13:33 PM UTC
  2. PowerBuilder
  3. # 1
  1. Can your PB IDE connect to the database using a DB Profile having EXACT same configuration as your script?
  2. Can you DEBUG - stop at breakpoint IMMEDIATELY after your CONNECT USING SQLCA; -- then compare SQLCA properties to your PB profile for ANY details however minute?
  3. Can you share EXACT error message present in SQLCA.SQLErrText, SQLCA.SQLDBCode, and SQLCA.SQLCode at same breakpoint?
    (leave out any confidential details like user-ID/password by replacing them with *** or similar)

Your app may need other connection config that your IDE but as a start try to get identical config working - then adjust.

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 22 November 2019 15:57 PM UTC
32 vs 64 bit?
  1. Helpful
There are no comments made yet.
Dede Koueviakoe
Dede Koueviakoe Accepted Answer Pending Moderation
  1. Tuesday, 26 November 2019 15:26 PM UTC
  2. PowerBuilder
  3. # 2

Hi all,

there was a ; at the end of the password and PB did not like it ...

it's all settled now.

thanks again

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.