MC front-ends to PostgreSQL and Oracle 7.3 to 9i

[Vikram Singh]

Pierre Sahores wrote--------------------

>For the ones using Oracle or PostgreSQL backend databases (unix hosted)
>and wants to drive them from within mc apps, without to be sure about
>the way to do it, just adapt the next script example to your needs
>(replace "psql" with "sqlplus" to link an Oracle server).

>   put "" into DbAuteurs
>   get shell("echo" && quote & "select distinct auteur__ from citations order 
by
>auteur__" && quote && "| psql -h localhost citalis")
>   repeat for each line l in line 3 to -3 of it
>     put word 1 to -1 of l & return after DbAuteurs
>   end repeat


I've installed MySql on WinXP and am trying to get MC to talk to it via shell, 
without success. The result of the shell command is :

**'mysql' is not recognized as an internal or external command, operable 
program or batch file.**

How does one go about registering the string "mysql" in Win XP? Is there any 
other consideration one needs to keep in mind?

Pierre, what is 'citalis' in the example above : the username? Aren't the 
username and password needed to get it working?

TIA
Vikram