Re[2]: [INTERFACES] Access 2000
От | laszlo_acs_at_cms08405@ccmailgw.state.il.us |
---|---|
Тема | Re[2]: [INTERFACES] Access 2000 |
Дата | |
Msg-id | 9908279357.AA935772130@ccmailgw.state.il.us обсуждение исходный текст |
Список | pgsql-interfaces |
I happened to mention a similar occurence to our 'local' Microsoft (hereinafter referred to as M$) representativeat a seminar yesterday (B.O.) and his take on the issue is not ODBC, rather the culprit is due to theinternal rewrite that's gone into M$ Access 2000. His reply went something like this: M$ Access 2000 is nowunicode-aware and requires MDAC 2.1 or higher - unlike M$ Access 97, the only M$ Office product not unicoded in the97 release. Because of the unicode (which is a two-byte character encoding scheme - see http://msdn.microsoft.com/library/officedev/off2000/defunicode.htmfor a definition) implementation, older Access databasesmust be 'imported' and updated - BUT this updating process does not update the ODBC driver to recognizethe fact that the linked tables are not unicode-aware (i.e. a postgreSQL database) and therefore data in those tables can't be modified since there is no provision for this scenario in M$ sourcecode. Based on thisresponse, I assume M$ is aware of the issue. At least the rep seems to be. It would be nice to know if there issomething to come of this and similar issues concerning updating and moving forward. Humbly, Laszlo ______________________________ Reply Separator _________________________________ Subject: Re: [INTERFACES] Access 2000 Author: Robert Hiltibidal <rob@y2k.state.il.us> at INTERNET Date: 8/23/99 2:29 PM So... all problems are solved with Office 2000? -Rob >X-POP3-Rcpt: rob@y2k >From: Moray McConnachie <Moray.McConnachie@computing-services.oxford.ac.uk> >Date: Mon, 23 Aug 1999 17:28:59 +0100 >To: Byron Nikolaidis <byronn@solipsys.com> >Subject: Re: [INTERFACES] Access 2000 >Cc: pgsql-interfaces@postgreSQL.org >X-Mailer: Execmail for Win32 Version 5.0.1 Build (55) >Sender: owner-pgsql-interfaces@postgreSQL.org > >On Mon, 23 Aug 1999 12:16:38 -0400 Byron Nikolaidis ><byronn@solipsys.com> wrote: > >> >> >> Michael Doyle wrote: >> >> > I need help with Access 2000 and PostgreSQL... >> > >> > I have several databases running on my server (It's a FreeBSD server >> > running Postgress 6.4) and Access 95 had no trouble acting as a >> > front end to these databases >> > >> > However, I cannot create new Access 2000 databases to see either new >> > or old databases on the server. >> > >> > Curiously, upgrading the Access 95 databases to Access 2000 lets them >> > continue to see the linked tables. >> > >> > Something strange is going on with Access 2000 and ODBC interfaces. >> > Any ideas on how to resolve this ? >> > >> >> Do you see any error messages, either on screen or in any of the logfiles? > >Michael's problem is basically the same as I posted a few >weeks back, and others have contacted me about it since. It >appears to leave no error messages, but frankly I've given >up and have no longer been looking. > >Some have said that all 3rd party ODBC drivers have had to >be rewritten to co-operate with Access 2000's >implementatation of ODBC, which is hardly brilliant! > >I put in a bug report to Microsoft, but so far no response. > >---------------------- >Moray.McConnachie@computing-services.oxford.ac.uk > > >************ > >
В списке pgsql-interfaces по дате отправления: