From: | "Karebac" <karebac(at)verizon(dot)net> |
---|---|
To: | <kkc(at)hydrosphere(dot)com> |
Cc: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: BEST odbc driver for windows MS Access |
Date: | 2006-12-11 01:02:33 |
Message-ID: | 0JA300KDB489M3W7@vms042.mailsrvcs.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
<http://wwwmaster.postgresql.org/download/mirrors-ftp?file=odbc%2Fversions%2
Fdll%2Fpsqlodbc-07_01_0007.zip>
SO, if anyone has any guidance in this matter, I would be most grateful
Thanks!
_____
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of K. Kelly Close
Sent: Sunday, December 10, 2006 2:02 PM
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] 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
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/plain | 145 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2006-12-11 02:20:34 | Re: BEST odbc driver for windows MS Access |
Previous Message | Hiroshi Inoue | 2006-12-11 00:57:05 | Re: SQLSetPos problem ? |