D7, ADO, ISAPI and IIS6 (better format)

D7, ADO, ISAPI and IIS6 (better format)

Post by Bernard Ta » Fri, 07 Jan 2005 19:05:26



I am trying to convert a D5 BDE-based ISAPI DLL which uses
Paradox files under IIS5 to D7 and Access files through ADO on
IIS6.

I have fallen at the first hurdle, which is that any ISAPI DLL I
create seemes to fail as soon as I include a tADOConnection
component. Even when the DLL does not refer to the component the
browser receives a 500 error. I have seen correspondence
referring to Coinitialize, but I can't get this to fix the
problem.

Does anyone have a very simple solution or code example to
demonstrate the use of ADO with ISAPI and IIS6? I don't need SQL
server (I hope!) as the database is stored on the Web server.

TIA Bernard
 
 
 

D7, ADO, ISAPI and IIS6 (better format)

Post by Viatchesla » Sat, 08 Jan 2005 05:40:46

At first, setup development IIS server to send complete error information to
client - you will see error description. Then set
IWServerController.ComInitialization to ciNone and do not call
CoInitialize(). If you still can not connect to Jet db, write error
description here.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.yqcomputer.com/ - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.yqcomputer.com/ - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


> I am trying to convert a D5 BDE-based ISAPI DLL which use>
> Paradox files under IIS5 to D7 and Access files through ADO o>
> IIS6>
> I have fallen at the first hurdle, which is that any ISAPI DLL >
> create seemes to fail as soon as I include a tADOConnectio>
> component. Even when the DLL does not refer to the component th>
> browser receives a 500 error. I have seen correspondenc>
> referring to Coinitialize, but I can't get this to fix th>
> problem>
> Does anyone have a very simple solution or code example t>
> demonstrate the use of ADO with ISAPI and IIS6? I don't need SQ>
> server (I hope!) as the database is stored on the Web server>
> TIA Bernar>
>