Delphi 2010 Web Service using DBExpress and MS SQL Server 2005 DB ?

Delphi 2010, dbExpress, and MS SQL Server 2005 DB

Ok,

I am trying to make a connection to a MS SQL 2005 DB using Delphi 2010 & DBExpress.

If I create a standard delphi application executable and hard code my connection (IT WORKS!):

I can run this from my web server vitual directory C:\inetpub\wwwroot\shanedev\

here is the code (again, this is not a web service, just a standard delphi app)
procedure TForm1.Button1Click(Sender: TObject);
var
 Conn: TSQLConnection;
begin
 Conn:= TSQLConnection.Create(nil);
 Conn.ConnectionName:= 'VPUCDS_VPN_SE01';
 Conn.LoadParamsOnConnect := True;
 Conn.LoginPrompt:=True;
 try
   Conn.Connected:= True;
   if Conn.Connected then
   ShowMessage('Connected!')
   else
   ShowMessage('NOT Connected!')
 finally
  Conn.Free;
 end;
end;

NOTE: All the ini files, and DLLs reside in the same folder as my executable

and yes, I have DBXMsSQL & MidasLib in the uses clause

again, it works if its not a web service!



However, if i then move the code over to a Web serices CGI module:

function TTest.ConnectToDB: Boolean;stdcall;
var
 Conn: TSQLConnection;
begin
 Conn:= TSQLConnection.Create(nil);
 Conn.ConnectionName:= 'VPUCDS_VPN_SE01';  
 Conn.LoadParamsOnConnect := True;
 Conn.LoginPrompt:=True;
 try
   Conn.Connected:= True;
   result:=  Conn.Connected;
 finally
  Conn.Free;
 end;
end;

It does NOT work! I get an error message "Inavalid argument: VPUCDS_VPN_SE01".


Why will it work from standard app executable and not web services CGI executable???????

Thanks

Shane