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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-odbc by date

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

pgsql-general by date

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

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