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

"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?
>
>