Visual Basic-find server name

• sgordon

  Old Hand

  Points: 359

  More actions

  September 18, 2002 at 2:31 pm

  #64142

  Is there a way to find the server name that you are connecting to using an ODBC connection in Visual Basic? I would like to display the server the user is on in the "help" section.

  Thanks!

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 18, 2002 at 2:40 pm

  #436804

  You could perhaps parse out the DSN, but even then it might be an alias. Try @@servername or look at serverproperty.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• jgama

  Mr or Mrs. 500

  Points: 509

  More actions

  December 19, 2002 at 8:34 pm

  #444900

  If you use SQLDMO you can find all the SQL server names and info.