Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

msql srv microsoft
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: msql srv microsoft
#60486
msql srv microsoft 6 Months, 1 Week ago Karma: 0
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.
The administrator has disabled public write access.
 
#60493
Re:msql srv microsoft 6 Months ago Karma: 670
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
The administrator has disabled public write access.
 
#60495
Re:msql srv microsoft 6 Months ago Karma: 0
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
Last Edit: 2017/06/13 05:56 By fparanhos.Reason: 800 pixels file
The administrator has disabled public write access.
 
#60496
Re:msql srv microsoft 6 Months ago Karma: 670
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
The administrator has disabled public write access.
 
#60497
Re:msql srv microsoft 6 Months ago Karma: 0
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
Last Edit: 2017/06/13 13:17 By fparanhos.Reason: file size
The administrator has disabled public write access.
 
#60502
Re:msql srv microsoft 6 Months ago Karma: 670
Check your mail please.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 12