1. Georgios Papageorgiou
  2. PowerBuilder
  3. Sunday, 16 December 2018 10:03 AM UTC

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
  1. Sunday, 16 December 2018 19:12 PM UTC
  2. PowerBuilder
  3. # 1

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
  1. Georgios Papageorgiou
  2. Sunday, 16 December 2018 19:31 PM UTC
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. Helpful
  1. Chris Pollach @Appeon
  2. Sunday, 16 December 2018 20:12 PM UTC
Nope ... that wasn't me. ?
  1. Helpful
  1. Chris Pollach @Appeon
  2. Sunday, 16 December 2018 20:26 PM UTC
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. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Sunday, 16 December 2018 16:12 PM UTC
  2. PowerBuilder
  3. # 2

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
  1. Georgios Papageorgiou
  2. Sunday, 16 December 2018 18:55 PM UTC
Thanks Chris



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

Regards

Georgios

  1. Helpful
  1. Chris Pollach @Appeon
  2. Sunday, 16 December 2018 19:06 PM UTC
Excellent news Georgious! ?
  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.
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.