Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group