DB Connection Failed! Using DB Save Advanced

I want to use a separate database for some forms away from the Joolma! installation, so I setup a table from my form.
Exported that table to the external database, everything good so far.
I placed a "DB Save" action inside the Submit Element and then proceeded to configure using the Advance Tab.
I filled in all the correct external DB server info and then hit "Refresh Tables List" and promptly got the "DB Connection Failed!" error!

I have checked and rechecked everything on the SQL server and in the Forms configuration.

Is there something else I need to do to get this to work?

Hi webzight,

There's nothing extra that I know of from the ChronoForms end, you may need to configure the database to receive remote connections.

Bob

I just realized what I think you are saying here, if so my provider does not allow remote connections on their shared servers. If that is what is going on here then maybe there needs to be some rethink on how this application connects with DB for such purposes.

As a followup I tried to use the default method (local) and received the following php errors that basically said the same thing, no database connectivity😟

Warning: Invalid argument supplied for foreach() in /homepages/30/d108588548/htdocs/cambria/libraries/joomla/database/database/mysql.php on line 377

Parse error: syntax error, unexpected 'Connection' (T_STRING), expecting '{' in /homepages/30/d108588548/htdocs/cambria/administrator/components/com_chronoforms/form_actions/db_save/db_save.php(64) : eval()'d code on line 3

Fatal error: Call to a member function bind() on a non-object in /homepages/30/d108588548/htdocs/cambria/administrator/components/com_chronoforms/form_actions/db_save/db_save.php on line 116

What now😟

(UPDATE)

Got local database save to work, i.e. same database where Joomla! resides.

The above errors I received because the configuration for dbSave was still set to remote save, when I thought I had turned it off, must have not saved after config change😶

That means I am still in dilemma on how to save data to different database than Joomla🤨

Hi webzight,

It should work AFAIK, this has been tested on many websites, you just need to enter the other db config correctly, did you double check that ? is the other db on the same server or not ?

Regards,
Max