Обсуждение: v7 and ODBC Readonly
I recently upgraded from v6 to v7. I have to get to data in three databases by using three different MS Access databases and the ODBC driver. Since the upgrade, two of the three databases will no longer let me add/edit records saying the database is not updateable.
Looking at the pgsql innards, one thing that stands out about the db that still lets me update is the fact that the Access Permissions from a \z command are all blank. The other two dbs that don't let me update have Permissions like {"=","webuser=arwR"} where I had set the user access because the db owner was different.
This is only a problem with the ODBC driver as php is still adding/editing records just fine. Any ideas? Thanks!
________________________
Greg Kelley, IT Director
Londavia, Inc.
Pease Int'l Tradeport
68 New Hampshire Ave.
Portsmouth, NH 03801
603.766.3005
http://www.londavia.com
SSA, EAA, AOPA, N5506M
Greg Kelley, IT Director
Londavia, Inc.
Pease Int'l Tradeport
68 New Hampshire Ave.
Portsmouth, NH 03801
603.766.3005
http://www.londavia.com
SSA, EAA, AOPA, N5506M
At 12:48 2000-10-20 -0400, Greg Kelley wrote: >I recently upgraded from v6 to v7. I have to get to data in three databases by using three different MS Access databasesand the ODBC driver. Since the upgrade, two of the three databases will no longer let me add/edit records sayingthe database is not updateable. Do you have read-only disabled in the Datasource-definition? Control-Panel -- ODBC -- <select your datasources there> --configure -- Options(advanced): both, Driver and DataSource have a checkbox denying write access per default HTH, Stefan
Before I start posting the S.O.S. (on a different day), can someone please share with me the location of the archives for the admin group? I checked the obvious places. thx, dk -- dks@spies.com | Perception is nine tenths of the law.
See under General Info in the User Lounge ...
On Tue, 24 Oct 2000, dk smith wrote:
> Before I start posting the S.O.S. (on a different day), can someone please
> share with me the location of the archives for the admin group? I checked
> the obvious places.
>
> thx,
> dk
> --
> dks@spies.com | Perception is nine tenths of the law.
>
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org