Appication name in SQL Server connection string

[Ray at]

Hi group,

Does anyone know how I can pass an application name in my connection string
and have it be recognized by SQL Server? I have this string:

Driver={SQL
Server};Server=TheServerName;Database=TheDatabase; Uid=TheUsername;Pwd=ThePas
sword;Application Name=RaysApp;

When I execute queries using this connection string in my ASP pages and
watch in Profiler (thanks Bob), the application name still comes through as
"Microsoft(R) Windows(R) 2000 Operating System" as opposed to "RaysApp."

IIS server is W2K SP3
SQL Server is W2K SP3, SQL 2000 Standard SP3a

Thanks,

Ray at work

[Bob Barrows]

Ray at <%=sLocation%> wrote:

> Hi group,
>
> Does anyone know how I can pass an application name in my connection
> string and have it be recognized by SQL Server? I have this string:
>
> Driver={SQL
>

Server};Server=TheServerName;Database=TheDatabase; Uid=TheUsername;Pwd=ThePas

> sword;Application Name=RaysApp;
>
> When I execute queries using this connection string in my ASP pages
> and watch in Profiler (thanks Bob), the application name still comes
> through as "Microsoft(R) Windows(R) 2000 Operating System" as opposed
> to "RaysApp."
>
> IIS server is W2K SP3
> SQL Server is W2K SP3, SQL 2000 Standard SP3a
>
> Thanks,
>
> Ray at work

It usually works for me. Why use odbc rather than sqloledb?

[Ray at]

Whoops. Because I copied the wrong string. I corrected it, and now all is
fine. Thanks Bob.

Ray at work

"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:O5sFJfeVDHA.3232@tk2msftngp13.phx.gbl...

> Ray at <%=sLocation%> wrote:

> > Hi group,
> >
> > Does anyone know how I can pass an application name in my connection
> > string and have it be recognized by SQL Server? I have this string:
> >
> > Driver={SQL
> >

>

Server};Server=TheServerName;Database=TheDatabase; Uid=TheUsername;Pwd=ThePas

> > sword;Application Name=RaysApp;
> >
> > When I execute queries using this connection string in my ASP pages
> > and watch in Profiler (thanks Bob), the application name still comes
> > through as "Microsoft(R) Windows(R) 2000 Operating System" as opposed
> > to "RaysApp."
> >
> > IIS server is W2K SP3
> > SQL Server is W2K SP3, SQL 2000 Standard SP3a
> >
> > Thanks,
> >
> > Ray at work

> It usually works for me. Why use odbc rather than sqloledb?
>
>