Conference abbott::visual_basic

2488.0. "Default Server Name of DSN?" by DELNI::DUNCAN () Tue Feb 04 1997 17:42

    
    Does anyone have a VB example that, after making an RDO connection to
    an ODBC DSN, is able to determine the Server Name associated with that
    DSN?
    
    The rdoConnections.Connect property returns the DSN, ID, PW, & DB
    but it leaves out what I need - the Server Name. I want to use this
    name to pass it as a parameter to the Connect method of the SQL Server
    object (of the SQL OLE Library) so I can get username and password of
    the established NT/SQL "trusted" connection (ie, one where the user did 
    not have to enter a username and password).
    
    Thanks.
    
    - Phil
    

    
    in case it was unclear, the RDO Connect property, for a trusted
    connection, does not return the Username & Password, hence my needing
    to use SQL Object's Connect method to access that info (but the latter
    Connect method requires the Server Name string).
    

    
    For anyone who might need to know in the future, I figured out a way.
    
    Create an RDO resultset with this SQL:
    		
    		"Select @@SERVERNAME