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

[ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access
Date: 2006-07-06 13:54:20
Message-ID: 20060706135420.91C7286C4FA@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Bugs item #1000681, was opened at 2006-07-06 13:54
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000681&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Error when using ODBC driver with Microsoft Access

Initial Comment:
I have a similar problem as http://pgfoundry.org/tracker/index.php?func=detail&aid=1000528&group_id=1000125&atid=538, although not after a foreign key error, it just occurs at random multiple times a day.

I am using Access 2002, with tables link to PostgreSQL using version 8.01.02.00 ANSI of the ODBC driver. After logging in to Access, everything will work without problem for some time, and then just suddenly fail.

Once the problem occurs any table I open contains the correct number of rows, but ever column contains the text '#Name?'. And I will get something similar to the following in the postgreSQL logs:

postgres[19930]: [22-1] 2006-07-06 12:33:51 BST guycallaghan research ERROR:  invalid input syntax for integer: "^C"
postgres[19930]: [22-2] 2006-07-06 12:33:51 BST guycallaghan research STATEMENT:  SELECT 
postgres[19930]: [22-3]  "codeid","colourcode","hexvalue","image","timestamp","userid"  FROM "admin"."code"  WHERE "codeid" = '^C' OR
postgres[19930]: [22-4]  "codeid" = '^A' OR "codeid"= '^B' OR "codeid" = '^D' OR "codeid" = '^D' OR "codeid" = '^D' OR "codeid" = '^D' OR
postgres[19930]: [22-5]  "codeid" = '^D' OR "codeid"= '^D' OR "codeid" = '^D'


Restarting Access always resolves the problem.




----------------------------------------------------------------------

You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000681&group_id=1000125

pgsql-odbc by date

Next:From: 王宝兵Date: 2006-07-13 08:39:17
Subject: Novice looking for help
Previous:From: noreplyDate: 2006-07-03 18:24:02
Subject: [ psqlodbc-Bugs-1000680 ] Problem with datatype when use selct id,sum(col) from table group by id

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