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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-02-17 14:43:16 | Re: Need new project admin for unbundled Tcl interface |
Previous Message | Brett Schwarz | 2004-02-17 09:09:38 | Re: Need new project admin for unbundled Tcl interface |