Application Name

Hi
Does anyone know how the ODBC driver gets the application name that is
displayed by the SQL Server profiler? Our application does not explicitly
pass it in with the connection string but we are seeing a name under the
ApplicationName column in SQL Server profiler.
Many thanks
Shakti
I'm just curious. Does the application name that is generated make sense? I
know that if I don't set one in ADO.Net, the app name is something like ".net
client." If I need the information to say something that I really need to
set the AppName
Russel Loski, MCSD.Net
"Johnny" wrote:

> Hi
> Does anyone know how the ODBC driver gets the application name that is
> displayed by the SQL Server profiler? Our application does not explicitly
> pass it in with the connection string but we are seeing a name under the
> ApplicationName column in SQL Server profiler.
> Many thanks
> Shakti
>
>
|||Hi,
there are several way, one would be to tweak the connection string with
the appName parameter.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Agree that your suggestion is the way to set the application name but if it
is not set by the application where does it get the name from? I can see
the program name in the sysprocesses table but if the application is not
setting it explicitly where does it come from?
Thanks
Shakti
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1169569609.022799.219340@.l53g2000cwa.googlegr oups.com...
> Hi,
> there are several way, one would be to tweak the connection string with
> the appName parameter.
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
|||Still from the application side. It's a parameter for the
connection string, property for the connection, different
ways depending on the application.Not all connections from
applications will supply them.
-Sue
On Tue, 23 Jan 2007 20:39:32 -0000, "johnny"
<prem14@.acm.org> wrote:

>Agree that your suggestion is the way to set the application name but if it
>is not set by the application where does it get the name from? I can see
>the program name in the sysprocesses table but if the application is not
>setting it explicitly where does it come from?
>Thanks
>Shakti
>"Jens" <Jens@.sqlserver2005.de> wrote in message
>news:1169569609.022799.219340@.l53g2000cwa.googleg roups.com...
>
|||We are going round in circles! Application is neither supplying the
application name parameter nor setting any connection property whatsoever.
So, where does ODBC driver / sql server / sysprocesses get the program name
from? It appears to have our company name!
Cheers
Shakti
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:m9hdr2h8qehp2c1q96jibubcmd44s900ht@.4ax.com...
> Still from the application side. It's a parameter for the
> connection string, property for the connection, different
> ways depending on the application.Not all connections from
> applications will supply them.
> -Sue
> On Tue, 23 Jan 2007 20:39:32 -0000, "johnny"
> <prem14@.acm.org> wrote:
>
|||Client would have been the better word to use rather than
application. It depends on what application.you are using.
And driver.
-Sue
On Wed, 24 Jan 2007 11:30:36 -0000, "Johnny"
<prem14@.acm.org> wrote:

>We are going round in circles! Application is neither supplying the
>application name parameter nor setting any connection property whatsoever.
>So, where does ODBC driver / sql server / sysprocesses get the program name
>from? It appears to have our company name!
>Cheers
>Shakti
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:m9hdr2h8qehp2c1q96jibubcmd44s900ht@.4ax.com.. .
>