Обсуждение: Windows ODBC Driver

Поиск
Список
Период
Сортировка

Windows ODBC Driver

От
"Greg Lindstrom"
Дата:
Hello,

I would like to connect to Postgres from Python running on a Windows box.  I need the ODBC driver to create a windows ODBC datasource.  I've been looking for two days and have found lots of dead links, but no drivers.  Can someone please help me locate a driver so I can connect?

Thanks,
--greg

Re: Windows ODBC Driver

От
Stephen Frost
Дата:
Greg,

* Greg Lindstrom (gslindstrom@gmail.com) wrote:
> I would like to connect to Postgres from Python running on a Windows box.  I
> need the ODBC driver to create a windows ODBC datasource.  I've been looking
> for two days and have found lots of dead links, but no drivers.  Can someone
> please help me locate a driver so I can connect?

I would guess this is what you're looking for?:

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

    Enjoy,

        Stephen
Вложения

Re: Windows ODBC Driver

От
"Dave Page"
Дата:
On Thu, Sep 11, 2008 at 5:13 PM, Greg Lindstrom <gslindstrom@gmail.com> wrote:
> Hello,
>
> I would like to connect to Postgres from Python running on a Windows box.  I
> need the ODBC driver to create a windows ODBC datasource.  I've been looking
> for two days and have found lots of dead links, but no drivers.  Can someone
> please help me locate a driver so I can connect?

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


--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

Re: Windows ODBC Driver

От
"Alan Scott"
Дата:
I installed PostGres Adv Server locally from enterprisedb.com and had everything needed to create an ODBC connection for our data modeling tools...

On Thu, Sep 11, 2008 at 12:13 PM, Greg Lindstrom <gslindstrom@gmail.com> wrote:
Hello,

I would like to connect to Postgres from Python running on a Windows box.  I need the ODBC driver to create a windows ODBC datasource.  I've been looking for two days and have found lots of dead links, but no drivers.  Can someone please help me locate a driver so I can connect?

Thanks,
--greg

Re: Windows ODBC Driver

От
"Dann Corbit"
Дата:

Commercial Windows & Unix based PostgreSQL ODBC drivers:

http://www.connx.com

http://www.openlinksw.com

 

For the Mac:

http://www.actualtechnologies.com/product_opensourcedatabases.php

 

Free:

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

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

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Greg Lindstrom
Sent: Thursday, September 11, 2008 9:14 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Windows ODBC Driver

 

Hello,

I would like to connect to Postgres from Python running on a Windows box.  I need the ODBC driver to create a windows ODBC datasource.  I've been looking for two days and have found lots of dead links, but no drivers.  Can someone please help me locate a driver so I can connect?

Thanks,
--greg

Re: Windows ODBC Driver

От
Bill Todd
Дата:
Stephen Frost wrote: 
Greg,

* Greg Lindstrom (gslindstrom@gmail.com) wrote: 
I would like to connect to Postgres from Python running on a Windows box.  I
need the ODBC driver to create a windows ODBC datasource.  I've been looking
for two days and have found lots of dead links, but no drivers.  Can someone
please help me locate a driver so I can connect?   
I would guess this is what you're looking for?:

http://www.postgresql.org/ftp/odbc/versions/
Enjoy,
	Stephen
FWIW I cannot get the ODBC driver to work correctly with ADO and the OLE DB provider for ODBC. It sees TEXT fields as VARCHAR instead of LONGVARCHAR. I do not know if the problem is at the ODBC level or the ADO level but test carefully if you are going to use TEXT fields.

Bill

Re: Windows ODBC Driver

От
Stephen Frost
Дата:
* Bill Todd (pg@dbginc.com) wrote:
> FWIW I cannot get the ODBC driver to work correctly with ADO and the OLE
> DB provider for ODBC. It sees TEXT fields as VARCHAR instead of
> LONGVARCHAR. I do not know if the problem is at the ODBC level or the
> ADO level but test carefully if you are going to use TEXT fields.

There's an option in the ODBC configuration settings to flip that back
and forth, I believe...  'Text as LongVarChar'.

    Stephen
Вложения

Re: Windows ODBC Driver

От
Bill Todd
Дата:
Stephen Frost wrote: 
* Bill Todd (pg@dbginc.com) wrote: 
FWIW I cannot get the ODBC driver to work correctly with ADO and the OLE  
DB provider for ODBC. It sees TEXT fields as VARCHAR instead of  
LONGVARCHAR. I do not know if the problem is at the ODBC level or the  
ADO level but test carefully if you are going to use TEXT fields.   
There's an option in the ODBC configuration settings to flip that back
and forth, I believe...  'Text as LongVarChar'.
Stephen
Been there, done that, does not work.<g> The only way I could get a text field to be treated as LongVarChar was to check UnknownAsLongVarChar and when I do that both VarChar and Text columns are treated as LongVarChar.

Bill