Results 1 to 5 of 5

Thread: [RESOLVED] .Net app name in SQL SERVER 2000

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jul 2005
    Posts
    99

    Resolved [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.


  2. #2

    Thread Starter
    Lively Member
    Join Date
    Jul 2005
    Posts
    99

    Re: .Net app name in SQL SERVER 2000

    Do anyone how to show the application name, instead of default name:
    .Net sql client

  3. #3
    PowerPoster
    Join Date
    Jul 2002
    Location
    Dublin, Ireland
    Posts
    2,148

    Re: .Net app name in SQL SERVER 2000

    Add Application Name=foo to your ODBC connection string

    e.g.
    VB Code:
    1. Dim conn as New SqlClient.SqlConnection("Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer;Application Name=foo")
    2. conn.open

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Jul 2005
    Posts
    99

    Re: .Net app name in SQL SERVER 2000

    Thank a lot,

    I 'll try your suggestion...

    thank a lot.....


  5. #5

    Thread Starter
    Lively Member
    Join Date
    Jul 2005
    Posts
    99

    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
  •  



Click Here to Expand Forum to Full Width