Home > Archive > Delphi > July 2004 > connecting to a MySQL server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
connecting to a MySQL server
|
|
| Jimmie Moberg 2004-07-12, 4:03 pm |
| I need some help here...
i need to make a program connect to an online MySQL-server but i dont have a
clue how to do this... anyone got any tips? i use Delphi 7
| |
|
| On Mon, 12 Jul 2004 14:18:30 GMT, "Jimmie Moberg"
<jimmie.moberg@datorforum.se> wrote:
>I need some help here...
>i need to make a program connect to an online MySQL-server but i dont have a
>clue how to do this... anyone got any tips? i use Delphi 7
What version of Delphi 7? If it is Professional, Enterprise or
Architect, you should find components on the DBExpress panel that will
do this for you.
| |
| Jimmie Moberg 2004-07-12, 4:04 pm |
|
"Noel" <no.spam@thank.you> skrev i meddelandet
news:9qh5f01c0sbhabco40s7klpaqj6jlijmun@
4ax.com...
> On Mon, 12 Jul 2004 14:18:30 GMT, "Jimmie Moberg"
> <jimmie.moberg@datorforum.se> wrote:
>
have a[color=darkred]
>
> What version of Delphi 7? If it is Professional, Enterprise or
> Architect, you should find components on the DBExpress panel that will
> do this for you.
>
| |
| Jimmie Moberg 2004-07-12, 4:04 pm |
| I'm using the enterprise... but i've never worked with those components
before so i would be very grateful if u could give me a hand
"Noel" <no.spam@thank.you> skrev i meddelandet
news:9qh5f01c0sbhabco40s7klpaqj6jlijmun@
4ax.com...
> On Mon, 12 Jul 2004 14:18:30 GMT, "Jimmie Moberg"
> <jimmie.moberg@datorforum.se> wrote:
>
have a[color=darkred]
>
> What version of Delphi 7? If it is Professional, Enterprise or
> Architect, you should find components on the DBExpress panel that will
> do this for you.
>
| |
|
| On Mon, 12 Jul 2004 17:34:50 GMT, "Jimmie Moberg"
<jimmie.moberg@datorforum.se> wrote:
>I'm using the enterprise... but i've never worked with those components
>before so i would be very grateful if u could give me a hand
You will need a TSQLConnection, where you specifiy the type of
database server, the database to connect to, etc. You will then need
a TSQLDataset, which has as its connection property the TSQLConnection
created earlier. The commandtext property contains the SQL select
statement to get to the tables you require. Then you will need a
Provider and a TClientDataSet. The provider has as its dataset the
TSQLDataset. The ClientDataSet has as its provider the Provider
created earlier. The Provider and ClientDataset are needed if you
want work on the data in read/write and navigate the data in both
directions.
It is all documented in the manual, under developing database
applications.
| |
| Nicolai Hansen 2004-07-13, 9:01 am |
| "Jimmie Moberg" <jimmie.moberg@datorforum.se> wrote in message news:<W4xIc.98389$dP1.330505@newsc.telia.net>...
> I need some help here...
> i need to make a program connect to an online MySQL-server but i dont have a
> clue how to do this... anyone got any tips? i use Delphi 7
Try to google for some components called Zeos or ZeosDB or something like that.
/Nic
| |
| Jimmie Moberg 2004-07-13, 4:00 pm |
| i just spoke with the support team at the company where i have my
homepage... i cant connect to the sql-server from outside... only from the
webserver so i need to think in new directions... thinking of putting a
php-script on the website that goes in to the sql and copies the entries i
want to a txt-file and then using delphi to download the txt... very
annoying procedure but it might work...
thanks anyway for the help Noel...
"Noel" <no.spam@thank.you> skrev i meddelandet
news:9fa7f0tqgs58r9imq4gjo3f40n3rgfdq76@
4ax.com...
> On Mon, 12 Jul 2004 17:34:50 GMT, "Jimmie Moberg"
> <jimmie.moberg@datorforum.se> wrote:
>
>
> You will need a TSQLConnection, where you specifiy the type of
> database server, the database to connect to, etc. You will then need
> a TSQLDataset, which has as its connection property the TSQLConnection
> created earlier. The commandtext property contains the SQL select
> statement to get to the tables you require. Then you will need a
> Provider and a TClientDataSet. The provider has as its dataset the
> TSQLDataset. The ClientDataSet has as its provider the Provider
> created earlier. The Provider and ClientDataset are needed if you
> want work on the data in read/write and navigate the data in both
> directions.
>
> It is all documented in the manual, under developing database
> applications.
>
>
>
| |
|
| On Tue, 13 Jul 2004 13:31:01 GMT, "Jimmie Moberg"
<jimmie.moberg@datorforum.se> wrote:
>i just spoke with the support team at the company where i have my
>homepage... i cant connect to the sql-server from outside... only from the
>webserver so i need to think in new directions... thinking of putting a
>php-script on the website that goes in to the sql and copies the entries i
>want to a txt-file and then using delphi to download the txt... very
>annoying procedure but it might work...
Why not have the PHP scripts return XML?
| |
| Jimmie Moberg 2004-07-14, 3:57 am |
| now you lost me :)
"Noel" <no.spam@thank.you> skrev i meddelandet
news:dsf8f01frc90ibh20p4cvbpa8i3ad4dfoh@
4ax.com...
> On Tue, 13 Jul 2004 13:31:01 GMT, "Jimmie Moberg"
> <jimmie.moberg@datorforum.se> wrote:
>
the[color=darkred]
i[color=darkred]
>
> Why not have the PHP scripts return XML?
>
>
>
| |
| Dragon Lord 2004-07-28, 9:07 pm |
| http://www.fichtner.net/delphi/mysql.delphi.phtml
thats if you don't care how you access it. This works for Delphi7 and New
Versions of mySQL
http://microolap.com/dbx/mysql/index.htm
Thats a DBExpress Driver for mysql.
It really depends on what your going to do with your program.
If you are only going to be using mysql, and don't care about porting to
other database, then the first would be a good choice. If you need
portablity, then go with the DBExpress driver.
Jeremy
"Jimmie Moberg" <jimmie.moberg@datorforum.se> wrote in message
news:W4xIc.98389$dP1.330505@newsc.telia.net...
> I need some help here...
> i need to make a program connect to an online MySQL-server but i dont have
a
> clue how to do this... anyone got any tips? i use Delphi 7
>
>
>
>
|
|
|
|
|