Forum Discussion

Chrisp22o's avatar
Chrisp22o
Frequent Visitor
9 years ago

ODBC connection - Large table

Hi,   I am trying to import a large table from a database that I connect to using an ODBC connection.  I am finding that when I try to query the table and also refresh, it is taking a considerable ...
Need Help
trek5000's avatar
trek5000
New Member
9 years ago

Is there a way to set a row limit for the data preview window in the get data wizard/workflow for ODBC sources? Every time a table is selected the data preview puts a query to the the underlying data source essentially doing a select *.  If using direct query the SQL it passes to underlying source limits to 1000 rows. Why doesn't ODBC do the same thing? Unfortunately not all data sources can be connected via direct query so this limitation is tough to overcome on large tables

blacksnow's avatar
blacksnow
Regular Visitor
9 years ago

I'm having what may be similar difficulties. I'm receiving the error below when trying to load a table through an ODBC connection. I tried limiting the range of the row without any impact. Been searching around online some and haven't found much to address this specific issue. I'll keep searching. In the meantime, any insight would be appreciated.

 

 

DataSource.Error: ERROR [HY000] [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC 20101 driver][20101]MM- Row too big (7711)
ERROR [HY000] [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC 20101 driver][20101]MM- Row too big (7711)
ERROR [HY000] [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC 20101 driver][20101]MM- Row too big (7711)
ERROR [HY000] [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC 20101 driver][20101]MM- Row too big (7711)
ERROR [HY000] [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC 20101 driver][20101]MM- Row too big (7711)
ERROR [HY000] [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC 20101 driver][20101]MM- Row too big (7711)