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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

adrpoCommented:

What kind of errors are you getting?

Cheers,
za-k/
0
stadri10Author Commented:
can't connect to MySql server (10060)
0
stadri10Author Commented:
and if I use port 80 : lost connection with mysql server durig query
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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
adrpoCommented:

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Editors IDEs

From novice to tech pro — start learning today.