Skip site navigation (1) Skip section navigation (2)

Re: psqlodbc-08_00_0101 does not work with Ms Access

From: "Jonathan Lam" <lamj(at)spawar(dot)navy(dot)mil>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: psqlodbc-08_00_0101 does not work with Ms Access
Date: 2005-07-25 18:57:37
Message-ID: 003d01c5914a$c0609650$29903180@Seal11 (view raw or flat)
Thread:
Lists: pgsql-odbc
unsubscribe

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Zlatko Matiæ
Sent: Monday, July 25, 2005 11:42 AM
To: Christof Thalhofer; pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] psqlodbc-08_00_0101 does not work with Ms Access

As I said I'm not an expert...
I wish you to solve your problem on the best possible way.
In my case adding of new colums with bigserial fields as primary keys solved 
it. Andreas mentioned that it is not good to use bigserial but just serial, 
so I will change it now to serial.
Good luck,

Zlatko

----- Original Message ----- 
From: "Christof Thalhofer" <devnull(at)deganius(dot)de>
To: <pgsql-odbc(at)postgresql(dot)org>
Sent: Sunday, July 24, 2005 11:28 PM
Subject: Re: [ODBC] psqlodbc-08_00_0101 does not work with Ms Access


> Hi Zlatko,
>
> thank you for your reply.
>
>>  I'm not an expert, but I experienced the same troubles with MS
>> Access/Postgres in the past, so I think I can help you.
>> I also experienced the trouble with deinstalation of ODBC driver
>> 08_00_0101 and thought that previous versions of drivers are better...
>> Well, it is not true! You will experience the same  "#Deleted" with
>> older versions of ODBC driver, just leave Access connected to Postgres
>> for two hours...
>
> we have a couple of Access-Applications running against a 8.03 Postgresql-
> DB. With the old ODBC driver they stay connected the whole day long 
> without
> any problems. We also use in some tables varchar(x) primary keys and in
> some other tables primary keys combined of several columns. Without any
> problems for years and with Postgresql 8.xx for months now!
>
> So I stay with my opinion: there are problems with the newer 8.. ODBC
> drivers and Access, which do not occur in older versions, as I described 
> in
> my former posting.
>
> Alles Gute,
>
> Christof
> (Für Mail "devnull" in meinen Vornamen ändern.)
>
> -- 
> oans zwoa drei fia
> #/&wrx§fs$%pff3örx4656tspf&äx=#%xkr§o&(w53x4bl=äh)$˛˛˛˛ł%
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>       message can get through to the mailing list cleanly 


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend



In response to

pgsql-odbc by date

Next:From: Joel FradkinDate: 2005-07-25 20:01:08
Subject: WHat do people think about using in production?
Previous:From: Zlatko MatićDate: 2005-07-25 18:41:39
Subject: Re: psqlodbc-08_00_0101 does not work with Ms Access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group