Buy Now
Sign in

External Database Connectivity

mindwrap , September 19 2016
M
mindwrap
I noticed the suggestion to add external database connectivity from 2012. Has there been any headway with this ability? We are looking to use this functionality. We love the power of ChronoEngine products and really don't want to create new components or plugins ourselves.

Thanks!

Jay
GreyHead
Hi Jay,

Just checked and the current version of CCv5 has an External Database tab. Does that so what you need?

Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
M
mindwrap
Bob,

I'm sorry, I wasn't clear. We are wanting to connect to an external firebird database. The issue with that tab is that under Driver, it states, "Your database driver, only mySQL is supported at the moment." Sorry for the confusion.

I am digging through the gobs of documentation on your site and there seems to be a way in chronoforms that it can be done by using the onload event to supply the form with an external connection created using JDatabase. I am continuing to dig and see if we can supply a table to the connectivity connection and will display what we provide. I don't believe the JDatabase connector supports firebird so, we will need to supply the datatable through PHP it seems. I am still hunting. If I find an answer, I will update the post.

Thanks for replying!

Jay
GreyHead
Hi Jay,

I now zero about FireBird so can't help with that part. In a ChronoForm you can certainly add Custom Code to read any PHP accessible database; that may be possible in ChronoConnectivity but so far I don't know how to do it :-( You can probably grab the data OK in the PHP before listing box - I guess that you'd then need to find a way to add that to the $row array for display.

Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much