Hi Bevan,

Thanks for your reply.

Actully I am not that far yet. The stuck point is dbLogin which doesn't take
any parameter.

I am using API to access MS SQL directly, not DBE or ODBC is required.


Jim

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of [EMAIL PROTECTED]
Sent: Monday, May 28, 2001 10:04 AM
To: [EMAIL PROTECTED]
Subject: Re: [DUG]: MS SQL, IIS and Delphi API



Hi Jim,

I had a similar problem recently with a new Win2k Server and IIS
installation.  The CGI application worked fine on NT4 (Workstation and
Server) with IIS4, but I had repeated problems on Win2k and IIS5.

Anyway, there were a number of issues that cropped up.  First of all, we
had to use regedt32 to ensure that Everyone had full access to the ODBC
subkeys of the Registry - oh, yeah, we were using BDE and ODBC to access
MS SQL on another machine.

Secondly, when that didn't solve the problem (as it had done for Win
NT4), I ended up manually changing  the password for the IUSR_xxx
account and then changing that setting in IIS as well.  This appears to
have fixed the problem.  I don't know if it made any difference but I
also logged in as IUSR_xxx just to check that the new password was
working and that the CGI app was running when logged in as that user.

I hope that helps.

Regards,

Bevan


Jim Zheng wrote:
>
> I've got the header files now. Thank you Nello.
>
> BUT, I still have trouble with MS SQL and IIS. I don't know whether I miss
> something on system settings, like security problem. This is first time I
am
> working with MS SQL.
>
> My problem is the following. I am using API in Delphi to talk to MS SQL
>  located on my local Windows2000Sever machine), works well and fast in
> Windows application. As long as I turn this into a ActiveX component,
dnInit
> is passed, but stuck on dbLogin. It won't allow me to log into SQL I
guess.
> I am new at MS SQL. Is there any thing needed to do before IIS can access
MS
> SQL or  this is totally other issue behind the scene?
>
> Any thoughts are welcome.
>
> Regards,
>
> Jim
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Nello Sestini
> Sent: Friday, May 25, 2001 08:26 PM
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: SQLDB.H and SQLFRONT.H
>
> they're available from the MS website in the (free) PlatformSDK.
> http://www.microsoft.com/msdownload/platformsdk/psdkwebinst.asp
>
> I'm not sure if the ones I have are the latest.   ISTR the PSDK
> I have installed is the April 2000 release.
>
> Please email me directly if you want me to send you the versions
> of these 2 files that I have.
>
> -ns
>
> ----- Original Message -----
> From: "Jim Zheng" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
> Sent: Friday, May 25, 2001 10:39 AM
> Subject: [DUG]: SQLDB.H and SQLFRONT.H
>
> > Hi,
> >
> > Can anyone online here send me a copy of SQLDB.H and SQLFRONT.H?
> >
> > Thanks,
> >
> > 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"
---------------------------------------------------------------------------
    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"

Reply via email to