Re: BEST odbc driver for windows MS Access - Mailing list pgsql-odbc

I posted my question at utteraccess.com and was directed to this link as the best odbc driver for postgres

http://pgfoundry.org/projects/psqlodbc/

I am wondering how it differs (or if it differs) from the odbc which was installed automatically when I installed pgsql.

That link leads to this link for Window

http://pgfoundry.org/softwaremap/trove_list.php?form_cat=216

The page at the first mentioned link ALSO least to this page

http://www.postgresql.org/ftp/odbc/versions/

and it is at THIS LINK that I find great confusion as to WHICH ODBC driver I should be downloading for my DELL Windows XP

since it says

PARENT DIRECTORY

DLL

MM

MSI

OLD

SRC

And the DLL link shows a myriad of zipped choices for download, at the top of the list being

psqlodbc-07_01_0007.zip

SO, if anyone has any guidance in this matter, I would be most grateful

Thanks!

I am not yet using Access as a front end to pgsql, but it is something I would like to get set up in the future, and I AM in the very early stages of developing an application which has an Excel front end to pgsql, and the data connection issues here may be very similar.  I am currently comparing the use of ODBC vs. OLEDB (with ADO in VBA) to connect to pgsql and pull data in.  I think OLEDB will be faster and more stable...IF a good OLEDB driver for pgsql exists, that is.  And if not, will I have to go thru MSQuery to get to pgsql via ODBC?  I hope not...

So I don't have an answer for Karabac, but I'll looking at the same questions and I'll post what I find.  And if anyone has thoughts or experience on OLEDB vs. ODBC for connecting to pgsql from Microsoft software, I'd love to hear of them!

~Kelly

Karebac wrote:

I installed pgsql yesterday on my windows xp.  I was under the impression that I needed to also download and install a specific odbc driver so that MS Access could link to pgsql tables.   Someone explained to me that an ODBC automatically installs now, when I install pgsql.  Sure enough, they were right. I was able to find an ODBC driver and link MS Access to pgsql.

My question is this:  Is that default odbc driver, which installs with pgsql the best one to use for MS Access?   I notice that there are a confusing array of odbc drivers to download.   What is the difference between all of them. How can one decide which is best for a particular purpose, such as MS Access.

Do many of you use MS Access as a front end to pgsql?

Thanks!

No virus found in this outgoing message.

Checked by AVG Free Edition.

Version: 7.1.409 / Virus Database: 268.15.15/580 - Release Date: 12/8/2006

---------------------------(end of broadcast)---------------------------

TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

-- 

**************************************

Kelly Close

Database and GIS Specialist

Hydrosphere Resource Consultants, Inc

(303) 443-7839

(303) 442-0616 (fax)

kkc@hydrosphere.com

Visit our web site!

http://www.hydrosphere.com