Re: Why would Postgres not show in my data connections (Win 7)

Suggest your use a DSN-less connection if possible, Connection string below works for me:
"Driver={PostgreSQL
ANSI};Server=servername;Port=5432;Database=dbname;Uid=username;Pwd=password;BI=2;TextAsLongVarchar=1;UnknownSizes=2;"

This eliminates a lot of setup issues on a the end user (or end server) machine

Thanks
Barry Bell, IT Department
Office: 954-429-3771 x267 Fax: 954-281-1464 email Barry_Bell@harte-hanks.com


-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Della-Croce, Gregory
Sent: Tuesday, June 05, 2012 4:36 PM
To: Adrian Klaver
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Why would Postgres not show in my data connections (Win 7)

Thanks all that got me to the right place to set up the connection!   Great advice.  I thought I had done it earlier
butnow it gives me the system DSN values I need to set up the connection for my stuff. 

Greg Della-Croce

On 06/05/2012 12:41 PM, Della-Croce, Gregory wrote:
> Thanks for responding!  It is none of the lists: User, System, File DSN or Drivers.   In fact the System DSN is
blank. And My Data Sources is also blank in File DSN.   The only drivers that show are MS Access/dBASE, MS Access, MS
ACCESSText, MS EXCEL, and SQL Server. 
> Yes I am signed in as Admin when I did the psqlodbc install and I have opened the ODBC Data Source as Admin also.
>
> These are good questions.  I wish they sparked an answer :)

In that case Rays answer is the one you should pursue. For more info see:


http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#Where_is_the_PostgreSQL_ODBC_driver.3F_I.27m_running_32-bit_PostgreSQL_on_64-bit_Windows
>
> Greg Della-Croce



--
Adrian Klaver
adrian.klaver@gmail.com

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc