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