ODBC and configure

From: Ravi Katkar <Ravi(dot)Katkar(at)infor(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>, "'pgsql-odbc(at)postgresql(dot)org'" <'pgsql-odbc(at)postgresql(dot)org'>
Subject: ODBC and configure
Date: 2010-07-27 06:48:20
Message-ID: 46AC8D44F3AE1F4888F137837D0DF63508853EE010@INHYWEXMB2.infor.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

Hi List,

I have installed ODBC and configure the same in RHEL 4.4.

Configured the ODBC in the following way:

[ODBC Data Sources]
testPSQL = PostgreSQL Test

[testPSQL]
Driver=/usr/lib/psqlodbc.so
Description=Sample PostgreSQL DSN
DSN=testPSQL
SERVER=xhost+localhost
Username=postgres
Database=rtdb
ReadOnly=No
Servertype=postgres
Port=5432
FetchBufferSize=99
ServerOptions=
ConnectOptions=
Options=
ReadOnlyi=no
Trace=1
TraceFile=/home/postgres/odbc.trace
Debug=1
DebugFile = /home/postgres/odbc.debug
CommLog = 1

[Default]
Driver = /usr/lib/psqlodbc.so
Description = PostgreSQL Data Source
SERVER=localhost
Port=5432
UserName=postgres
Password=postgres
;Socket=4096
;end odbc.ini

[ODBC]
InstallDir = /usr/lib/libiodbc.so

#=============================================================================#

Steps that I followed to test the ODBC is :

1. Downloaded the "odbctest.c" file from website and copied into unix machine
2. Compile and run the file
Problem:
While running odbctest testPSQL earlier it was working fine, but now everytime its giving the below error:
odbctest: cannot connect to X server

Please suggest if there is any solution for this. I tried with SERVER=localhost and xhost+localhost, again Severname=localhost and xhost+localhost nothing is working after re-compiling and running the .c file.

Thanks,
Ravi Katkar

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-07-27 08:06:41 Re: ODBC and configure
Previous Message John R Pierce 2010-07-26 21:09:49 Re: What to do if space for database decrease and no additional hard drive is possible?

Browse pgsql-odbc by date

  From Date Subject
Next Message Craig Ringer 2010-07-27 08:06:41 Re: ODBC and configure
Previous Message Richard Broersma 2010-07-21 14:49:41 Re: Connection losses :(