ODBC and configure

--_000_46AC8D44F3AE1F4888F137837D0DF63508853EE010INHYWEXMB2i nf_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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 =3D PostgreSQL Test

[testPSQL]
Driver=3D/usr/lib/psqlodbc.so
Description=3DSample PostgreSQL DSN
DSN=3DtestPSQL
SERVER=3Dxhost+localhost
Username=3Dpostgres
Database=3Drtdb
ReadOnly=3DNo
Servertype=3Dpostgres
Port=3D5432
FetchBufferSize=3D99
ServerOptions=3D
ConnectOptions=3D
Options=3D
ReadOnlyi=3Dno
Trace=3D1
TraceFile=3D/home/postgres/odbc.trace
Debug=3D1
DebugFile =3D /home/postgres/odbc.debug
CommLog =3D 1

[Default]
Driver =3D /usr/lib/psqlodbc.so
Description =3D PostgreSQL Data Source
SERVER=3Dlocalhost
Port=3D5432
UserName=3Dpostgres
Password=3Dpostgres
;Socket=3D4096
;end odbc.ini

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


#===================3D=3 D=====
==================== =====3D=
==================== =====3D=
===3D#

Steps that I followed to test the ODBC is :


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

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

Thanks,
Ravi Katkar

--_000_46AC8D44F3AE1F4888F137837D0DF63508853EE010INHYWEXMB2i nf_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://ww=
w.w3.org/TR/REC-html40">




name=3D"place"/>