Community Forums
Results 1 to 3 of 3

Thread: Using SQLDMO in DevStudio, how do I....

  1. #1
    sgrebey Guest

    Using SQLDMO in DevStudio, how do I....

    ...get the name of the local machine? Sorry, kind of new to SQL Server and DevStudio. Trying to connect to use a named Instance, in my case it is:

    strServer = "VBDev\\MedWare";

    but how do I get the VBDev part (mahcine name)? I tried:

    strServer = "(LOCAL)\\MedWare"; but it didn't like that.

  2. #2
    sgrebey Guest
    In case anybody is interested....

    GetEnvVar("COMPUTERNAME",strCompName);

  3. #3
    Join Date
    Oct 2001
    Location
    Home is Las Vegas, NV - Work is where they need me to be!
    Posts
    1,192
    There is also a property named ComputerName that can be retrieved via MSIGetProperty().
    Luiz Quintela
    Information Technology Consultant


    www.luizquintela.com
    www.technosuppcenter.com
    www.technevada.com


    "Political correctness is just tyranny with manners. I wish for you the courage to be unpopular. Popularity is history's pocket change. Courage is history's true currency." (Charlton Heston)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •