Jim,
I think your problem is security - when running under IIS, your Active-X
component effectively runs under the guest user's privileges. This user may
not be able to access the database, especially if you are using named pipes.
Try setting up the connection as TCP/IP (use the client config tool). The
other alternative is to code your Active-X component to log in as another
user.
Regards,
Dennis.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 25 May 2001 16:29
> To: Multiple recipients of list delphi
> Subject: [DUG]: MS SQL, IIS, Delphi
>
>
> Hi,
>
> Does anyone have trouble to talk to MS SQL Server inside IIS?
>
> I've got this working in Windows program.
>
> Cheers,
>
>
> Jim
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"