• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Could not open connection to SQL server error from Powerbuilder

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

Resolved Could not open connection to SQL server error from Powerbuilder

  1. New
  2. How-to
0
Votes
Undo
  1. Sailaja Sumanam
    Sailaja Sumanam
  2. PowerBuilder
  3. Monday, 16 September 2024 18:05 PM UTC

Hi,

 

I am trying to setup the Powerbuilder application in my local laptop and it is working fine from citrix environment. I am using powerbuilder 2022 R3 version and trying to connect to SQL server. I have the SQL native client 2012 installed on the laptop. The Database is allowing successful login from SSMS tool for Dev environment. However when trying to run the application from powerbuilder it is throwing an error - 'Could not open a connection to SQL server [53]. 

The DB profile is working fine from Powerbuilder. Please resolve this issue at the earliest.

 

Thanks,

Sailaja.

Printing on Azure VM is very slow compared to citr...
How can Multi-select in DDDWs be done?
Who is viewing this page
David Peace (Powersoft)
Georgios Papageorgiou
Responses (2)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 17 September 2024 13:55 PM UTC
  2. PowerBuilder
  3. # 1

Microsoft EOL'd SQL Server 2012 Native Client years ago. You should switch to the supported driver:

Microsoft OLE DB Driver 19 for SQL Server

https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16

In PowerBuilder use the MSOLEDBSQL interface.

SQLCA.DBMS = "MSOLEDBSQL SQL Server"
SQLCA.LogPass = "*****"
SQLCA.ServerName = "*****"
SQLCA.LogId = "*****"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='mydbname',Provider='MSOLEDBSQL19'"

 

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 16 September 2024 18:23 PM UTC
  2. PowerBuilder
  3. # 2

Hi Sailaja;

  If the PB IDE connects OK then have a look at the DB Profile that your using and it's settings in the preview tab. Make sure that your App is using the same settings to connect. The debugger is your friend.  ;-)

Regards ... Chris 

Comment
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Wednesday, 18 September 2024 15:26 PM UTC
Just before you connect to the database, put a break pint in the debugger. Then you can check all your database parameters are correct. Look at the values in sqlca or the transaction object that is connecting.

I suspect one is wrong, then you can track the source of that in your code and fix the problem.
  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.