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 from your 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(dot)a(at)pnlassociates(dot)com>
> To: pgsql-odbc(at)postgresql(dot)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
>
> .
>
>