psqlODBC/MSAcess How-To ?

Hi List !

I had found something on the web (can't remember if it was a web
site or a forum post) about configuring PostgreSQL and the
psqlODBC driver to work with MSAccess as a frontend.
I remember seeing functions that replaced the original PostgreSQL
functions that could deal with boolean / integer comparison, so
that one could use Access' boolean type nromally.

Could anyone point me to this page, or to something similar ?
Thanks a lot !

--
Arnaud



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: psqlODBC/MSAcess How-To ?

This is a multi-part message in MIME format.

------_=_NextPart_001_01C64F58.0BD15251
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

This link is the SQL code for the Access comparisons. I can't find the
link for where I found this link though.
http://docman.sourceforge.net/home_html/projects/sql/access_ fix.sql
=20
Erika M.
=20
=20

------_=_NextPart_001_01C64F58.0BD15251
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable



charset=3Dus-ascii">

Re: psqlODBC/MSAcess How-To ?

Erika Marlow a =E9crit :
> This link is the SQL code for the Access comparisons. I can't find the
> link for where I found this link though.
> http://docman.sourceforge.net/home_html/projects/sql/access_ fix.sql

Thanks Erika, this is exactly what I was looking for !
It is strange that this doc explains taht :
-- you will need this function if you are using row versioning
-- according to
http://odbc.postgresql.org/psqlodbc.php?DocID=3Dfaq-advanced #rowversionin=
g=20

you might not need it at all...

I could not find the fact, but what is the author talking about ?
Is this needed or not ?

--
Arnaud



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

Re: psqlODBC/MSAcess How-To ?

Erika M a =E9crit :
> This link is the SQL code for the Access comparisons. I can't find=20
> the link for where I found this link though.
> http://docman.sourceforge.net/home_html/projects/sql/access_ fix.sql


Thanks Erika, this is exactly what I was looking for !
It is strange that this doc explains taht :
-- you will need this function if you are using row versioning
-- according to
http://odbc.postgresql.org/psqlodbc.php?DocID=3Dfaq-advanced #rowversioning
you might not need it at all...

I could not find the fact, but what is the author talking about ?=20
Is this needed or not ?

--
Arnaud=20

Arnaud:
I believe it is referring to the FAQ that was moved here:
http://gborg.postgresql.org/project/psqlodbc/faq/faq.php

This link indicates that the missing operator may not have been added in ve=
rsion 6.4 as the answer to the question indicates. I haven't checked it wi=
th the most current version of the driver.
http://archives.postgresql.org/pgsql-interfaces/2000-09/msg0 0022.php

Erika M.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster