Page 1 of 1
Any sample scripts to connect and query with MySQL database?
Posted: Mon May 01, 2006 1:54 pm
by alex298
Hello,
I decide to use RR and MySQL with my project. I have some experience in using SQL with other computer languages. However I have problem to get start with RR. My problem is:
Are there any sample scripts and tutorials to use RR connect and query with MySQL database?
Thanks and best regards
Posted: Mon May 01, 2006 2:04 pm
by malte
Hi Alex,
you might want to look at Sarahs mySQL stacks, which you can download here:
http://troz.net/Rev/tutorials.php
All the best,
Malte
Posted: Mon May 01, 2006 2:27 pm
by alex298
Malte,
Thanks
I download the MySQLtests.rev and play around. However I have another question:
All computers in the LAN are running windows OS. The MySQL database is installed on a server and the RR stack is running on a client. What is the path of the MySQL database?
Thanks and best regards
Posted: Mon May 01, 2006 2:59 pm
by Janschenkel
Hi Alex,
When you connect to a MySQL database, you specify the host of the database as an IP-address or its hostname). So suppose that the server is called "gandalf.example.net", you'll connect to it like:
Code: Select all
get revdb_connect("mysql","gandalf.example.net",.....)
or
get revdb_connect("mysql","192.168.2.50",.....)
Ask your network administrator if you don't know exactly what the server is named or what IP-number it has.
Hope this helped,
Jan Schenkel.