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

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
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">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>

<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hi List,<o:p></o:p>

<o:p> </o:p>

I have installed ODBC and configure the same in RHEL 4=
..4.<o:p></o:p>

<o:p> </o:p>

Configured the ODBC in the following way:<o:p></o:p></=
span>

<o:p> </o:p>

[ODBC Data Sources]<o:p></o:=
p>

testPSQL =3D PostgreSQL Test=
<o:p></o:p>

<o:p> </o:p></fo=
nt>

[testPSQL]<o:p></o:p>=


Driver=3D/usr /lib/psqlodbc.s=
o<o:p></o:p>

Description=3 DSample Postgre=
SQL DSN<o:p></o:p>

DSN=3DtestPSQ L<o:p></o:p></s=
pan>

SERVER=3Dxhos t+localhost<o:p=
></o:p>

Username=3Dpo stgres<o:p></o:=
p>

Database=3Drt db<o:p></o:p></=
span>

ReadOnly=3DNo<o:p></o:p></sp=
an>

Servertype=3D postgres<o:p></=
o:p>

Port=3D5432<o:p></o:p></span=
>

FetchBufferSi ze=3D99<o:p></o=
:p>

ServerOptions =3D<o:p></o:p><=
/span>

ConnectOption s=3D<o:p></o:p>=


Options=3D<o:p></o:p>=


ReadOnlyi=3Dn o<o:p></o:p></s=
pan>

Trace=3D1<o:p></o:p><=
/font>

TraceFile=3D/ home/postgres/o=
dbc.trace<o:p></o:p>

Debug=3D1<o:p></o:p><=
/font>

DebugFile =3D
/home/postgres/odbc.debug<o:p></o:p>

CommLog =3D 1<o:p></o:p></sp=
an>

<o:p> </o:p></fo=
nt>

[Default]<o:p></o:p><=
/font>

Driver =3D /usr/lib/psqlodbc=
..so<o:p></o:p>

Description =3D PostgreSQL D=
ata
Source<o:p></o:p>

SERVER=3Dloca lhost<o:p></o:p=
>

Port=3D5432<o:p></o:p></span=
>

UserName=3Dpo stgres<o:p></o:=
p>

Password=3Dpo stgres<o:p></o:=
p>

;Socket=3D409 6<o:p></o:p></s=
pan>

;end odbc.ini<o:p></o:p></sp=
an>

<o:p> </o:p></fo=
nt>

[ODBC]<o:p></o:p></fo=
nt>

InstallDir =3D /usr/lib/libi=
odbc.so<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

#=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D#<o:p></o:p>

<o:p> </o:p>

Steps that I followed to test the ODBC is :<o:p></o:p>=


<o:p> </o:p>

<ol style=3D'margin-top:0in' start=3D1 type=3D1>
<li class=3DMsoNormal style=3D'mso-list:l0 level1 lfo1'>Downloaded the “o=
dbctest.c”
file from website and copied into unix machine <o=
:p></o:p></li>
<li class=3DMsoNormal style=3D'mso-list:l0 level1 lfo1'>Compile and run the fil=
e
<o:p></o:p></li>
</ol>

Problem:<o:p></o:p>=


 While running odbctest testPSQL earlier it was work=
ing
fine, but now everytime its giving the below error:<o:p></o:p></font=
>

 odbctest:
cannot connect to X server<o:p></o:p>

<o:p> </o:p>

Please suggest if there is any solution for this. I tr=
ied
with SERVER=3Dlocalhost and xhost+localhost, again Severname=3Dlocalhost an=
d
xhost+localhost nothing is working after re-compiling and running the .c fi=
le.
 <o:p></o:p>

 <o:p></o:p>

Thanks,<o:p></o:p>

<st1:place w:st=3D"on">Ravi=
</st1:place> Katkar <o:p></o:p>

</div>

</body>

</html>

--_000_46AC8D44F3AE1F4888F137837D0DF63508853EE010INHYWEXMB2i nf_--

Ravi Katkar [ Di, 27 Juli 2010 08:48 ] [ ID #2045196 ]

Re: ODBC and configure

On 27/07/10 14:48, Ravi Katkar wrote:

> 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

This isn't a PostgreSQL problem.

Your 'odbctest.c' (where *did* you get that, anyway? What URL?) appears
to be using a GUI toolkit that requires an X11 graphical environment.
That's what "cannot connect to X server" refers to ; it's nothing to do
with the PostgreSQL server.

If you have an X11 server running on your local machine, connect to the
machine odbctest is on using "ssh -X" to enable ssh X11 forwarding. Then
odbctest should run over the SSH X11 tunnel.

Otherwise, compile odbctest without any GUI requirements. Without some
idea of where you got "odbctest.c" and what it is, I can't really help
you with that.

--
Craig Ringer

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Craig Ringer [ Di, 27 Juli 2010 10:06 ] [ ID #2045197 ]

Re: ODBC and configure

Odbctest.c downloaded from the below website http://wwwmath.uni-muenster.de=
/u/beckelu/DB0506/ODBC/

Please refer if I can get the same .c file from other location.

Its not using GUI toolkit .

-----Original Message-----
From: Craig Ringer [mailto:craig [at] postnewspapers.com.au]
Sent: Tuesday, July 27, 2010 1:37 PM
To: Ravi Katkar
Cc: 'pgsql-odbc [at] postgresql.org'
Subject: Re: [ODBC] ODBC and configure

On 27/07/10 14:48, Ravi Katkar wrote:

> 1. Downloaded the "odbctest.c" file from website and copied into unix m=
achine
> 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

This isn't a PostgreSQL problem.

Your 'odbctest.c' (where *did* you get that, anyway? What URL?) appears
to be using a GUI toolkit that requires an X11 graphical environment.
That's what "cannot connect to X server" refers to ; it's nothing to do
with the PostgreSQL server.

If you have an X11 server running on your local machine, connect to the
machine odbctest is on using "ssh -X" to enable ssh X11 forwarding. Then
odbctest should run over the SSH X11 tunnel.

Otherwise, compile odbctest without any GUI requirements. Without some
idea of where you got "odbctest.c" and what it is, I can't really help
you with that.

--
Craig Ringer

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Ravi Katkar [ Di, 27 Juli 2010 12:23 ] [ ID #2045198 ]

Re: ODBC and configure

On 27/07/10 18:23, Ravi Katkar wrote:
> Odbctest.c downloaded from the below website http://wwwmath.uni-muenster.de/u/beckelu/DB0506/ODBC/

> Its not using GUI toolkit .

Nope, it certainly isn't. But something seems to be trying to talk to
your X server, unless that message is somehow weirdly misleading.

Here, installing unixodbc from debian packages and compiling odbctest as:

gcc -o odbctest odbctest.c -lodbc

it runs fine with DISPLAY unset (ie with no access to an X server).

My next step in your position would be to strace the binary to see what
it's doing, use ldd to examine what it's linking to, or use LD_DEBUG to
trace what libraries it accesses. Though, of course, I'd also know how
I'd compiled it, which you didn't mention.

In any case, though, there's no sign this issue has anything to do with
PostgreSQL. I hope this sets you vaguely on the right track, but I'm not
really into ODBC at the best of times, so I think I might be about done
with my usefulness here.

--
Craig Ringer

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Craig Ringer [ Di, 27 Juli 2010 13:08 ] [ ID #2045199 ]

Re: ODBC and configure

Craig Ringer <craig [at] postnewspapers.com.au> writes:
> On 27/07/10 18:23, Ravi Katkar wrote:
>> Odbctest.c downloaded from the below website http://wwwmath.uni-muenster.de/u/beckelu/DB0506/ODBC/

>> Its not using GUI toolkit .

> Nope, it certainly isn't. But something seems to be trying to talk to
> your X server, unless that message is somehow weirdly misleading.

There's a program called odbctest in (some releases of) the unixODBC
package. I suspect Ravi is executing that, not his own program.

regards, tom lane

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Tom Lane [ Di, 27 Juli 2010 16:31 ] [ ID #2045202 ]

Re: ODBC and configure

Hi Tom,

You are right I am executing odbcTest program in unix odbc package.

Regards,
Ravi Katkar

-----Original Message-----
From: Tom Lane [mailto:tgl [at] sss.pgh.pa.us]
Sent: Tuesday, July 27, 2010 8:01 PM
To: Craig Ringer
Cc: Ravi Katkar; 'pgsql-odbc [at] postgresql.org'
Subject: Re: [ODBC] ODBC and configure

Craig Ringer <craig [at] postnewspapers.com.au> writes:
> On 27/07/10 18:23, Ravi Katkar wrote:
>> Odbctest.c downloaded from the below website http://wwwmath.uni-muenster=
..de/u/beckelu/DB0506/ODBC/

>> Its not using GUI toolkit .

> Nope, it certainly isn't. But something seems to be trying to talk to
> your X server, unless that message is somehow weirdly misleading.

There's a program called odbctest in (some releases of) the unixODBC
package. I suspect Ravi is executing that, not his own program.

regards, tom lane

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Ravi Katkar [ Mi, 28 Juli 2010 06:53 ] [ ID #2045251 ]