Обсуждение: Windows ODBC Driver
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
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
Вложения
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
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
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
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.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
Bill
* 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 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
Bill