Hi,

How do I connect to my localdb and azuredb microsoft msql. I did put odbc msql and no data comes out. Any help? I'm using Ari Data Tables.

Hello,

If want to connect the plugin with MS SQL database, set "DB type" parameter to "ODBC" value, enter a connection string in "Host" parameter. For example:

Driver={SQL Server Native Client 10.0};Server=DBHOST;Database=DBNAME;

Where DBHOST is address of server where database is installed and DBNAME is database name. For example if database is located on 192.168.0.33 host and has name ReportsDB, use the following connection string:

Driver={SQL Server Native Client 10.0};Server=192.168.0.33;Database=ReportsDB;

Check also that ODBC PHP extension is installed on your site and ODBC source is registered on your web server.

Regards,
ARI Soft

Hi, I appreciate you response, but I still have a doubt. I attached a file print screen of my fields of Data Tables and I'd like to your help to tell me where do I write the right thing.


Conexon chain,

Driver={ODBC Driver 13 for SQL Server};Server=tcp:amh.database.windows.net,1433;Database=amh;Uid=example@amh;Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;

Best regards,

Fernando Paranhos

Populate "External database -> Host" parameter with DSN (data source name). It looks like:

Driver={ODBC Driver 13 for SQL Server};Server=amh.database.windows.net;Database=smh;

Populate "External database -> User" ad "External database -> Password" with DB user and DB password.

Check that ODBC PHP extension is installed on your web server and ODBC source is registered.

Try to also set "Choose source type -> SQL -> Debug mode" parameter to "Yes" to see what error occurs.

PS: If it doesn't help, could you provide a link to a page where your try to use the extension and a temporary access to your Joomla! backend by email or FTP access to <joomla_directory>/modules/mod_aridatatables folder so we can investigate the problem in more details?

Regards,
ARI Soft

Hi,

I really appreciate your help. I'm trying in my localhost notebook to learn. I'v got data-source DSN in my system and PHP configuration all set. I can use team view but I can upload for you my module I've just bought and downloaded if you prefer. Other way is give you my azure database rights to you connect from there but i'll need your ip range to habilitate in azure environment. I really don't want to give you hard word on this but I loved the report this module can give me. So if you have any other version older then that with connection to mssql right the way without odbc would be great.

Best regards,

Fernando Paranhos

Check your mail please.

Regards,
ARI Soft