Hi,

I have a remote sql server running on a dns host name (with dyndns) on port 1433.
I can access it without problems from home on that port using different tools.

When i fill in the hostname (sqlXXXX.dyndns.org:1433) user and correct password, I cannot access the data using ARI data tables.

Can you please help?

Hello,

It is possible to connect via ODBC to MS SQL database. For this check that PHP_ODBC PHP extension is installed on your web server, ODBC driver is installed on database server and an ODBC source is registered on server where your site is located.

Value of "Host" parameter will look like:

Driver={SQL Server Native Client 10.0};Server=sqlXXXX.dyndns.org:1433;Database=ReportsDB;

Regards,
ARI Soft

Hello,

My provider told me that ODBC php is never installed on shared webhosting services so this is not possible using ODBC.
in the description it says your software can read from MSSQL and MS SQL is also selectable in the module? So why do need ODBC then?

It is not true about ODBC extension. For example PHP ODBC extension is installed on BlueHost (HostMonster) shared hosting. This is enough popular hosting.

Some technical information, it is not possible to connect directly in PHP to a DB server. A PHP extension is used for this purpose. For each database type (MS SQL, Oracle and etc.) uses different PHP extensions and this extension should be installed on your server. When "MS SQL" option is selected in module settings, the module tries to connect to MS SQL server using MS SQL PHP extension which were available till PHP 5.2.0 (i can mistake in this version, but in any case it is an old version of PHP). This is not available for latest PHP versions. Another PHP extension exists, but they are not official and buggy enough so it is preferable connect to MS SQL server via ODBC. We leave this option for old "ARI Data Tables" customers to provide a backward compatibility.

Regards,
ARI Soft

Hi,

i changed the hosting to bluehost shared hosting and I have still the same problem.
can you please say what i have to fill in in the different fields?


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

Thanks

Hello,

Register an ODBC source on server where your site is located (can contact hosting support to get more information about it).

Value of "SQL -> External database -> Host" parameter in module settings will look like:

Driver={SQL Server Native Client 10.0};Server=sqlXXXX.dyndns.org:1433;Database=ReportsDB;

Exact value depends on version of your MS SQL and installed drivers, path to your server and name of your database.

Regards,
ARI Soft