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