Обсуждение: 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
This link is the SQL code for the Access comparisons. I can't find the link for where I found this link though.
Erika M.
Erika Marlow a écrit : > 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=faq-advanced#rowversioning 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
Erika M a écrit : > 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=faq-advanced#rowversioning 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 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 version 6.4 as the answer to the question indicates. I haven't checked it with the most current version of the driver. http://archives.postgresql.org/pgsql-interfaces/2000-09/msg00022.php Erika M.