Home News Contact Us Forum About Us Demos Products F.A.Q.
ARI Soft









Register   Lost Password?
Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin







e-mail: info@ari-soft.com
Shopping Cart
You currently have 0 items in your cart.
Show 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.
    more...

  • 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.
    more...


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?
ARI Soft Forum
Joomla components
ARI Data Tables

Unable to connect to a remote sql server database
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: Unable to connect to a remote sql server database
#21396
Re:Unable to connect to a remote sql server database 12 Years, 6 Months ago Karma: 748
Some information how to install MS SQL PHP extension can be found here.

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#21411
Re:Unable to connect to a remote sql server database 12 Years, 6 Months ago Karma: 0
i made a connection to database but still no data available...

any example for query

i use SELECT * FROM sys.tables
plugin20
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#21417
Re:Unable to connect to a remote sql server database 12 Years, 6 Months ago Karma: 748
Try to do the following:

Open <joomla_directory>\modules\mod_aridatatables\includes\kernel\DataTables\Models\class.DataTablesDataSqlModel.php file and replace the following code:

Code:

if ($conn->ErrorNo())
{
  $data = null;
}


with the next one:

Code:

if ($conn->ErrorNo())
{
  echo $conn->ErrorMsg();exit();
  $data = null;
}


After this check please contains a page with the module error(s) or not.

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#21427
Re:Unable to connect to a remote sql server database 12 Years, 6 Months ago Karma: 0
i did the change in class.DataTablesDataSqlModel.php and still nothing...

please provide me with a simple query that i can write to SQL Query box...just for testing...when i use sql query analizer it connects and displays views correctly...but from the data table module it's not working...just " no data available" and nothing else...
plugin20
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#21428
Re:Unable to connect to a remote sql server database 12 Years, 6 Months ago Karma: 0
Hi again...is there something i'm missing from the mod_aridatatables in configuration...is there any simple tutorial for this module...i know it's not complicated but i get confused why it's not working when everything is ok...it would be ok to have an step by step tutorial for the shortest way to display a table in fronend...what do we have to change and select to see a table in frontend - it would be great to have some screenshots too for every step ( i hope i'm not asking too much but i think it would help everyone not just me)...and then we could start and test it's other features. Thanks againg for your support and your time.
plugin20
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#21437
Re:Unable to connect to a remote sql server database 12 Years, 5 Months ago Karma: 748
Hello,

Check your mail please.

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 123
ARI Soft Forum
Joomla components
ARI Data Tables
Powered by Kunenaget the latest posts directly to your desktop
Useful Links
Products
F.A.Q.
Discount
RSS
Top Products
ARI Data Tables
ARI Sexy Lightbox
ARI Quiz
ARI Stream Quiz - Personal
ARI Smart Content
Help
Forum
F.A.Q.
Home | News | Contact Us | Forum | About Us | Demos | Products | F.A.Q.
ARI Soft
License | Terms and Conditions | Copyright Info | Privacy Policy
 
ARI Soft
Copyright © 2009