stadri10
asked on
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.
ASKER
can't connect to MySql server (10060)
ASKER
and if I use port 80 : lost connection with mysql server durig query
ASKER
THANK YOU VERY MUCH FOR HELP!!!
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/
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/
ASKER
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,
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,
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/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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..
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..
ASKER
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 ..
I ask because I can not use them before I buy the controls ..
What kind of errors are you getting?
Cheers,
za-k/