isapi module,apachi mysql settings

[Astrolab]

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!

[andersa@ellenshoej.dk]

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.

[Astrolab]

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!

[andersa@ellenshoej.dk]

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.

[Astrolab]

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

[Oliver Morsch]

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).

[andersa@ellenshoej.dk]

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.

[Astrolab]

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!

[andersa@ellenshoej.dk]

Well you probably have hundreds og gigabytes of free space on your harddisk, so nothing to worry about.

[Farshad Mohajeri]

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.

[darknesspider]

please step step settings, example or example upload

[Farshad Mohajeri]

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.

[darknesspider]

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.

[Farshad Mohajeri]

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.

[darknesspider]

OK. Please send a simple test case with a sample DB file.

 

thaks

den33.rar

[darknesspider]

OK. Please send a simple test case with a sample DB file.

 

thank you

den3.rar

[Farshad Mohajeri]

Which one? Den3 or 33?

[darknesspider]

Which one? Den3 or 33?

 

den3 last app current app den3

[Farshad Mohajeri]

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

[darknesspider]

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

 

[Farshad Mohajeri]

So does it work in FF?

[darknesspider]

So does it work in FF?

 

firefox,chrome not working

 

sqlite working but i want to mysql

[Farshad Mohajeri]

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.