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

Pierre-Marie Petit

Delphi Developer
Fri, 13 Feb 2004 17:38:35 GMT

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

 
Michael Rodrigue

Delphi Developer
Sat, 14 Feb 2004 06:52:53 GMT

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

1. SQL Server 6 Stored Proc problem

2. MS SQL Server stored proc parameter problem

3. Delphi / SQL Server / Stored Proc

4. Retrieving stored proc info from SQL Server

5. SQL Server Stored Proc Null Date

6. ADO/SQL Server 7/Stored Proc

7. SQL Server 7.0, ADO-Command Parameters not Accessible (Stored Proc)

8. associate a sql 2000 server stored proc with a variable

9. SQL Server 7.0 Stored Proc and Joins

10. HELP!!Sql server 7 Stored Proc