Problem with WriteCGIString

Just starting out? Need help? Post your questions and find answers here.
User avatar
Paul
PureBasic Expert
PureBasic Expert
Posts: 1243
Joined: Fri Apr 25, 2003 4:34 pm
Location: Canada
Contact:

Re: Problem with WriteCGIString

Post by Paul »

loulou2522 wrote: Tue Sep 21, 2021 7:11 pm I use IIS10 express , can-you help me to verify the configuration ?
Sorry, I have no experience with IIS :cry:

A Google search for "cgi unable to access database in IIS server" pops up lots of information. Maybe something there will point you in the right direction? Or maybe someone here on the Forum has worked with IIS and setting up permissions?

Just a note... are you sure UseMySQLDatabase command is able to find the 'libmariadb.dll' which is required for OpenDatabase to work?
Image Image
loulou2522
Enthusiast
Enthusiast
Posts: 495
Joined: Tue Oct 14, 2014 12:09 pm

Re: Problem with WriteCGIString

Post by loulou2522 »

Hi paul,
I find my problemit's a purebasic bug between HttpRequest and OpenDatabase with Mysql.
In this case opendatabase return 0 indicating impossibility to open mysql database.
I try to programm my cgi with ado instruct following
Global ConnectionString.s = "Provider=MSDASQL;Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=xxx;User=xxxk;Password=xxxe;Option=3"
and using comate module
In this case the cgirequest return the right result an all is good . I shall post a bug in purbasicforum
Thanks for your help
Post Reply