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"