Board index » delphi » Sql server, Stored Proc and Co

Sql server, Stored Proc and Co

Hi,
I have a problem:
With Sql Server Query Analyzer, when i do :
"Select Host_name()",
I get back the name of the Sql instance :"NSFKIE754Z" for example

When i do this with delphi, using a TAdoquery, i get "DEFAULT" as the name
of the sql instance ??

Does Anyone knows a solution ?

--
Pierre-Marie Petit
NST
19 rue Jean-Jacques Rousseau
59800 LILLE
Tel 03 20 06 63 94
Fax 03 20 31 38 80
p...@nst.fr

 

Re:Sql server, Stored Proc and Co


Try this:

SELECT HOST_NAME() AS hostname

HTH,

--
Michael Rodriguez
Compeat Restaurant Accounting Systems
http://www.compeat.com
m...@compeat.com

Quote
"Pierre-Marie Petit" <p...@nst.fr> wrote in message news:3b8a14bd_1@dnews...
> Hi,
> I have a problem:
> With Sql Server Query Analyzer, when i do :
> "Select Host_name()",
> I get back the name of the Sql instance :"NSFKIE754Z" for example

> When i do this with delphi, using a TAdoquery, i get "DEFAULT" as the name
> of the sql instance ??

> Does Anyone knows a solution ?

> --
> Pierre-Marie Petit
> NST
> 19 rue Jean-Jacques Rousseau
> 59800 LILLE
> Tel 03 20 06 63 94
> Fax 03 20 31 38 80
> p...@nst.fr

Other Threads