Database on Linux Server

[Duke]

I am Sorry for my English.

I want to connect, from a Windows XP PC, to a MySQL Database on a Linux Server (Ubuntu 7.10).

I need ADODB for Linux, I think , and i found this:
http://adodb.sourceforge.net/
I am not sure, whether this will work.

Will this works? Or do you have any other Idea how to connect to a Database on Linux Server with Macro Scheduler?

edit: And i am Sorry, if "Beginners" is wrong for this Subject.

edit2: Do i need to install ADODB on client or server? both, right?

[Marcus Tettmar]

You don't need ADODB for Linux. You just need the MySQL ODBC drivers:
http://www.mysql.com/products/connector/odbc/

We use this ourselves. We have a MySQL database on a Linux server and Macro Scheduler connects from Windows via the MySQL ODBC connection.

You will also need to create a user under MySQL with remote access privileges and ensure the MySQL port is open (at least for your IP).

[Alpha_AI]

so are you saying that i can create macroscript that can connect to a remote mysql database and send select statements to a mysql database and receive the values and then do something with them?

how would i do that? Im more interested in connecting to a remote mysql database than a local mysql database;

This is would be something useful.

Ben

[Marcus Tettmar]

>so are you saying that i can create macroscript that can
>connect to a remote mysql database and send select
>statements to a mysql database and receive the values and
>then do something with them?

Yes

>how would i do that?

Just as you would any other ODBC data source.

Install the MySQL ODBC drivers:
http://www.mysql.com/products/connector/odbc/

[shamigc]

Could you please send a short code example of how to connect and how to select information from a MySQL database?

Thanks,
Salvador Hernandez