1. Georgios Papageorgiou
  2. PowerBuilder
  3. Sunday, 16 December 2018

Hi Powersphere 

 

When i connect to SQL Server 2017 i'm not able to set the Application Name.

Currently the "sp_who2" says ".Net SqlClient Data Provider" 

 

I tried to set DBParm to 

"Application Name=Client" / "App='Client'" / "ApplicationName='Client'  - etc but *no Success*

I'm running on PB2017R2 - I know there were "SQL SERVER 2017" support in 2017R3 - but had the same issues on SQL Server 2016....

I also tried to find the specific enhancements in SQL2017 suppoort - but couldn't find anything

 

Any suggestions ? 

Thanks

Georgios 

Georgios Papageorgiou Accepted Answer Pending Moderation
0
Votes
Undo

Chris

No - didnt work --
it says ".Net SqlClient Data Provider"

My dbparm lookes like this
DBParm = "Namespace='System.Data.SqlClient',DataSource='" + ServerName + "',Database='" + database + "',DelimitIdentifier='No',TrimSpaces=1,CommitOnDisconnect='No',RecheckRows=1,AppName='Client'"


So it's not resolved :)
Regards
Georgios

 

Comment
ADO does support them - Just not though PB though .. or at least sems to :(



Thought you said it would be a good idea to leave native :)

Georgios

  1. Georgios Papageorgiou
  2. Sunday, 16 December 2018
Nope ... that wasn't me. ?
  1. Chris Pollach
  2. Sunday, 16 December 2018
I believe that the ApplicationName='xxx' is supported in OLEDB (but not "host"). For example:

DBParm = "'Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=MyDb;Application Name=Client;Data Source=DS1'"

  1. Chris Pollach
  2. Sunday, 16 December 2018
There are no comments made yet.
  1. Sunday, 16 December 2018
  2. PowerBuilder
  3. # 1
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi 

  There are two parameters that you can pass to SS or ASE for identication purposes ...

SQLCA.DBParm="Host='Jane',AppName='Sales'" 

HTH

Regards ... Chris
Comment
Thanks Chris



Thought I tried that combi --- but yes - it works - just like the old NativeClient days :)

Regards

Georgios

  1. Georgios Papageorgiou
  2. Sunday, 16 December 2018
Excellent news Georgious! ?
  1. Chris Pollach
  2. Sunday, 16 December 2018
There are no comments made yet.
  1. Sunday, 16 December 2018
  2. PowerBuilder
  3. # 2
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies. Learn More