roh_8_it_3
Registered User.
- Local time
- Today, 03:16
- Joined
- Feb 15, 2005
- Messages
- 79
Hello All,
I have an adp project as a front end and sql server 2000 as the backend.I have several ASP.Net apps talking to sql server as well.
I have included the Application Name in connection string on the .Net apps and when I execute the sp_who2 stored procedure ,it correctly shows me the application name in the Program Name column.I want to do the same from the adp application so i can track the connections.
Here is what I did in the adp project.I removed the connection under the File --> connection and I am making connection like this when a user is logging as the first time -
strconn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=myuser;Pwd=mypwd;Initial Catalog=mydb;Data Source=myserver;Application Name=myapp"
If Application.CurrentProject.BaseConnectionString = "" Then
Application.CurrentProject.OpenConnection strconn
end if
This works well and opens the connection to the sql server.But when I execute the sp_who2 ,it shows the progam name as Microsoft Access 2003 and not as myapp.
Any help on this why this connection is not showing the app name that I provided in the connection string?
Thanks
I have an adp project as a front end and sql server 2000 as the backend.I have several ASP.Net apps talking to sql server as well.
I have included the Application Name in connection string on the .Net apps and when I execute the sp_who2 stored procedure ,it correctly shows me the application name in the Program Name column.I want to do the same from the adp application so i can track the connections.
Here is what I did in the adp project.I removed the connection under the File --> connection and I am making connection like this when a user is logging as the first time -
strconn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=myuser;Pwd=mypwd;Initial Catalog=mydb;Data Source=myserver;Application Name=myapp"
If Application.CurrentProject.BaseConnectionString = "" Then
Application.CurrentProject.OpenConnection strconn
end if
This works well and opens the connection to the sql server.But when I execute the sp_who2 ,it shows the progam name as Microsoft Access 2003 and not as myapp.
Any help on this why this connection is not showing the app name that I provided in the connection string?
Thanks