ggets
asked on
ISAPI Filter fails when i use database
Hi all,
I am busy writing an ISAPI URL mapping filter. Mapping the physical path work just fine, but as soon as i attempt to use a database (in a datamodule) it hangs. ie IIS will not restart.
I had this will a Com object I wnated to use in the filter as well. As soon as i create the com object (or database connection) IIS hangs.
Im currently using XP pro with Delphi 5 and I have the filter loaded as a global filter with a high priority.
Also, how can i debug this DLL. Its really frustrating not being able to step though the code.
I am busy writing an ISAPI URL mapping filter. Mapping the physical path work just fine, but as soon as i attempt to use a database (in a datamodule) it hangs. ie IIS will not restart.
I had this will a Com object I wnated to use in the filter as well. As soon as i create the com object (or database connection) IIS hangs.
Im currently using XP pro with Delphi 5 and I have the filter loaded as a global filter with a high priority.
Also, how can i debug this DLL. Its really frustrating not being able to step though the code.
ASKER
HI Ray,
Thanks, I will try your suggestions. Im not using the BDE (I decided a long time ago that it sucks and would never use it). The database is SQL7 and im using ADO. I guess rights to the database (or com object) would be the first thing to check.
Thanks, I will try your suggestions. Im not using the BDE (I decided a long time ago that it sucks and would never use it). The database is SQL7 and im using ADO. I guess rights to the database (or com object) would be the first thing to check.
Use Run/Parameters/HostApplica tion and turn off compiler optimization etc. to step through delphi dll's.
Regards,
Steve
Regards,
Steve
ggets,
You have a few old opened questions that I would like very much if you would take care of in the next 72 hours. Unfortunatley, if you do not take care of them within 1 week, I am obligated to ask administration to review your account. I am providing a handy list for you to get to your questions. Thanks for your cooperation. If you need help with finalizing any of these questions, drop a note here and I'm happy to help.
https://www.experts-exchange.com/questions/20329270/ISAPI-Filter-fails-when-i-use-database.html
https://www.experts-exchange.com/questions/20269882/XML-Mapper.html
https://www.experts-exchange.com/questions/20227857/ERROR-Running-word-automation-object-in-ASP-Page.html
https://www.experts-exchange.com/questions/20159286/No-Refresh-Please.html
https://www.experts-exchange.com/questions/20090247/Connect-to-ISP-using-etc-ppp-ppp-on.html
SpideyMod
Community Support Moderator @Experts Exchange
You have a few old opened questions that I would like very much if you would take care of in the next 72 hours. Unfortunatley, if you do not take care of them within 1 week, I am obligated to ask administration to review your account. I am providing a handy list for you to get to your questions. Thanks for your cooperation. If you need help with finalizing any of these questions, drop a note here and I'm happy to help.
https://www.experts-exchange.com/questions/20329270/ISAPI-Filter-fails-when-i-use-database.html
https://www.experts-exchange.com/questions/20269882/XML-Mapper.html
https://www.experts-exchange.com/questions/20227857/ERROR-Running-word-automation-object-in-ASP-Page.html
https://www.experts-exchange.com/questions/20159286/No-Refresh-Please.html
https://www.experts-exchange.com/questions/20090247/Connect-to-ISP-using-etc-ppp-ppp-on.html
SpideyMod
Community Support Moderator @Experts Exchange
ASKER
Hi SpideyMod,
None of these comments work and in the end I figured it out myself.
Can you please delete,
Thanks
None of these comments work and in the end I figured it out myself.
Can you please delete,
Thanks
ggets,
If you can post your solution to the problem, this will add value to our database and I can refund your question and PAQ it. If you cannot, then I will have to delete it and that would be a shame. Thanks.
SpideyMod
Community Support Moderator @Experts Exchange
If you can post your solution to the problem, this will add value to our database and I can refund your question and PAQ it. If you cannot, then I will have to delete it and that would be a shame. Thanks.
SpideyMod
Community Support Moderator @Experts Exchange
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can find it at http://www.omnicron.ca/httpd/
Sometimes it's useful to code your isapi app as a cgi exe and then convert it to dll later. It requires only token changes in the project file to compile as either. Running as a cgi app may help shed more light on the problem.
I still use d5 ent with IIS, but apparently d6 allows some IDE debugging, although I`ve not heard enough to persuade me to upgrade yet.
Further, if you say what database (flat file systems may require additional rights) that can help, and I`ll say up front that the BDE sucks as any kind of web middleware.