Thank you Dennis, Could you tell me how to set up TCP/IP connection to MS
SQL.
As my code is stuck in dbLogin, which doesn't take any parameter, how do I
code to log in as another user?
Regards,
Jim
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Dennis Chuah
Sent: Monday, May 28, 2001 11:22 AM
To: Multiple recipients of list delphi
Subject: RE: [DUG]: MS SQL, IIS, Delphi
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"
---------------------------------------------------------------------------
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"