This question about Configuration: Asked
DATABASE_SQL configuration
--
JackieLester - 20 Nov 2013
I've found my version! It says it is Foswiki-1.1.7, Plugin API version 2.2
--
JackieLester - 20 Nov 2013
I am a complete newcomer to this foswiki world (I can't even work out what version I am using - that's how much of a numpty I am) so please be patient with me.
I am trying to use the DATABASE_SQL plugin to get some data out of an Oracle database and display it in my wiki page. The database is on a different server. I have attempted to configure the database plugin, assumed I shoud use "remote" and told it things like servername, database SID, username, password, but when I subsequently try and use %DATABASE_SQL% in my wiki page, nothing happens - it just sits there with its % signs as a bit of text instead of weaving the magic.
At least two things are confusing me:
1) It never asks me for a port number for the database listener, so how will it try and connect to my database?
2) The DATABASE_SQL uses a description in its syntax and I can't work out what value I should be using.
All top tips gratefully received.