Re: BEST odbc driver for windows MS Access

--=======AVGMAIL-457BFC013D09=======
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0028_01C71C2B.F0AE1360"


------=_NextPart_000_0028_01C71C2B.F0AE1360
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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!


------=_NextPart_000_0028_01C71C2B.F0AE1360
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

hemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org/TR/REC-html40">

Re: BEST odbc driver for windows MS Access

This is a multi-part message in MIME format.
--------------040404060800000509000500
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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


--------------040404060800000509000500
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit







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:

style="font-size: 10pt; font-family: Arial;">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.

style="font-size: 10pt; font-family: Arial;"> 

style="font-size: 10pt; font-family: Arial;">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.

style="font-size: 10pt; font-family: Arial;"> 

style="font-size: 10pt; font-family: Arial;">Do many of you use MS
Access as a front end to pgsql?

style="font-size: 10pt; font-family: Arial;"> 

style="font-size: 10pt; font-family: Arial;">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



                

  

-- 

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

Kelly Close

Database and GIS Specialist

Hydrosphere Resource Consultants, Inc

(303) 443-7839

(303) 442-0616 (fax)





Visit our web site!

Re: BEST odbc driver for windows MS Access

--=======AVGMAIL-457CAE2A20EC=======
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0043_01C71C96.21B74700"


------=_NextPart_000_0043_01C71C96.21B74700
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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
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@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of K. Kelly Close
Sent: Sunday, December 10, 2006 2:02 PM
Cc: pgsql-odbc@postgresql.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@hydrosphere.com

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

------=_NextPart_000_0043_01C71C96.21B74700
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://ww=
w.w3.org/TR/REC-html40">




namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"City"/>
name=3D"place"/>

style=3D'font-size:10.0pt'> 

=


style=3D'font-size:10.0pt'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>No virus found in this outgoing message.

size=3D2 color=3Dblack face=3D"Courier New">
'>Version: 7.1.409 / Virus Database: 268.15.15/580 - Release Date: 12/8/200=

6

size=3D2 color=3Dblack face=3D"Courier New">
'>  

r'>
size=3D2 color=3Dblack face=3D"Courier New">
'>

=


style=3D'font-size:10.0pt'> 

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>---------------------------(end of broadcast)---------------------------<=

o:p>

size=3D2 color=3Dblack face=3D"Courier New">
'>TIP 7: You can help support the PostgreSQL project by donating at
:p>

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>            &=

nbsp;   
href=3D"http://www.postgresql.org/about/donate">http://www.postgresql.org/a=

bout/donate

size=3D2 color=3Dblack face=3D"Courier New">
'>  

size:10.0pt'>-- 

size=3D2 color=3Dblack face=3D"Courier New">
'>**************************************

size=3D2 color=3Dblack face=3D"Courier New">
'>Database and GIS Specialist

size=3D2 color=3Dblack face=3D"Courier New">
'>Hydrosphere Resource Consultants, Inc

=


size=3D2 color=3Dblack face=3D"Courier New">
'>(303) 443-7839

size=3D2 color=3Dblack face=3D"Courier New">
'>(303) 442-0616 (fax)

size=3D2 color=3Dblack face=3D"Courier New">
'>
href=3D"mailto:kkc@hydrosphere.com">kkc@hydrosphere.com
n>

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>Visit our web site!

size=3D2 color=3Dblack face=3D"Courier New">
'>
href=3D"http://www.hydrosphere.com">http://www.hydrosphere.com
p>

Re: BEST odbc driver for windows MS Access

> PARENT DIRECTORY
> DLL=20
> MM=20
> MSI
> OLD=20
> SRC

Each of the above directories are giving you the option has to how you wo=
uld like to have your
ODBC driver installed.

DLL -- probably give you only the dll files. You will have to manual inst=
all them and register in
the windows resistry your self. MM -- not to sure what it is for. MSI -=
- give you the odbc
drivers in a format that will install themselves after you execute the ms=
i file. OLD -- probably
old drivers kept for anyone that specifically needs the old drivers. SRC=
-- give you the sources
code from the odbc driver. This way you can compile it yourself and then=
install it into windows
yourself.

I expect you should just choose the MSI directory since it is the easiest=
method to install your
odbc drivers.

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

Pick the newest driver. it will be the driver with the largerst number.

Regards,

Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: BEST odbc driver for windows MS Access

> And if=20
> not, will I have to go thru MSQuery to get to pgsql via ODBC? I hope n=
ot...

I am not to sure how to answer your question. The functionality does MSQ=
query give you that you
get some other way with OLEDB.

> And if anyone has thoughts or=20
> experience on OLEDB vs. ODBC for connecting to pgsql from Microsoft=20
> software, I'd love to hear of them!

My opionion of OLEDB for postgresql is that it is broken and certainly no=
t more stable in this
case. Even worse, there doesn't seem to be much support for the oledb pr=
oject as compared with
the odbc projects. If you find that a bug keeps you from completing your=
project, there aren't
very many places to turn.

from the following link:

http://archives.postgresql.org/pgsql-odbc/2006-10/msg00009.p hp

you see that an old version of ODBC was able to handle a load of 600 tran=
sactions requests per
second. The Command Prompt odbc-ng appears to almost double this through=
put, however it breaks
when I try to use it. This should be expected since this driver is still=
released as being under
the "public test mode".

If you are enterested in using the odbc-ng driver you could use the follo=
wing mailing list for
help:

http://lists.commandprompt.com/mailman/listinfo/odbcng

Regards,

Richard Broersma jr.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: BEST odbc driver for windows MS Access

This is a multi-part message in MIME format.
--------------090807000007090108060803
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


>> And if
>> not, will I have to go thru MSQuery to get to pgsql via ODBC? I hope not...
>>
>
> I am not to sure how to answer your question. What functionality does MSQquery give you that you
> get some other way with OLEDB.
>
>
This is what I'm not actually sure of, but some more research I've done
tonight seems to indicate that the method I've used accessing an OLEDB
source entirely from within code (which is what I'm trying to do) may be
completely adaptable to an ODBC source.

Using SQL Server as an example, I can connect from Excel VBA using code
that looks something like this:
oConn.Open "Provider=sqloledb;Data Source=Aron1;Initial
Catalog=pubs;User Id=sa;Password=asdasd;"00)

I was hoping I could replace the "sqloledb" provider with the proper
reference for the postgresql oledb provider and have a working connection!

I now find that I can theoretically also connect to SQLServer thru ODBC
using a connection string in VBa that looks something like:
oConn.Open "Driver={SQL
Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"

So again, if I install the PostgreSQL ODBC driver and put it in there in
place of {SQL Server}, I should have a working connection I can pass SQL
thru from code...right? :-) That's what I'm going for anyway. I am
really just looking to do pretty simple querying and writing back to the
database with this. If ANYONE out there has any experience with this,
from any MS application using VBA, I would appreciate hearing from
them...and any references to other message lists are welcome too -
thanks for the pointer to the odbcng list, Richard.

~Kelly
>> 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!
>>
>
> My opionion of OLEDB for postgresql is that it is broken and certainly not more stable in this
> case. Even worse, there doesn't seem to be much support for the oledb project as compared with
> the odbc projects. If you find that a bug keeps you from completing your project, there aren't
> very many places to turn.
>
> from the following link:
>
> http://archives.postgresql.org/pgsql-odbc/2006-10/msg00009.p hp
>
> you see that an old version of ODBC was able to handle a load of 600 transactions requests per
> second. The Command Prompt odbc-ng appears to almost double this throughput, however it breaks
> when I try to use it. This should be expected since this driver is still released as being under
> the "public test mode".
>
> If you are enterested in using the odbc-ng driver you could use the following mailing list for
> help:
>
> http://lists.commandprompt.com/mailman/listinfo/odbcng
>
> Regards,
>
> Richard Broersma jr.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
**************************************
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


--------------090807000007090108060803
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

type="cite">

And if 

not, will I have to go thru MSQuery to get to pgsql via ODBC?  I hope not...

    

I am not to sure how to answer your question.  What functionality does MSQquery give you that you

get some other way with OLEDB.



  

type="cite">

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!

    

My opionion of OLEDB for postgresql is that it is broken and certainly not more stable in this

case.  Even worse, there doesn't seem to be much support for the oledb project as compared with

the odbc projects.  If you find that a bug keeps you from completing your project, there aren't

very many places to turn.



from the following link:







you see that an old version of ODBC was able to handle a load of 600 transactions requests per

second.  The Command Prompt odbc-ng appears to almost double this throughput, however it breaks

when I try to use it.  This should be expected since this driver is still released as being under

the "public test mode".



If you are enterested in using the odbc-ng driver you could use the following mailing list for

help:







Regards,



Richard Broersma jr.



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

TIP 4: Have you searched our list archives?



               

  

-- 

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

Kelly Close

Database and GIS Specialist

Hydrosphere Resource Consultants, Inc

(303) 443-7839

(303) 442-0616 (fax)





Visit our web site!

Re: BEST odbc driver for windows MS Access

--=======AVGMAIL-457CF1A42C8C=======
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0053_01C71CBE.5A665B90"


------=_NextPart_000_0053_01C71CBE.5A665B90
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

You could visit utteraccess.com and post at their subforum for posgressql
and mysql. It is a pretty active forum with lots of people knowledgable in
VBA and SQL.





_____

From: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of K. Kelly Close
Sent: Monday, December 11, 2006 12:45 AM
To: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] BEST odbc driver for windows MS Access







And if
not, will I have to go thru MSQuery to get to pgsql via ODBC? I hope not...



I am not to sure how to answer your question. What functionality does
MSQquery give you that you
get some other way with OLEDB.



This is what I'm not actually sure of, but some more research I've done
tonight seems to indicate that the method I've used accessing an OLEDB
source entirely from within code (which is what I'm trying to do) may be
completely adaptable to an ODBC source.

Using SQL Server as an example, I can connect from Excel VBA using code that
looks something like this:
oConn.Open "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User
Id=sa;Password=asdasd;"00)

I was hoping I could replace the "sqloledb" provider with the proper
reference for the postgresql oledb provider and have a working connection!

I now find that I can theoretically also connect to SQLServer thru ODBC
using a connection string in VBa that looks something like:
oConn.Open "Driver={SQL
Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"

So again, if I install the PostgreSQL ODBC driver and put it in there in
place of {SQL Server}, I should have a working connection I can pass SQL
thru from code...right? :-) That's what I'm going for anyway. I am really
just looking to do pretty simple querying and writing back to the database
with this. If ANYONE out there has any experience with this, from any MS
application using VBA, I would appreciate hearing from them...and any
references to other message lists are welcome too - thanks for the pointer
to the odbcng list, Richard.

~Kelly



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!



My opionion of OLEDB for postgresql is that it is broken and certainly not
more stable in this
case. Even worse, there doesn't seem to be much support for the oledb
project as compared with
the odbc projects. If you find that a bug keeps you from completing your
project, there aren't
very many places to turn.

from the following link:

http://archives.postgresql.org/pgsql-odbc/2006-10/msg00009.p hp

you see that an old version of ODBC was able to handle a load of 600
transactions requests per
second. The Command Prompt odbc-ng appears to almost double this
throughput, however it breaks
when I try to use it. This should be expected since this driver is still
released as being under
the "public test mode".

If you are enterested in using the odbc-ng driver you could use the
following mailing list for
help:

http://lists.commandprompt.com/mailman/listinfo/odbcng

Regards,

Richard Broersma jr.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org






--
**************************************
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

------=_NextPart_000_0053_01C71CBE.5A665B90
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

style=3D'font-size:10.0pt'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>I am not to sure how to answer your question.  What functionality do=

es MSQquery give you that you

size=3D2 color=3Dblack face=3D"Courier New">
'>get some other way with OLEDB.

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>  

style=3D'font-size:10.0pt'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>My opionion of OLEDB for postgresql is that it is broken and certainly no=

t more stable in this

size=3D2 color=3Dblack face=3D"Courier New">
'>case.  Even worse, there doesn't seem to be much support for the ole=

db project as compared with

size=3D2 color=3Dblack face=3D"Courier New">
'>the odbc projects.  If you find that a bug keeps you from completing=

 your project, there aren't

size=3D2 color=3Dblack face=3D"Courier New">
'>very many places to turn.

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>from the following link:

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>
href=3D"http://archives.postgresql.org/pgsql-odbc/2006-10/msg00009.php">htt=

p://archives.postgresql.org/pgsql-odbc/2006-10/msg00009.php<=

/span>

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>you see that an old version of ODBC was able to handle a load of 600 tran=

sactions requests per

size=3D2 color=3Dblack face=3D"Courier New">
'>second.  The Command Prompt odbc-ng appears to almost double this th=

roughput, however it breaks

size=3D2 color=3Dblack face=3D"Courier New">
'>when I try to use it.  This should be expected since this driver is =

still released as being under

size=3D2 color=3Dblack face=3D"Courier New">
'>the "public test mode".

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>If you are enterested in using the odbc-ng driver you could use the follo=

wing mailing list for

size=3D2 color=3Dblack face=3D"Courier New">
'>help:

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>
href=3D"http://lists.commandprompt.com/mailman/listinfo/odbcng">http://list=

s.commandprompt.com/mailman/listinfo/odbcng
re>

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>Regards,

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>Richard Broersma jr.

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>---------------------------(end of broadcast)---------------------------<=

o:p>

size=3D2 color=3Dblack face=3D"Courier New">
'>TIP 4: Have you searched our list archives?
>

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>            &=

nbsp;  
href=3D"http://archives.postgresql.org">http://archives.postgresql.org<=

o:p>

size=3D2 color=3Dblack face=3D"Courier New">
'>  




=


style=3D'font-size:12.0pt'>










size:10.0pt'>-- 

size=3D2 color=3Dblack face=3D"Courier New">
'>**************************************

>
size=3D2 color=3Dblack face=3D"Courier New">
'>Kelly Close

size=3D2 color=3Dblack face=3D"Courier New">
'>Database and GIS Specialist

size=3D2 color=3Dblack face=3D"Courier New">
'>Hydrosphere Resource Consultants, Inc
=


size=3D2 color=3Dblack face=3D"Courier New">
'>(303) 443-7839

size=3D2 color=3Dblack face=3D"Courier New">
'>(303) 442-0616 (fax)

size=3D2 color=3Dblack face=3D"Courier New">
'>
href=3D"mailto:kkc@hydrosphere.com">kkc@hydrosphere.com
n>

size=3D2 color=3Dblack face=3D"Courier New">
'> 

size=3D2 color=3Dblack face=3D"Courier New">
'>Visit our web site!

size=3D2 color=3Dblack face=3D"Courier New">
'>
href=3D"http://www.hydrosphere.com">http://www.hydrosphere.com
p>

Re: BEST odbc driver for windows MS Access

> If ANYONE out there has any experience with this,=20
> from any MS application using VBA, I would appreciate hearing from=20
> them...and any references to other message lists are welcome too -=20
> thanks for the pointer to the odbcng list, Richard.

If you install the MSI version of the driver, it will also install odbc h=
elp documentation in your
windows start menu. There is an example of how to connect using vb. Als=
o if you search the odbc
mailing list archieves you will find many other examples that show how to=
do this. There are some
important "lessons learned" about linking tables via ms-acces also docum=
ented in the archieves.

to search odbc list archieves check out the following link:
http://archives.postgresql.org/pgsql-odbc/

one of the many sample ado connection scripts:
http://archives.postgresql.org/pgsql-odbc/2006-11/msg00019.p hp

Here is one such bit of advice:
http://archives.postgresql.org/pgsql-odbc/2006-10/msg00022.p hp

Regards,
Richard Broersma Jr.

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

Re: BEST odbc driver for windows MS Access

> You could visit utteraccess.com and post at their subforum for posgress=
ql
> and mysql. It is a pretty active forum with lots of people knowledgabl=
e in
> VBA and SQL.

Thanks for the compliment with you refered to me as an "expert". :-)
http://www.utteraccess.com/forums/showflat.php?Board=3D36&Nu mber=3D131289=
9

But I am really just a novice on the list just like you are. Only I've h=
ad a little more time to
get familar with PG web site than you have.

If you want to see a list of the REAL experts check out:
http://www.postgresql.org/developer/bios

Do a "find" for "odbc" on that webpage and you will see the people that a=
ctually deserve that
compliment.

Regards,

Richard Broersma Jr.



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: BEST odbc driver for windows MS Access

..> > You could visit utteraccess.com and post at their subforum for posgr=
essql
> > and mysql. It is a pretty active forum with lots of people knowledga=
ble in
> > VBA and SQL.


You bring up valid points regarding the postgresql website about where it=
can be improved.=20
However, your suggestions can only be inacted if you report them to the c=
orrect people.

So regarding you consern about what MSI,DLL,MM,SRC, et.al acutally mean:
http://www.postgresql.org/ftp/odbc/versions/

and why the odbc driver are sorted in ascending vs descending order:
http://www.postgresql.org/ftp/odbc/versions/msi/

since your concerns address the display of the postgresql website, you sh=
ould post your concerns
to:
webmaster@postgresql.org

If this is the wrong person, they will know who to forward your conserns =
on to. At least this way
your concerns can be addressed by people who have the ablity to make chan=
ges.

When you post problems such as these on non-postgresql mailinglists you a=
re not doing yourself or
anyone else a favor.

Regards,

Richard Broersma Jr. =20


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

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

Re: BEST odbc driver for windows MS Access

Karebac wrote:
> 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.

It's the same code (might be a different version though). The pgFoundry
site is where the development work happens.
>
> That link leads to this link for Window
>
> http://pgfoundry.org/softwaremap/trove_list.php?form_cat=216
>

Not sure how you got there - some pgFoundry link I guess. Not one we've
published.

>
> The page at the first mentioned link ALSO least to this page
>
> http://www.postgresql.org/ftp/odbc/versions/
>

Yes, it says:

psqlODBC is the official PostgreSQL ODBC Driver. Downloads are available
on the PostgreSQL Mirror network at http://www.postgresql.org/ftp/odbc/

> 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
>
>
> PARENT DIRECTORY

I'm sure you can guess what that one is :-)

> DLL

Thats the driver distributed as a zip of the dll's - not recommended
unless you know what you're doing.

> MM

That's the driver distributed in a Windows Installer Merge Module, for
developers to include in their own installers.

> MSI

That's probably what you want - the standard Windows Installer MSI package.

> OLD

Old (well, archaic versions)

> SRC

Source code.

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

Yes - unless you specifically need an older version for some reason, get
the latest. No-one is likely to support the older ones, and the first
question you're likely to be asked is 'are you running the latest version'?

I'll add a readme to that directory on the FTP site though... thought
there was one already :-(

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: BEST odbc driver for windows MS Access

This is a multi-part message in MIME format.
--------------030708090302000203080105
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Very helpful, thanks!

~K.

Richard Broersma Jr wrote:
>> If ANYONE out there has any experience with this,
>> from any MS application using VBA, I would appreciate hearing from
>> them...and any references to other message lists are welcome too -
>> thanks for the pointer to the odbcng list, Richard.
>>
>
> If you install the MSI version of the driver, it will also install odbc help documentation in your
> windows start menu. There is an example of how to connect using vb. Also if you search the odbc
> mailing list archieves you will find many other examples that show how to do this. There are some
> important "lessons learned" about linking tables via ms-acces also documented in the archieves.
>
> to search odbc list archieves check out the following link:
> http://archives.postgresql.org/pgsql-odbc/
>
> one of the many sample ado connection scripts:
> http://archives.postgresql.org/pgsql-odbc/2006-11/msg00019.p hp
>
> Here is one such bit of advice:
> http://archives.postgresql.org/pgsql-odbc/2006-10/msg00022.p hp
>
> Regards,
> Richard Broersma Jr.
>


--

Kelly Close
Hydrosphere Resource Consultants, Inc.
1002 Walnut, Ste 200
Boulder, CO 80302

(303) 443-7839
http://www.hydrosphere.com


--------------030708090302000203080105
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit







Very helpful, thanks!



~K.



Richard Broersma Jr wrote:

type="cite">

If ANYONE out there has any experience with this, 

from any MS application using VBA, I would appreciate hearing from 

them...and any references to other message lists are welcome too - 

thanks for the pointer to the odbcng list, Richard.

    

If you install the MSI version of the driver, it will also install odbc help documentation in your

windows start menu.  There is an example of how to connect using vb.  Also if you search the odbc

mailing list archieves you will find many other examples that show how to do this.  There are some

important "lessons learned"  about linking tables via ms-acces also documented in the archieves.



to search odbc list archieves check out the following link:





one of the many sample ado connection scripts:





Here is one such bit of advice:





Regards,

Richard Broersma Jr.

  

-- 



Kelly Close

Hydrosphere Resource Consultants, Inc.

1002 Walnut, Ste 200

Boulder, CO  80302



(303) 443-7839