Re: ODBC driver adding extra characters to table names. - Mailing list pgsql-odbc

From Hiroshi Saito
Subject Re: ODBC driver adding extra characters to table names.
Date
Msg-id 005801c7dfe7$f291cf70$c601a8c0@HP22720319231
Whole thread Raw
In response to ODBC driver adding extra characters to table names.  (Paul Lambert <paul.lambert@autoledgers.com.au>)
List pgsql-odbc
Hi.

From: "Paul Lambert" <paul.lambert@autoledgers.com.au>

> Steps to reproduce:
> 0) Make sure standard_conforming_strings is turned ON and pg has been
> restarted.
> 1) Open up MS Access (2000 and 2003 both give me the problem)
> 2) Go to tables section, right click and select link table.
> 3) Find your ODBC data source.
> 4) Select public.billing_code from the list of tables.
> 5) Error is presented at that stage (don't even get to the point of
> writting a select query)
>
> I can attach the full mylog if you so wish - I haven't put it on yet
> because the log created from just that one query is around 800K so I'm
> leaving it off unless it's specifically requested.

I pointed out the problem of TEXT-field involving this. Furthermore, your
problem was in others again... Do you use FAKEOIDINDEX?
Probably, Turning it OFF may help.

However, It is necessary to continue TEXT-Field problem.

Regards,
Hiroshi Saito


pgsql-odbc by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: UPDATE with data at exec and CURRENT OF question
Next
From: Lothar Behrens
Date:
Subject: Re: UPDATE with data at exec and CURRENT OF question