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 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Sunday, 16 December 2018 16:12 PM UTC
  2. PowerBuilder
  3. # 1

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

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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.