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


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

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


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 8 Years, 1 Month 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 8 Years, 1 Month ago Karma: 760
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