Astrolab Posted November 17, 2011 Share Posted November 17, 2011 How to connect to mysql in isapi module,apachi configuration, What to change in httpd.cnf, what component to use , can we use zeus database controls. Regards! Link to comment Share on other sites More sharing options...
andersa@ellenshoej.dk Posted November 17, 2011 Share Posted November 17, 2011 Have you tried anything and are you getting an error or? I am not sure if there are any special considerations for the apache server. In theory any database components should work. Link to comment Share on other sites More sharing options...
Astrolab Posted November 17, 2011 Author Share Posted November 17, 2011 Have you tried anything and are you getting an error or? Thanks for reply, In browser I Get error 500, in log file I Have: Project1: 00000C70: 13:23:23:Exception : None of the dynamic libraries can be found: libmysql51.dll, libmysql50.dll, libmysql.dll I am not sure if there are any special considerations for the apache server. In theory any database components should work. It is Zeus database components! Link to comment Share on other sites More sharing options...
andersa@ellenshoej.dk Posted November 18, 2011 Share Posted November 18, 2011 This is not an isapi dll issue. The errors occur because the database components can not find the required driver libraries. These need to be bundled with your application. The Zeus documentation should contain information on how to deploy your application and which libraries you need to add. Link to comment Share on other sites More sharing options...
Astrolab Posted November 18, 2011 Author Share Posted November 18, 2011 When I make standalone server application it works correctly, but in isapi module error occurs: Project1: 000008FC: 10:59:03:Exception : None of the dynamic libraries can be found: libmysql51.dll, libmysql50.dll, libmysql.dll Link to comment Share on other sites More sharing options...
Oliver Morsch Posted November 18, 2011 Share Posted November 18, 2011 When I make standalone server application it works correctly, but in isapi module error occurs: Project1: 000008FC: 10:59:03:Exception : None of the dynamic libraries can be found: libmysql51.dll, libmysql50.dll, libmysql.dll Are the dll's located in the app-path? Then standalone server finds the dll's in its path, but in case of isapi the searchpath is the path of the internetserver (iis, apache). Link to comment Share on other sites More sharing options...
andersa@ellenshoej.dk Posted November 19, 2011 Share Posted November 19, 2011 You should be able to use Process Explorer (http://technet.microsoft.com/en-us/sysinternals/bb896653) to see what the search strategy is for those libraries. Make sure the libraries are available in the search path. Alternatively try loading the library manually using LoadLibrary. Link to comment Share on other sites More sharing options...
Astrolab Posted November 20, 2011 Author Share Posted November 20, 2011 Thanks for reply, I solved! I put libMysql.dll in c:\xampp\apache\bin\ but is it a huge dll, it takes about 5.5MB, it is just a one grid on form! Link to comment Share on other sites More sharing options...
andersa@ellenshoej.dk Posted November 21, 2011 Share Posted November 21, 2011 Well you probably have hundreds og gigabytes of free space on your harddisk, so nothing to worry about. Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted November 22, 2011 Administrators Share Posted November 22, 2011 Thanks for reply, I solved! I put libMysql.dll in c:\xampp\apache\bin\ but is it a huge dll, it takes about 5.5MB, it is just a one grid on form! It depends on 3rd party DB components you use in your project. Also newer Delphi versions can create bigger exe files. Link to comment Share on other sites More sharing options...
darknesspider Posted February 20, 2012 Share Posted February 20, 2012 please step step settings, example or example upload Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted February 21, 2012 Administrators Share Posted February 21, 2012 please step step settings, example or example upload We'd really like to help, but there is a limited amount of time we can dedicate to each reported case. Please try to create a test project yourself first. Link to comment Share on other sites More sharing options...
darknesspider Posted February 21, 2012 Share Posted February 21, 2012 We'd really like to help, but there is a limited amount of time we can dedicate to each reported case. Please try to create a test project yourself first. i create VCL application/standalone server/isapi module working but only isapi module not working.not connection mysql. Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted February 21, 2012 Administrators Share Posted February 21, 2012 i create VCL application/standalone server/isapi module working but only isapi module not working.not connection mysql. OK. Please send a simple test case with a sample DB file. Link to comment Share on other sites More sharing options...
darknesspider Posted February 21, 2012 Share Posted February 21, 2012 OK. Please send a simple test case with a sample DB file. thaks den33.rar Link to comment Share on other sites More sharing options...
darknesspider Posted February 21, 2012 Share Posted February 21, 2012 OK. Please send a simple test case with a sample DB file. thank you den3.rar Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted February 21, 2012 Administrators Share Posted February 21, 2012 Which one? Den3 or 33? Link to comment Share on other sites More sharing options...
darknesspider Posted February 21, 2012 Share Posted February 21, 2012 Which one? Den3 or 33? den3 last app current app den3 Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted February 21, 2012 Administrators Share Posted February 21, 2012 It works here with Apache 2.2. Here is my Conection String: object ADOConnection1: TADOConnection Connected = True ConnectionString = 'Provider=MSDASQL.1;Persist Security Info=False;User ID=root;Mode' + '=ReadWrite;Extended Properties="DSN=denememysql;SERVER=127.0.0.1' + ';UID=root;DATABASE=test;PORT=3306"' LoginPrompt = False Mode = cmReadWrite Left = 616 Top = 24 end Link to comment Share on other sites More sharing options...
darknesspider Posted February 21, 2012 Share Posted February 21, 2012 It works here with Apache 2.2. Here is my Conection String: object ADOConnection1: TADOConnection Connected = True ConnectionString = 'Provider=MSDASQL.1;Persist Security Info=False;User ID=root;Mode' + '=ReadWrite;Extended Properties="DSN=denememysql;SERVER=127.0.0.1' + ';UID=root;DATABASE=test;PORT=3306"' LoginPrompt = False Mode = cmReadWrite Left = 616 Top = 24 end in iexplorer not working Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted February 21, 2012 Administrators Share Posted February 21, 2012 So does it work in FF? Link to comment Share on other sites More sharing options...
darknesspider Posted February 23, 2012 Share Posted February 23, 2012 So does it work in FF? firefox,chrome not working sqlite working but i want to mysql Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted February 23, 2012 Administrators Share Posted February 23, 2012 firefox,chrome not working sqlite working but i want to mysql What is "not working"? Without a detailed error report and specific error messages it is impossible for us to help you. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now