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?

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