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)?
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"