pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedAccess 2000
10+ messages / 5 participants
[nested] [flat]
* Access 2000
@ 1999-08-23 15:38 Michael Doyle <relyod@co-operation-ireland.ie>
0 siblings, 3 replies; 10+ messages in thread
From: Michael Doyle @ 1999-08-23 15:38 UTC (permalink / raw)
To: pgsql-interfaces
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 ?
<>< ============================================================ ><>
Michael Doyle email: relyod@co-operation-ireland.ie
Network Administrator personal email: relyod@indigo.ie
Co-operation Ireland http://www.co-operation-ireland.ie/
Phone: +353-1-661 0588 Fax: +353-1-661 8456
*********************************************************************
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] Access 2000
@ 1999-08-23 16:16 Byron Nikolaidis <byronn@solipsys.com>
parent: Michael Doyle <relyod@co-operation-ireland.ie>
2 siblings, 0 replies; 10+ messages in thread
From: Byron Nikolaidis @ 1999-08-23 16:16 UTC (permalink / raw)
To: Michael Doyle <relyod@co-operation-ireland.ie>; +Cc: pgsql-interfaces
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?
Byron
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] Access 2000
@ 1999-08-23 16:28 Moray McConnachie <Moray.McConnachie@computing-services.oxford.ac.uk>
parent: Michael Doyle <relyod@co-operation-ireland.ie>
2 siblings, 2 replies; 10+ messages in thread
From: Moray McConnachie @ 1999-08-23 16:28 UTC (permalink / raw)
To: Byron Nikolaidis <byronn@solipsys.com>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] Access 2000
@ 1999-08-23 16:43 Byron Nikolaidis <byronn@solipsys.com>
parent: Moray McConnachie <Moray.McConnachie@computing-services.oxford.ac.uk>
1 sibling, 2 replies; 10+ messages in thread
From: Byron Nikolaidis @ 1999-08-23 16:43 UTC (permalink / raw)
To: Moray McConnachie <Moray.McConnachie@computing-services.oxford.ac.uk>; +Cc: pgsql-interfaces
Moray McConnachie wrote:
> 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
It figures. Unfortunately, I really don't have the money to go out and buy
Access 2000, just to try and figure out what's different.
The real problem is that the ODBC spec is so overloaded and fat. Its verbose,
and yet there are so many variations for getting at data, that it is actually
very difficult to make sure that every possible contingency is correct in the
driver.
And that was just odbc version 2.x. ODBC Version 3.x is a real heart-warmer!
And I can't wait to see what version 4.x might bring!!! Of course, they all
have to be backward-compatible with odbc version 1.0 ;)
Byron
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] Access 2000
@ 1999-08-23 17:29 Michael Doyle <relyod@co-operation-ireland.ie>
parent: Michael Doyle <relyod@co-operation-ireland.ie>
2 siblings, 1 reply; 10+ messages in thread
From: Michael Doyle @ 1999-08-23 17:29 UTC (permalink / raw)
To: Byron Nikolaidis <byronn@solipsys.com>; +Cc: pgsql-interfaces
At 12:16 23/08/99 -0400, Byron Nikolaidis wrote:
>
>Do you see any error messages, either on screen or in any of the logfiles?
>
>Byron
Byron,
In the log files I see access issues the following:
query 'SELECT Config, nValue from MSysConf'
to which the server responds
'ERROR: msysconf: Table does not exist.'
In other words, Access seems to be looking for a configuration table
which PostgreSQL does not have. When it can't find it, Access then
refuses to do any more.
The strange thing is that access will import, but not display the contents
of the table.
Mike
<>< ============================================================ ><>
Michael Doyle email: relyod@co-operation-ireland.ie
Network Administrator personal email: relyod@indigo.ie
Co-operation Ireland http://www.co-operation-ireland.ie/
Phone: +353-1-661 0588 Fax: +353-1-661 8456
*********************************************************************
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] Access 2000
@ 1999-08-23 17:33 Michael Doyle <relyod@co-operation-ireland.ie>
parent: Moray McConnachie <Moray.McConnachie@computing-services.oxford.ac.uk>
1 sibling, 0 replies; 10+ messages in thread
From: Michael Doyle @ 1999-08-23 17:33 UTC (permalink / raw)
To: Byron Nikolaidis <byronn@solipsys.com>; Moray McConnachie <Moray.McConnachie@computing-services.oxford.ac.uk>; +Cc: pgsql-interfaces
In my case, a useable (but pain in the nexk) work around seems to be to
create a database in Access95 linked to the appropriate table
and then "import" that database to Access 2000
This allows Access 2000 to view/update records.
It's still an ugly kludge.
<>< ============================================================ ><>
Michael Doyle email: relyod@co-operation-ireland.ie
Network Administrator personal email: relyod@indigo.ie
Co-operation Ireland http://www.co-operation-ireland.ie/
Phone: +353-1-661 0588 Fax: +353-1-661 8456
*********************************************************************
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] Access 2000
@ 1999-08-23 17:34 Byron Nikolaidis <byronn@solipsys.com>
parent: Michael Doyle <relyod@co-operation-ireland.ie>
0 siblings, 0 replies; 10+ messages in thread
From: Byron Nikolaidis @ 1999-08-23 17:34 UTC (permalink / raw)
To: Michael Doyle <relyod@co-operation-ireland.ie>; +Cc: pgsql-interfaces
Michael Doyle wrote:
> At 12:16 23/08/99 -0400, Byron Nikolaidis wrote:
> >
> >Do you see any error messages, either on screen or in any of the logfiles?
> >
> >Byron
>
> Byron,
>
> In the log files I see access issues the following:
> query 'SELECT Config, nValue from MSysConf'
>
> to which the server responds
> 'ERROR: msysconf: Table does not exist.'
>
> In other words, Access seems to be looking for a configuration table
> which PostgreSQL does not have. When it can't find it, Access then
> refuses to do any more.
>
This is normal and has always been there. It is an optional file to configure
some things in Access.
Can you attach both the psqlodbc.log and sql.log files? There might be a
subtle thing in how it gets the tables.
Byron
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: [INTERFACES] Access 2000
@ 1999-08-25 18:00 Hiroki Kataoka <kataoka@interwiz.koganei.tokyo.jp>
parent: Byron Nikolaidis <byronn@solipsys.com>
1 sibling, 0 replies; 10+ messages in thread
From: Hiroki Kataoka @ 1999-08-25 18:00 UTC (permalink / raw)
To: pgsql-interfaces
I have a solution of this Access2000 problem. This was reported by J.Baba,
he is member of japanese PostgreSQL ML.
Byron Nikolaidis wrote:
>
> Moray McConnachie wrote:
>
> > 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
>
> It figures. Unfortunately, I really don't have the money to go
> out and buy
> Access 2000, just to try and figure out what's different.
(snip)
If SQL_ORDER_BY_COLUMNS_IN_SELECT is "Y" in SQLGetInfo, then Access2000 fail
to link ODBC tables. For verification, I modified PsqlODBC source, compiled
it, and tried to use with Access2000. This try has been done successfully.
% diff info.c.orig info.c
421c421
< p = "Y";
---
> p = (PROTOCOL_62(ci) || PROTOCOL_63(ci)) ? "Y" : "N";
This solution was got by comparison of SQL.LOG between some ODBC
drivers(ORACLE, Informix, MSSQL and PsqlODBC). There is no other grounds. I
don't know why this is good.
=====
Hiroki Kataoka
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: [INTERFACES] Access 2000
@ 1999-08-26 09:36 Moray McConnachie <Moray.McConnachie@computing-services.oxford.ac.uk>
parent: Byron Nikolaidis <byronn@solipsys.com>
1 sibling, 0 replies; 10+ messages in thread
From: Moray McConnachie @ 1999-08-26 09:36 UTC (permalink / raw)
To: Hiroki Kataoka <kataoka@interwiz.koganei.tokyo.jp>; +Cc: pgsql-interfaces
This is great. Unfortunately I don't do any compiling work
on the Win platform - could someone send me a recompiled
version of the relevant dll, by any chance?
Alternatively, I note that someone mentioned ODBC driver
6.40.00007 (or whatever) - does anyone know
a) where I can get this
b) if it includes the tweak for Access
Thanks,
Moray
> If SQL_ORDER_BY_COLUMNS_IN_SELECT is "Y" in SQLGetInfo, then Access2000 fail
> to link ODBC tables. For verification, I modified PsqlODBC source, compiled
> it, and tried to use with Access2000. This try has been done successfully.
>
> % diff info.c.orig info.c
> 421c421
> < p = "Y";
> ---
> > p = (PROTOCOL_62(ci) || PROTOCOL_63(ci)) ? "Y" : "N";
>
> This solution was got by comparison of SQL.LOG between some ODBC
> drivers(ORACLE, Informix, MSSQL and PsqlODBC). There is no other grounds. I
> don't know why this is good.
>
> =====
> Hiroki Kataoka
>
----------------------
Moray.McConnachie@computing-services.oxford.ac.uk
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] Access 2000
@ 1999-08-27 19:52 laszlo_acs_at_cms08405@ccmailgw.state.il.us
0 siblings, 0 replies; 10+ messages in thread
From: laszlo_acs_at_cms08405@ccmailgw.state.il.us @ 1999-08-27 19:52 UTC (permalink / raw)
To: pgsql-interfaces
I happened to mention a similar occurence to our 'local' Microsoft (hereinafter
referred to as M$) representative at a seminar yesterday (B.O.) and his take on
the issue is not ODBC, rather the culprit is due to the internal rewrite that's
gone into M$ Access 2000. His reply went something like this:
M$ Access 2000 is now unicode-aware and requires MDAC 2.1 or higher - unlike M$
Access 97, the only M$ Office product not unicoded in the 97 release. Because
of the unicode (which is a two-byte character encoding scheme - see
http://msdn.microsoft.com/library/officedev/off2000/defunicode.htm for a
definition) implementation, older Access databases must be 'imported' and
updated - BUT this updating process does not update the ODBC driver to recognize
the 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 this response, I assume M$ is aware of the issue. At least the rep
seems to be. It would be nice to know if there is something 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 >
>
>************
>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~1999-08-27 19:52 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-23 15:38 Access 2000 Michael Doyle <relyod@co-operation-ireland.ie>
1999-08-23 16:16 ` Byron Nikolaidis <byronn@solipsys.com>
1999-08-23 16:28 ` Moray McConnachie <Moray.McConnachie@computing-services.oxford.ac.uk>
1999-08-23 16:43 ` Byron Nikolaidis <byronn@solipsys.com>
1999-08-25 18:00 ` Hiroki Kataoka <kataoka@interwiz.koganei.tokyo.jp>
1999-08-26 09:36 ` Moray McConnachie <Moray.McConnachie@computing-services.oxford.ac.uk>
1999-08-23 17:33 ` Michael Doyle <relyod@co-operation-ireland.ie>
1999-08-23 17:29 ` Michael Doyle <relyod@co-operation-ireland.ie>
1999-08-23 17:34 ` Byron Nikolaidis <byronn@solipsys.com>
1999-08-27 19:52 Re: [INTERFACES] Access 2000 laszlo_acs_at_cms08405@ccmailgw.state.il.us
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox