Jim,
If you're still having problems, have you looked at the Zeos components?
They include direct API access to popular db's including MS SQL.
I can't get onto their web site (http://www.zeoslib.org/) just now but an
extract from the readme is:
Zeos Database Objects is a Delphi's components set for direct
access to OpenSource databases: MySql, PostgreSql and Interbase.
Also we propose components for direct access to commerce
databases: MS SQL and Oracle.
Reading their source code may help,
Alternatively, you could use ADO.
If you don't have Delphi 5 Enterprise, have a look at the freeware
components at http://www.alohaoi.com.
I used them on a small project recently and had no problems.
The advantage with both of the above methods is you get TDataSet
descendants.
regards,
Steve
> -----Original Message-----
> From: Jim Zheng [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 28 May 2001 10:46
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: MS SQL, IIS and Delphi API
>
>
> 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"
