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
ERROR: relation "msysconf" does not exist
The psqlodbc_xxxx.log written to my local machine ends with
conn=124694520, query='DROP TABLE "plot_data"'
And the mylog_xxxx.log file doesn't seem to mention overflow anywhere,
but it does contain the lines
**** PGAPI_ExecDirect: hstmt=131080744, statement='DROP TABLE
PGAPI_ExecDirect: calling PGAPI_Execute...
PGAPI_Execute: clear errors...
recycle statement: self= 131080744
Exec_with_parameters_resolved: copying statement params:
trans_status=1, len=22, stmt='DROP TABLE "plot_data"'
 stmt_with_params = 'DROP TABLE "plot_data"'
 it's NOT a select statement: stmt=131080744
send_query(): conn=131086712, query='DROP TABLE "plot_data"'
send_query: done sending query
Can anyone tell me what's going on, and how to fix it?
pgsql-odbc by date
|Next:||From: Mike Miller||Date: 2004-09-16 21:07:20|
|Subject: Re: Access export overflow|
|Previous:||From: Lothar Behrens||Date: 2004-09-16 18:03:03|
|Subject: Re: ODBC SQLSetPos Delete problem|