• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Named pipes provider- could not open a connection to sql - connection string issue

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

Resolved Named pipes provider- could not open a connection to sql - connection string issue

  1. Issue
0
Votes
Undo
  1. Prasad Neelapala
    Prasad Neelapala
  2. PowerBuilder
  3. Wednesday, 1 March 2023 08:41 AM UTC 
App.ini

[PRCLPRODMSSQL1_DS]
;Autocommit defaults to false if no entry here - can be overridden in users registry
Name=ProductionMSSQL
AutoCommit=true
DBMS = "SNC SQL Native Client(OLE DB)"
DBPARM = "DataBase='PrcDb',PROVIDER='SQLNCLI11'"
ServerName = "mss-em-0333-aol.eur.nsroot.net,2431 "
LogId = "prcmsprd"
LogPass = "*******"
Lock="RR"

*Reproduce Steps:
We are SNC Native Client for database 

Remarks:
When we try to run the application it is giving the below error. Please resolve this for us
Attachments (1)
Named Pipe error.png Named Pipe error.png
On devs machines the dll instantiates - on busines...
Database connection string using SQL server 2019
Responses (2)
Prasad Neelapala
Prasad Neelapala Accepted Answer Pending Moderation
  1. Wednesday, 8 March 2023 12:34 PM UTC
  2. PowerBuilder
  3. # 1

Hi Chris , it would be appreciated if you could help me setup the database connection for this i am new to this and dont know which providers to use and how to use proper server name

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 8 March 2023 15:40 PM UTC
Hi Prasad;

Unfortunately, there can be many environmental, network and of course SS configuration settings that can affect your choice of a DB Client to use, it's settings and options. Not only for the best connectivity but also performance and sometimes DML functionality as well. So again - IMHO - the best advise I can give you (for any DBMS vendor) is to contact your organizations DBA team for their advice on the best avenue to proceed DBMS connectivity wise.

Note though for Microsoft SQL Server, the PB drivers will want to connect to SS via TCP/IP. So please make sure that your DBA team has configured SS to utilize TCP/IP connectivity. HTH

Regards ... Chris
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 1 March 2023 13:21 PM UTC
  2. PowerBuilder
  3. # 2

Hi Prasad;

   This error indicates a probable SS Server or SS Client configuration issue.

FYI: https://tableplus.com/blog/2019/09/sqlstate-08001-connection-failed.html

Regards ... Chris 

Comment
Prasad Neelapala
  1. Prasad Neelapala
  2. Wednesday, 1 March 2023 14:08 PM UTC
We do not have access to config manager is there any other way
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 1 March 2023 15:25 PM UTC
FWIW: I would then recommend contacting your DBA team for help in resolving this SS error..
  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.