Board index » delphi » How to read @@ServerName from MSSQL 7?

Frank Linde

Delphi Developer
Sat, 13 Sep 2003 18:14:57 GMT

How to read @@ServerName from MSSQL 7?

Hi,

how can one read @@-variables (for example: @@ServerName)
from MSSQL (using SQL7 and D5 Enterprise)?

I tried TQuery with "SELECT @@ServerName" but got no
results. The same SQL-Statement in MSSQL-Enterprise-Manager
works fine.

TIA
Frank

 
Joost van Rijswij

Delphi Developer
Sat, 13 Sep 2003 20:44:00 GMT

Re:How to read @@ServerName from MSSQL 7?


Hi Frank,

Works fine with me! Maybe inserting an AS statement helps:

  SQL.Add('SELECT @@ServerName AS MyServerName');
  Active := true;
  Showmessage(FieldByName('MyServerName').AsString);

Greets, Joost

Quote
"Frank Linde" <li...@lindedaten.de> wrote in message

news:3AC06821.75BE2D40@lindedaten.de...
Quote
> Hi,

> how can one read @@-variables (for example: @@ServerName)
> from MSSQL (using SQL7 and D5 Enterprise)?

> I tried TQuery with "SELECT @@ServerName" but got no
> results. The same SQL-Statement in MSSQL-Enterprise-Manager
> works fine.

> TIA
> Frank

John Fari

Delphi Developer
Sat, 13 Sep 2003 22:01:57 GMT

Re:How to read @@ServerName from MSSQL 7?


Try

SELECT CONVERT(VARCHAR(30),@@SERVERNAME) AS SERVER_NAME

I believe that SQL server 7 returns @@servername as unicode which the BDE
does not support - hence the conversion to a type the BDE does support.

HTH.

John.

Frank Lind

Delphi Developer
Sat, 13 Sep 2003 23:59:37 GMT

Re:How to read @@ServerName from MSSQL 7?


Hi Joost,

thanks, that was half the battle! As John suggested, MSSQL
needs an additional conversion.

Regards
Frank

Joost van Rijswijk schrieb:

Quote

> Hi Frank,

> Works fine with me! Maybe inserting an AS statement helps:

>   SQL.Add('SELECT @@ServerName AS MyServerName');
>   Active := true;
>   Showmessage(FieldByName('MyServerName').AsString);

> Greets, Joost

> "Frank Linde" <li...@lindedaten.de> wrote in message
> news:3AC06821.75BE2D40@lindedaten.de...
> > Hi,

> > how can one read @@-variables (for example: @@ServerName)
> > from MSSQL (using SQL7 and D5 Enterprise)?

> > I tried TQuery with "SELECT @@ServerName" but got no
> > results. The same SQL-Statement in MSSQL-Enterprise-Manager
> > works fine.

> > TIA
> > Frank

Frank Lind

Delphi Developer
Sun, 14 Sep 2003 00:00:51 GMT

Re:How to read @@ServerName from MSSQL 7?


Hi John,

that's it! Thanks for your answer!

Regards
Frank

John Faris schrieb:

Quote

> Try

> SELECT CONVERT(VARCHAR(30),@@SERVERNAME) AS SERVER_NAME

> I believe that SQL server 7 returns @@servername as unicode which the BDE
> does not support - hence the conversion to a type the BDE does support.

> HTH.

> John.

Other Threads

1. Getting ServerName for Application Server

2. Reading user database names from MSSQL server 7 and 2000

3. reading CSV file into MSSQL 7.0?

4. MSSQL and BDE error 10763 (Table is read only)

5. Get servername and protocol-type from BDE

6. What Servername should I set in my database alise

7. Delphi 5 DCOMConnection.servername property

8. How to get servername?

9. Bde servername field for interbase alias

10. DNS servername instead of UNC path in alias