Re: Basic connection problem

Thanks.  That was the problem.  I had Host, not Servername.  I used a
sample odbc.ini from iODBC as a pattern and it used Host.

Thanks again.

Paul


Shelby Cain wrote:
> I don't claim to be any expert using ODBC under Unix but It'd probably be helpful if you post the relevant section
fromyour odbc*.ini files... 
>
> http://www.unixodbc.org/odbcinst.html shows an example like so:
>
> [PostgreSQL]
> Description         = Test to Postgres
> Driver              = PostgreSQL
> Trace               = Yes
> TraceFile           = sql.log
> Database            = nick
> Servername          = localhost
> UserName            =
> Password            =
> Port                = 5432
> Protocol            = 6.4
> ReadOnly            = No
> RowVersioning       = No
> ShowSystemTables    = No
> ShowOidColumn       = No
> FakeOidIndex        = No
> ConnSettings        =
>
> Are you sure you have Servername specified correctly?  The error message you are receiving leads me to believe
"Port=5432"is somehow being confused for the database host server name. 
>
> Regards,
>
> Shelby Cain
>
> ----- Original Message ----
> From: Paul B. Anderson <paul.a@pnlassociates.com>
> To: pgsql-odbc@postgresql.org
> Sent: Thursday, January 25, 2007 11:23:07 AM
> Subject: [ODBC] Basic connection problem
>
> I'm just trying to get going with an ODBC interface to Postgresql 8.1.5
> on RHEL 3.0.  I'm using the database without problems via psql, ecpg,
> and JDBC.
>
> I've hit the same problem using both iODBC and unixODBC driver
> managers.  It get the following when I try to connect to the database:
>
> [08001][unixODBC]could not translate host name "port=5432" to address:
> Name or service not known
>
> [ISQL]ERROR: Could not SQLConnect
>
> I've experimented with my ~/.odbc.ini file with and without Port = 5432
> but can't seem to figure how port=5432 is even getting into the connect
> string.
>
> I've got psqlodbc 08.01.0200.  I had to make a couple of small coding
> changes to build it for iODBC but unixODBC worked fine with  psqlodbc
> code as downloaded.
>
> I have unicode support turned on in the driver.  My database uses UTF8.
>
> Surely this must be a common problem.  What am I doing wrong?
>
> Paul
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>
>
>
>
>
> ____________________________________________________________________________________
> 8:00? 8:25? 8:40? Find a flick in no time
> with the Yahoo! Search movie showtime shortcut.
> http://tools.search.yahoo.com/shortcuts/#news
>
> .
>
>