Strange ODBC behavior.

Поиск
Список
Период
Сортировка
Искать
От
Paul Lambert
Тема
Strange ODBC behavior.
Дата
Msg-id
46B288AF.60907@autoledgers.com.au
Список
Дерево обсуждения
Strange ODBC behavior. Paul Lambert <paul.lambert@autoledgers.com.au>
Re: Strange ODBC behavior. Paul Lambert <paul.lambert@autoledgers.com.au>
Re: Strange ODBC behavior. Adrian Klaver <aklaver@comcast.net>
Re: Strange ODBC behavior. Andrei Kovalevski <andyk@commandprompt.com>
Re: Strange ODBC behavior. Paul Lambert <paul.lambert@autoledgers.com.au>
Re: Strange ODBC behavior. Adrian Klaver <aklaver@comcast.net>
Re: Strange ODBC behavior. Paul Lambert <paul.lambert@autoledgers.com.au>
Re: Strange ODBC behavior. Paul Lambert <paul.lambert@autoledgers.com.au>
I had a server have a power outage on one of my PostgreSQL servers 
yesterday and am having a strange ODBC issue now - not sure if they are 
related occurances though.

I have a table called billing_code and one called models in my database. 
If I connect via psql to the database with my standard db user I can see 
both of these tables as well as the data contained within.

If I attempt to link these tables from MS Access, the billing_code one 
returns "The Microsoft Jet database engine could not find the object 
'public.billing_code'. Make sure the object exists and that you spell 
its name and the path name correctly" - this error despite the fact that 
I had to physically select the table from a list it presented me when I 
went into the linked table manager.

If I link the models table, it links fine, but when I attempt to open 
it, I just get #Deleted in every column of every row for about 54,000 
rows (the total number in the table)

The same problem happens with some of the other tables in the database - 
some will get the first problem, some will get the second problem, and 
some will link and load data without issue.

I was running odbc driver 8.02.02, I've upgraded to 8.02.04 - just in 
case there was a problem with the driver getting corrupted but the 
problem persists.

Can anyone offer any thoughts or suggestions on what the problem might be?

Thanks in advance,
Paul.

-- 
Paul Lambert
Database Administrator
AutoLedgers

В списке pgsql-odbc по дате отправления
От: Dmitry Samokhin
Дата:
От: Paul Lambert
Дата:
Сообщение: Re: Strange ODBC behavior.
FAQ