Access export overflow

From: Ken-ichi <kueda(at)nature(dot)berkeley(dot)edu>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Access export overflow
Date: 2004-09-16 20:48:05
Message-ID: 4149FC05.1090500@nature.berkeley.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi folks. I tried searching this list's archives for this problem but
came up short. I have a fairly large table in MS Access 2000 (33 cols,
3270 rows) that I'm trying to export to PostgreSQL 7.4.3. When I clip
the table to only about 100 rows, the export runs fine, but when I try
to export the whole thing, I get an error window that says only
"Overflow." This process generates the following error in my
postgresql.log file:

ERROR: relation "msysconf" does not exist

The psqlodbc_xxxx.log written to my local machine ends with

conn=124694520, query='ROLLBACK'
conn=124694520, query='DROP TABLE "plot_data"'
conn=124694520, PGAPI_Disconnect

And the mylog_xxxx.log file doesn't seem to mention overflow anywhere,
but it does contain the lines

[1900]**** PGAPI_ExecDirect: hstmt=131080744, statement='DROP TABLE
"plot_data"'
[1900]PGAPI_ExecDirect: calling PGAPI_Execute...
[1900]PGAPI_Execute: entering...
[1900]PGAPI_Execute: clear errors...
[1900]recycle statement: self= 131080744
[1900]Exec_with_parameters_resolved: copying statement params:
trans_status=1, len=22, stmt='DROP TABLE "plot_data"'
[1900] stmt_with_params = 'DROP TABLE "plot_data"'
[1900] it's NOT a select statement: stmt=131080744
[1900]send_query(): conn=131086712, query='DROP TABLE "plot_data"'
[1900]send_query: done sending query

Can anyone tell me what's going on, and how to fix it?

Thanks.

-Ken-ichi

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Mike Miller 2004-09-16 21:07:20 Re: Access export overflow
Previous Message Lothar Behrens 2004-09-16 18:03:03 Re: ODBC SQLSetPos Delete problem