Re: Access 97 and pgsqlodbc version 7.03.0100

Thanks,

Is this a problem with the odbc driver or Access 97 as I'll be changing to
access XP very soon?

BTW is there any fix for the GPF problem, or should I go back to using the
ODBC 2.5 legacy driver?

Thanks again,

Ben

>From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
>To: Ben Trewern <ben_trewern(at)hotmail(dot)com>
>CC: pgsql-odbc(at)postgresql(dot)org
>Subject: Re: [ODBC] Access 97 and pgsqlodbc version 7.03.0100
>Date: Tue, 20 May 2003 09:50:28 +0900
>
>Please remove spaces from the column name.
>
>Ben Trewern wrote:
> >
> > There are two separate problems I am having -
> >
> > 1. You can connect any table in Access 97 and use it in that session
>but if
> > you close the database (mdb file) and open it again you get a GPF on
>opening
> > the table.
> >
> > It seems to happen with which ever table I open. I think it must be a
> > problem with the ODBC 3 driver because I didn't have this problem before
> > upgrading.
> >
> > 2. This problem is more interesting:
> >
> > I have a table similar to :
> >
> > CREATE TABLE public.subs (
> > subcontractorid varchar(10),
> > "payment number blue" int2,
> > description text
> > );
> >
> > I link it into Access 97 and open the table. It opens correctly, but
>after
> > approx 8 seconds all the data turns to #Name? . I've looked at the
> > mylog_xxx.log file and have found the following:
> >
> > [3704]send_query(): conn=42153888, query='SELECT
>"subcontractorid","payment
> > '#S_C_H#' blue","description1","xmin" FROM "public"."subs2" WHERE
> > "subcontractorid" = 'ARB' OR "subcontractorid" = 'ARCMOR' OR
> > "subcontractorid" = 'ARROW' OR "subcontractorid" = 'ASBESTEC' OR
> > "subcontractorid" = 'ASH' OR "subcontractorid" = 'ashbrook' OR
> > "subcontractorid" = 'ASHCROFT' OR "subcontractorid" = 'ASPHALTIC' OR
> > "subcontractorid" = 'ASSOCIATED' OR "subcontractorid" = 'ATLAS''
> >
> > as you can see "payment number blue" has been replaced by "payment
>'#S_C_H#'
> > blue" I assumed from this that the word 'number' was the problem so
>renamed
> > the field "pay no blue" but I still get the problem.
> >
> > Any Ideas?
> >
> > BTW I am using Postgres 7.3.2 on Mandrake linux 8.1, Windows XP sp1,
>Access
> > 97 sr2
>
>regards,
>Hiroshi Inoue
> http://www.geocities.jp/inocchichichi/psqlodbc/
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html

_________________________________________________________________
Find a cheaper internet access deal - choose one to suit you.
http://www.msn.co.uk/internetaccess