I'm trying to connect Squiz to an Oracle database using the DB data source. When I add some SQL and click commit, the Query Builder screen is left hanging (just an empty screen) and doesn't commit any changes. I'm guessing it's something to do with the connection to the database, but I've double checked the username/password/host name and they're all correct.
Any ideas what it might be?
Could you take a look at your error logs and see if they give you any hints?
Hi Nic
I've looked at the error logs and there's no log that relates to when I was attempting to run the query. I've now managed to get it to accept the query by putting in a dummy complete DNS then reverting to the real connection details, but it doesn't seem to run on commit. I've also tried inputting a complete DNS of oci:dbname=//hostname:port-number/database format but that doesn't seem to work either.
do you have oracle instant client installed on your server?
Hi Aleks
Possibly not, come to think of it, I'd need to check with our systems team. Obviously if it wasn't installed then the DNS string I was using wouldn't work, would it also account for the field entry connection details on the DB Data Source screen not working too?