ADO.NET - not able to set Application NAme

View Replies (2)

Resolved ADO.NET - not able to set Application NAme

How-to

Votes

Undo

Georgios Papageorgiou
PowerBuilder
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

Responses (2)

Georgios Papageorgiou Accepted Answer Pending Moderation

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

Load more comments

Georgios Papageorgiou
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

Helpful 0

Chris Pollach @Appeon
Sunday, 16 December 2018 20:12 PM UTC

Nope ... that wasn't me. ?

Helpful 0

Chris Pollach @Appeon
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'"

Helpful 0

There are no comments made yet.

Chris Pollach @Appeon Accepted Answer Pending Moderation

Sunday, 16 December 2018 16:12 PM UTC
PowerBuilder
# 2

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

Georgios Papageorgiou
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

Helpful 0

Chris Pollach @Appeon
Sunday, 16 December 2018 19:06 PM UTC

Excellent news Georgious! ?

Helpful 0

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.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

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.