-
Apr 7th, 2006, 03:26 PM
#1
Thread Starter
Lively Member
[RESOLVED] .Net app name in SQL SERVER 2000
I have a question.....
I have created an app in vb.net which connect to sql server 2000, everything works well.
Running sql profiler I have found out that my app is recognised as ".Net ...".
How can I set in vb.net project the name of my application when I run SQL SERVER 2000 tools.
thank in advance.
-
Apr 8th, 2006, 04:43 AM
#2
Thread Starter
Lively Member
Re: .Net app name in SQL SERVER 2000
Do anyone how to show the application name, instead of default name:
.Net sql client
-
Apr 8th, 2006, 05:11 AM
#3
Re: .Net app name in SQL SERVER 2000
Add Application Name=foo to your ODBC connection string
e.g.
VB Code:
Dim conn as New SqlClient.SqlConnection("Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer;Application Name=foo")
conn.open
-
Apr 10th, 2006, 03:14 PM
#4
Thread Starter
Lively Member
Re: .Net app name in SQL SERVER 2000
Thank a lot,
I 'll try your suggestion...
thank a lot.....
-
Apr 13th, 2006, 02:59 PM
#5
Thread Starter
Lively Member
Re: .Net app name in SQL SERVER 2000
Thank
I added the parameters and everything is OK.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|