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 

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


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