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?

Load Data From - SQL
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Load Data From - SQL
#58774
Load Data From - SQL 1 Year, 2 Months 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, 2 Months ago Karma: 670
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