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
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? |
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 :( |