connect to mysql site database with zeos

I write a program in C++ Builder and want to connect to a MySql  database with zeos ZConnection for reading and writing data. The  database from site is MySql is 4.1.I try TZConnection: user,pass, protocol:  MySql 4.1 port 80, or 3306, Isolation tiReadUncommitted. Zeos is 6.6.2 RC. But I get always errors. I need just a sample code to work with this connection.  
stadri10Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
adrpoConnect With a Mentor Commented:

More on SOAP:
http://en.wikipedia.org/wiki/SOAP

More examples:
http://webservices.xml.com/pub/a/ws/2004/03/24/phpws.html
http://users.skynet.be/pascalbotte/rcx-ws-doc/phpclient.htm
http://www.scottnichol.com/nusoapprogwsdl.htm

You could also have a look at this one:
http://sourceforge.net/projects/soap-sql/
SOAP-SQL generates a web service WSDL based on user-defined SQL statements with only a few lines of code. It relies on NuSOAP and PEAR MDB2 (DB abstraction layer), so it works with most any database. No PHP extensions required.

Cheers,
za-k/
0
 
adrpoCommented:

What kind of errors are you getting?

Cheers,
za-k/
0
 
stadri10Author Commented:
can't connect to MySql server (10060)
0
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
stadri10Author Commented:
and if I use port 80 : lost connection with mysql server durig query
0
 
stadri10Author Commented:
THANK YOU VERY MUCH FOR HELP!!!
0
 
adrpoCommented:

Have you added tcp ports 80 and 3306 in your firewall?
It might be that the firewall doesn't let you connect.

Cheers,
za-k/
0
 
adrpoCommented:

Hi again,

I think you could get better answers if you post this problem in the ZeosLib forum:
http://zeos.firmos.at/viewforum.php?f=5

Cheers,
za-k/
0
 
stadri10Author Commented:
Hello!
I need to know something:
I have a database mysql on the site. I want to read data from it but I don't have access directly, so I can't use visual components zeos or ado, etc. I need to read from database somehow in a scripting language - to do a command - that will be executed - and to read the given answer and load it in a matrix. I don't know so much programing(but I learn quickly)  and I wish just an example to understand the process.
That is my problem.
There are experts!!  I ask an expert to give me a simple code or a clue, or to show me where to find something like that.
Best regards,    
0
 
adrpoCommented:

Ok, so if I get you correctly, you want something like this:
Your Application <-> Web Server <-> MySQL Server.
In this scenario you can only connect to the Web Server and you want to proxy
requests from your application to the db via a php script (or other scripting language)  
on the server.

If that is your scenario I would use PHP + SOAP on the Web Server
and a SOAP client in your application.
Something like in here:
http://www.phpeveryday.com/articles/PHP+Web+Services+Fetching+Data+From+Database-P105.html

You will have to implement the SOAP client: client_book.php in C++ Builder.
Depening on your C++ Builder version you could create a SOAP project like here:
http://dn.codegear.com/article/28369

I hope you won't run away screaming after reading this :)

Cheers,
za-k/
0
 
stadri10Author Commented:
I need something like this:
EMS MysqlManager can connect thru http tunneling using a file "emsproxy.php". I put this file on my site and ems is connect to all databases. I need a Delphi or C++Builder component to do something like that.
Don't care if is commercial, I pay for it.
So. I have db connections on zeos, or dbx4 components, I want them to be connected is this way to site databases. Do you know a software like this? Can I find a quik way to have a connection like this to use it general on my all programs?.. A vcl component to comunicate directly with database thru php file and to load results in a grid or another dbcontrol from my program..
     
0
 
stadri10Author Commented:
What do you think of KbmMW, or Clever Internet Suite is somethig I can use?
I ask because I can not use them before I buy the controls ..
0
All Courses

From novice to tech pro — start learning today.