[Help]Just 1 Simple Q regarding server name

Results 1 to 4 of 4
  1. #1
    Elite Member pranaydeep21 is offline
    Member +Rank
    Jul 2006 Join Date
    IndiaLocation
    174Posts

    [Help]Just 1 Simple Q regarding server name

    See
    i use The Word (local) everywhere in these odbc entries
    is there some harm in doing it ??
    will my server not run if i dont specify different name coz they dont work :(((

    I.E "Server"="(local)"

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Friend]
    "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
    "Server"="(local)"
    "Database"="FriendDB"
    "LastUser"="sa"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3RcvResult]
    "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
    "Server"="(local)"
    "Database"="A3ItemEvent"
    "LastUser"="sa"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3SerialList]
    "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
    "Server"="(local)"
    "Database"="A3ItemEvent"
    "LastUser"="sa"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\EventA3]
    "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
    "Server"="(local)"
    "Database"="ASD"
    "LastUser"="sa"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\FriendDB]
    "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
    "Server"="(local)"
    "Database"="HSDB"
    "LastUser"="sa"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\HSDB]
    "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
    "Server"="(local)"
    "Database"="HSDB"
    "LastUser"="sa"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LETTERDB]
    "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
    "Server"="(local)"
    "Database"="FriendDB"
    "LastUser"="sa"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalServer]
    "Description"=""
    "Server"="(local)"
    "Trusted_connection"=""
    "UseProcForPrepare"="Yes"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Login202]
    "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
    "Server"="(local)"
    "Database"="ASD"
    "LastUser"="sa"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\NEWASD]
    "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
    "Server"="(local)"
    "Database"="ASD"
    "LastUser"="sa"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
    "LocalServer"="SQL Server"
    "A3RcvResult"="SQL Server"
    "A3SerialList"="SQL Server"
    "FriendDB"="SQL Server"
    "NEWASD"="SQL Server"
    "Login202"="SQL Server"
    "LETTERDB"="SQL Server"
    "EventA3"="SQL Server"
    "A3Friend"="SQL Server"
    "HSDB"="SQL Server"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
    "DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources="(local)"


  2. #2
    Sorcerer Supreme dastorm is offline
    Member +Rank
    Jun 2006 Join Date
    INDIALocation
    481Posts

    Re: [Help]Just 1 Simple Q regarding server name

    "local" here is you SQL Server name... its like the Machine Name if u don't want to use local then u have to use the proper server name thr...

  3. #3
    Elite Member pranaydeep21 is offline
    Member +Rank
    Jul 2006 Join Date
    IndiaLocation
    174Posts

    Re: [Help]Just 1 Simple Q regarding server name

    just tell me is it ok to use it or not
    ne problem in using it?

  4. #4
    Grand Master iNs@nE is offline
    Grand MasterRank
    Jun 2006 Join Date
    HereLocation
    9,537Posts

    Re: [Help]Just 1 Simple Q regarding server name

    Quote Originally Posted by pranaydeep21 View Post
    just tell me is it ok to use it or not
    ne problem in using it?
    Use the server name found in the Service Manager. Replace local with it.



Advertisement