I need to connect to two databases to consolidate data for a client, one is for an odbc myob data file connection and another is a sql database

do you have any support notes? on either of these options

Hello,

The module can get data from remote databases and ODBC data sources (ODBC PHP extension should be installed on your server), but it can't combine data from these different sources into one table.

Regards,
ARI Soft

Where do we find these PHP extensions to install on external servers?

It should be installed on server where Joomla! is installed. We can recommend to contact your hosting support that they installed it.

Regards,
ARI Soft

Hey folks,

I'm picking up this thread for me client, capitalmeats, while they are on vacation (dang!).

We've tried to connect to this MSSQL DB trying a myriad of options. Though, I have been able to connect using to this remote database from my (different) location using using MSSQL Management Studio. You had mentioned that we need to make sure the correct PHP extention(s?) are installed on the server.

When I use the Joomla site into to view the PHP information, it appears that there is a MSSQL extension installed. Does this information below confirm we have the right extension installed? If not, which one should we be looking for? Or, is there a setting we need to tend to as well?

mssql

MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version FreeTDS

Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.charset no value no value
mssql.compatability_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit Server default Server default
mssql.textsize Server default Server default
mssql.timeout 60 60

Please advise.

Thanks so much,

Gene Crawford for Capital Meats

Oh, and I need to clarify something here. When we first started this, we were getting some weird error messages. Now, we're just getting a 'no data available' message. And, when we run in debug mode, it's not throwing any string errors, either.

Untranslated Strings Diagnostic
None

Untranslated Strings Designer
None

Thanks,

Gene