Hello,

I'm having issues connecting to an external MSSQL server (2005). First I got the message:

ARI Data Tables: Couldn't connect to external database.

I installed the MSSQL driver for PHP, and now I get the message:

(mssql): SELECT * from table_name
Error (102):
No data available.

My server is running Ubuntu 14.04 LTS/PHP 5.5.9 and Joomla! 3.4.0

Any suggestions how I can connect?

Regards,

Arne Kristian

Hello,

Try to connect to MS SQL via ODBC. Some information about it can be found here (see "F.A.Q. and troubleshooting" section).

Regards,
ARI Soft

I select connection type ODBC and use Host: Driver={SQL Server Native Client 10.0};Server=DBHOST;Database=DBNAME;

I now get the errormessage: ARI Data Tables: Couldn't connect to external database.

Installed the following ODBC driver askubuntu.com/questions/167491/connecting-ms-sql-using-freetds-and-unixodbc-isql-no-default-driver-specified


Get the following message in the apache2 error.log.

PHP Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /var/www/html/modules/mod_aridatatables/includes/kernel/DB/ADODBLite/adodbSQL_drivers/odbc/odbc_driver.inc on line 42, referer: intranett

Check that ODBC source is registered on server where web server is located.

Regards,
ARI Soft

It is now, but I still get the same message from the debug: ARI Data Tables: Couldn't connect to external database. No errors in tha apache log file now.

Could you provide a temporary access to your J! backend by email and a link to a page where the problem occurs so we can investigate it?

Regards,
ARI Soft