See @@SERVERNAME in BOL for additional info

SELECT 
	SERVERPROPERTY ('ServerName'),
	SERVERPROPERTY ('MachineName'),
	@@SERVERNAME

>If I use an ODBC connection setup in windows (under Start, Administrative Tools, DataSources (ODBC)) and can connect to a SQL database using this:
>
>

>lnConnHandle=SQLCONNECT(TRIM(THIS.Parent.FireDataSource.Value), TRIM(THIS.Parent.FireSQLId.Value),;
>	TRIM(THIS.Parent.FirePassword.Value))
>	
>IF lnConnHandle<=0
>	?? CHR(7)
>	MBox("SQL Test Connection Failed!")
>ELSE
>	SQLDISCONNECT(lnConnHandle)
>	MBOX("SQL Test Connection was Successful.",64)
>ENDIF
>

>
>lnConnHandle is 1 so it connects fine. However, I need to pull the actual SQL Server name. Is there a way to determine the actual SQL Server Name using the ODBC Connection or from the connection setup via the registry (last resort)?