Re: ODBC driver adding extra characters to table names.

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