Skip site navigation (1) Skip section navigation (2)

Help with setting up postgres and odbc

From: mike <mike(at)redtux1(dot)uklinux(dot)net>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Help with setting up postgres and odbc
Date: 2004-02-17 09:37:21
Message-ID: 1077010641.16755.26.camel@datacc (view raw or flat)
Thread:
Lists: pgsql-interfaces
I seem to be hitting a bit of a wall here.

This is what I have got

/etc/odbc.ini
[PostgreSQL]
Description         = Datacc
Driver              = PostgreSQL
Trace               = Yes
TraceFile           = sql.log
Database            = data_cc
Servername          = localhost
Host                = localhost
UserName            =
Password            =
Port                = 5432
Servertype          = postgres
Protocol            = 6.4
ReadOnly            = No
RowVersioning       = No
ShowSystemTables    = No
ShowOidColumn       = No
FakeOidIndex        = No
ConnSettings        =
 
[Default]
Driver          = /usr/lib/psqlodbc.so
 
[ODBC]
InstallDir      = /usr/lib/libodbc.so

/etc/odbcinst.ini

# Example driver definitinions
#
#
 
# Included in the unixODBC package
[PostgreSQL]
Description     = ODBC for PostgreSQL
Driver          = /usr/lib/psqlodbc.so
Setup           = /usr/lib/libodbcpsqlS.so.1
FileUsage       = 1
 
 
# From the MyODBC package
#[MySQL]
#Description    = ODBC for MySQL
#Driver         = /usr/lib/libmyodbc.so
#FileUsage      = 1

using odbctest I get this when I try to connect using full connect
SQLConnect() failed
Diag(hdbc 0x82bd1b0):IM002:201:[unixODBC]Missing server name, port, or
database name in call to CC_connect.

Any help appreciated

pgsql-interfaces by date

Next:From: Bruce MomjianDate: 2004-02-17 14:43:16
Subject: Re: Need new project admin for unbundled Tcl interface
Previous:From: Brett SchwarzDate: 2004-02-17 09:09:38
Subject: Re: Need new project admin for unbundled Tcl interface

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group