DB READ ACTION - EXTERNAL DATABASE

:shock: 😲
What i can see... on_load action -> dbread

Now.. After upgrade to the latest release of CFv5, there i s an 'External Database' label for setting..
Ok.. By default the driver is setted to mysql.
It's possible to use this features to connect to an external DB (MSSQL) to retrieve data from some table?

And.. If yes 🙄 which is the correct driver to use??

Thank's in advance

HI giacall,

My best guess is that what is expected is the name of one of the driver files in /libraries/joomla/database/driver :
mysqli, mysql, oracle, pdo, postgresql, sqlazure, sqlite, sqlsrv.

Bob

Hi Bob..

Thank's for replay..
I tryed to setup the external connection in the following way:
-ENABLED -> Yes
-DRIVER -> sqlsrv
-HOST -> IP MSSQL SERVER
-NAME -> Mssql Database name
-USER -> Username ( i use the sa user!!)
-PASSWORD -> sa user password
-PREFIX -> Empty.. Cause i would like only read the data with a select

After "load tables" i receive an error "FAILED TO CONNECT!!"

I make some mistake?!?

Hi giacall,

Sorry I have no idea :-( I don't know how Max has built this code.

Is the external database accessible from the Joomla! Server?

Bob