Hi Jim,

Sorry, can't be much help with that.  I've been considering going down
that same path because of a number of issues with ODBC (with MS SQL and
Informix), but as yet I haven't taken the plunge.

Good luck!

Regards,

Bevan


Jim Zheng wrote:
> 
> 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"
---------------------------------------------------------------------------
    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