Re: BEST odbc driver for windows MS Access

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(at)hydrosphere(dot)com

Visit our web site!
http://www.hydrosphere.com