Wow, thanks Sergey! That works perfectly. :o)



>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)?