ODBC

I am extracting data from SQL Server to another data form, and i have a table which is of 5 GB , when ODBC reads the table a error comes "failed to create recordset from table".
Can someone suggest what might be the reason, 1 reason i found was that the jet.temp it creates in windows has a limit of 2 GB..
can anyone tell something to do this.
From http://www.developmentnow.com/g/111_0_0_0_0_0/sql-server-odbc.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
I don't completely understand what the scenario is here but I'll take a stab
at it. I'm assuming that your getting this error somewhere in the middle of
the export. If your extracting data from Sql Server to a Jet database
(Microsoft.Jet.OLEDB.4.0 provider) then the problem most likely is the size
of your Sql table. .TMP files are used for processing Jet transactions and
are limited to the max Jet database size, which is 2gb. Even if you exported
the Sql data to a text file first, if the data exceeds 2gb, it would still be
too much data for a Jet database.
-Curtis
"Anshul Kumar" wrote:

> I am extracting data from SQL Server to another data form, and i have a table which is of 5 GB , when ODBC reads the table a error comes "failed to create recordset from table".
> Can someone suggest what might be the reason, 1 reason i found was that the jet.temp it creates in windows has a limit of 2 GB..
> can anyone tell something to do this.
> From http://www.developmentnow.com/g/111_0_0_0_0_0/sql-server-odbc.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>