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


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


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 7 Years 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 7 Years ago Karma: 748
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 7 Years 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 11:56 By fparanhos.Reason: 800 pixels file
The administrator has disabled public write access.
 
#60496
Re:msql srv microsoft 7 Years ago Karma: 748
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 7 Years 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 19:17 By fparanhos.Reason: file size
The administrator has disabled public write access.
 
#60502
Re:msql srv microsoft 7 Years ago Karma: 748
Check your mail please.

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