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


Recent Events
  • 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.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


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?

Load Data From - SQL
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Load Data From - SQL
#58774
Load Data From - SQL 1 Year ago Karma: 0
Hi Ari Team!!

I want to load data from a SQL DB using FreeTDS Driver. (i hope this is correct )

If i try to make the query directly in my linux server (centos) the query works perfeclty .. the odbc.ini have the next data:

[SQLServer]
Driver = FreeTDS
Description = Test
Trace = No
Server = x.x.x.x\SQLTEST
TDS version = 0.95
Database = BD

->

In the Load data option (module):

From: External database
DB type: ODBC (MS SQL and others)
Host:Driver={SQLServer};Server=x.x.x.x\SQLETEST;Database=BD;
DB name: (empty)
user: user
password: passwd

Persistance connection: YES


I'll be try in different ways putting the data in the form, but nothing happend.

Help..!!

Regards!!
The administrator has disabled public write access.
 
#58775
Re:Load Data From - SQL 1 Year ago Karma: 667
Hello,

When "DB Type" parameter is set to "ODBC" value, ODBC driver should be used for a database. ODBC source should be registered on server where your site is installed. You can contact your DB administrator and ask to help configure it for you.

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