Hello,
I am having some issues with the DB Data Source.
I have added the username, password, type, db name and IP address of the server, added a query and i get nothing.
I have checked the DB end (with is held remotely from the Matrix installation) and everything is setup fine there.
The issue is i have no idea where the problem resides, the connection, the query or the remote DB setup.
Is there a log or error report i can read to find out where the issue is as i am looking for a needle in a haystack at the moment.
Cheers
[quote]
Hello,
I am having some issues with the DB Data Source.
I have added the username, password, type, db name and IP address of the server, added a query and i get nothing.
I have checked the DB end (with is held remotely from the Matrix installation) and everything is setup fine there.
The issue is i have no idea where the problem resides, the connection, the query or the remote DB setup.
Is there a log or error report i can read to find out where the issue is as i am looking for a needle in a haystack at the moment.
Cheers
[/quote]
Hi,
The logs are located at [SYSTEM_ROOT]/data/private/logs. The log that might interest you would of course be error.log. What DB are you trying to connect to (Oracle, PSQL ,etc.) ?? can you attach a screen shot of the details screen of the DB Connector Asset to see if there is anything obvious there ? Can you talk to the DB server from where you Matrix is installed from command line?
Cheers,
Ash