[ psqlodbc-Bugs-1002503 ] ODBC Failure

Bugs item #1002503, was opened at 2007-03-08 15:44
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10025 03&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Angus Carr (acarr)
Assigned to: Nobody (None)
Summary: ODBC Failure

Initial Comment:
I can get several products (Access, OpenOffice Base) to read the list of tables in my database, but they both fail on actually reading data.

Access gives a left outer join garbage message.
OpenOffice Base gives another error, and I think it wants an oid.

ArcGIS fails miserably.

I am using the current update, and have tested all the changes in (forgive me for forgetting) the japanese developer's site. They make no difference.

Any tests I can try to give more info?

Thanks,
Angus.

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

>Comment By: Angus Carr (acarr)
Date: 2007-03-09 09:07

Message:
Here you go. Thanks, and now I see your name here too :-)
Quick review of steps from the beginning (for my sake):
1.Uninstall (and check in registry)... Clean.
2. Install psqlodbc-08_02_0200, MSI format. MSI Date is
24/10/2006 4:04 PM. Take all defaults
3. Create an ODBC link, using defaults, but turning on mylog.
* named PostgreSQL30 using ANSI Driver
* named PostgreSQL30W using Unicode driver
4. Install psqlodbc35w.dll and pgxalib.dll from Hiroshi
Inoue's site to C:\Program Files\psqlODBC\0802\bin. Dates
are 02/03/07 1:26PM and 27/02/2007 9:35AM, respectively.
5. Install psqlodbc35a.dll and pgxalib.dll from Hiroshi
Inoue's site to C:\Program Files\psqlODBC\0802\bin. Dates
are 02/03/07 1:26PM and 27/02/2007 9:36AM, respectively.
6. Launch Access (2002, SR-1). From an empty DB,
right-click, link tables, choose ODBC and then select
PostgreSQL30 DSN.
7. Choose table ops.stations. And today it worked, just to
prove me wrong.
8. When I choose the view public.ltg1h, it works, too.
9. Same in ArcGIS.

I guess I will have to withdraw the bug and acknowledge the
problem as being "A Windows Problem", since I would never
say it was me and my configuration.... :-)

Thanks for the timely response.
Angus Carr.

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

Comment By: Hiroshi Inoue (hinoue)
Date: 2007-03-08 19:07

Message:
Could you attach the Mylog output for Access and/or
OpenOffice case ?

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

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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate