|
|
Choosing A Webhost: |
Access export overflow: msg#00038db.postgresql.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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: ODBC SQLSetPos Delete problem, Lothar Behrens |
|---|---|
| Next by Date: | Re: Access export overflow, Mike Miller |
| Previous by Thread: | Latest ODBC Driver "unstable", Gary Doades |
| Next by Thread: | Re: Access export overflow, Mike Miller |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |