Thread: Cannot get psqlODBC to work

Cannot get psqlODBC to work

From

Glyn Astill

Date:

07 March 2008, 12:39:28

Hi people,

I've been trying to use psqlODBC on windows XP to connect to 8.2.5
running on Debian and had no luck whatsoever.

I've currently got psqlodbc_08_03_0100 installed using the msi
installer, but have tried older versions as well with no change.

I've tried using both ANSI and Unicode driver, both have the same
problem.

The problem is, that I send a query and I seem to get no response. I
can see my query in the servers logs, but nothing after that.

The server log shows (my query):
----------------------------------------------------------------------
STATEMENT:  select * from "Events.SHOW" limit 1
----------------------------------------------------------------------

The mylog on the client shows:
----------------------------------------------------------------------
[1396-0.000]globals.extra_systable_prefixes = 'dd_;'
[1396-0.000]exe name=ODBCView plaformId=2
[1396-0.000][[SQLAllocHandle]][1396-0.000]**** in PGAPI_AllocEnv **
[1396-0.000]** exit PGAPI_AllocEnv: phenv = 010E2980 **
[1396-0.000][[SQLSetEnvAttr]] att=200,3
[1396-0.000][[SQLAllocHandle]][1396-0.000]PGAPI_AllocConnect:
entering...
[1396-0.000]**** PGAPI_AllocConnect: henv = 010E2980, conn = 010E4308
[1396-0.000]EN_add_connection: self = 010E2980, conn = 010E4308
[1396-0.000]       added at 0, conn->henv = 010E2980, conns[0]->henv
= 010E2980
[1396-0.015][SQLGetInfoW(30)][1396-0.015]PGAPI_GetInfo:
entering...fInfoType=77
[1396-0.015]PGAPI_GetInfo: p='03.51', len=0, value=0, cbMax=12
[1396-0.015][SQLSetConnectAttrW][1396-0.015]PGAPI_SetConnectAttr for
010E4308: 115 00000001
[1396-0.015]the application is ansi
[1396-0.015][SQLDriverConnectW][1396-0.015]PGAPI_DriverConnect:
entering...
[1396-0.015]**** PGAPI_DriverConnect: fDriverCompletion=3,
connStrIn='DSN=PostgreSQL30W;'
[1396-0.015]our_connect_string = 'DSN=PostgreSQL30W;'
[1396-0.015]attribute = 'DSN', value = 'PostgreSQL30W'
[1396-0.015]copyAttributes:

DSN='PostgreSQL30W',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[1396-0.015]getDSNinfo: DSN=PostgreSQL30W overwrite=0
[1396-0.015]rollback_on_error=1
[1396-0.015]force_abbrev=0 bde=0 cvt_null_date=0
[1396-0.015]globals.extra_systable_prefixes = 'dd_;'
[1396-0.015]our_connect_string = 'DSN=PostgreSQL30W;'
[1396-0.015]attribute = 'DSN', value = 'PostgreSQL30W'
[1396-0.015]copyCommonAttributes:
A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;
----------------------------------------------------------------------

The psqlodbc log on the client shows:

----------------------------------------------------------------------
[0.015]conn=010E4308, PGAPI_DriverConnect( in)='DSN=PostgreSQL30W;',
fDriverCompletion=3
[0.015]DSN info:
DSN='PostgreSQL30W',server='192.168.1.107',port='5432',dbase='SEE',user='glyn',passwd='xxxxx'
[0.015]
onlyread='0',protocol='7.4',showoid='0',fakeoidindex='0',showsystable='0'
[0.015]          conn_settings='',conn_encoding='(null)'
[0.015]          translation_dll='',translation_option=''
----------------------------------------------------------------------

Does anybody know what my problem might be?

Thanks
Glyn


      __________________________________________________________
Sent from Yahoo! Mail.
The World's Favourite Email http://uk.docs.yahoo.com/nowyoucan.html

Re: Cannot get psqlODBC to work

From

Hiroshi Inoue

Date:

07 March 2008, 17:31:58

Glyn Astill wrote:
> Hi people,
>
> I've been trying to use psqlODBC on windows XP to connect to 8.2.5
> running on Debian and had no luck whatsoever.
>
> I've currently got psqlodbc_08_03_0100 installed using the msi
> installer, but have tried older versions as well with no change.
>
> I've tried using both ANSI and Unicode driver, both have the same
> problem.
>
> The problem is, that I send a query and I seem to get no response. I
> can see my query in the servers logs, but nothing after that.
>
> The server log shows (my query):
> ----------------------------------------------------------------------
> STATEMENT:  select * from "Events.SHOW" limit 1
> ----------------------------------------------------------------------
>
> The mylog on the client shows:

The logging options seem to be turned off.
Could you try to turn on the per DSN Debug option ?

regards,
Hiroshi Inoue

Re: Cannot get psqlODBC to work

From

Glyn Astill

Date:

10 March 2008, 11:21:33

Sorry, I've attached the logs now.

If I send a valid Query, I get a microsoft odbc error "Program type out of range", If I send an invalid query my app
justhangs. 

Any Ideas?

Thanks in advance
Glyn

<b><a rel="nofollow">Glyn Astill</a>
</b>

----- Original Message ----
> From: Hiroshi Inoue <inoue@tpf.co.jp>
> To: Glyn Astill <glynastill@yahoo.co.uk>
> Cc: pgsql-odbc@postgresql.org
> Sent: Friday, 7 March, 2008 6:31:51 PM
> Subject: Re: [ODBC] Cannot get psqlODBC to work
>
> Glyn Astill wrote:
> > Hi people,
> >
> > I've been trying to use psqlODBC on windows XP to connect to 8.2.5
> > running on Debian and had no luck whatsoever.
> >
> > I've currently got psqlodbc_08_03_0100 installed using the msi
> > installer, but have tried older versions as well with no change.
> >
> > I've tried using both ANSI and Unicode driver, both have the same
> > problem.
> >
> > The problem is, that I send a query and I seem to get no response. I
> > can see my query in the servers logs, but nothing after that.
> >
> > The server log shows (my query):
> > ----------------------------------------------------------------------
> > STATEMENT:  select * from "Events.SHOW" limit 1
> > ----------------------------------------------------------------------
> >
> > The mylog on the client shows:
>
> The logging options seem to be turned off.
> Could you try to turn on the per DSN Debug option ?
>
> regards,
> Hiroshi Inoue
>




      __________________________________________________________
Sent from Yahoo! Mail.
The World's Favourite Email http://uk.docs.yahoo.com/nowyoucan.html

Attachment

psqlodbc_2344.log

Re: Cannot get psqlODBC to work

From

Glyn Astill

Date:

11 March 2008, 09:41:14

Any Ideas Chaps?


----- Original Message ----
> From: Glyn Astill <glynastill@yahoo.co.uk>
> To: Hiroshi Inoue <inoue@tpf.co.jp>
> Cc: pgsql-odbc@postgresql.org
> Sent: Monday, 10 March, 2008 11:21:17 AM
> Subject: Re: [ODBC] Cannot get psqlODBC to work
>
> Sorry, I've attached the logs now.
>
> If I send a valid Query, I get a microsoft odbc error "Program type out of
> range", If I send an invalid query my app just hangs.
>
> Any Ideas?
>
> Thanks in advance
> Glyn
>
> Glyn Astill
>
>
> ----- Original Message ----
> > From: Hiroshi Inoue
> > To: Glyn Astill
> > Cc: pgsql-odbc@postgresql.org
> > Sent: Friday, 7 March, 2008 6:31:51 PM
> > Subject: Re: [ODBC] Cannot get psqlODBC to work
> >
> > Glyn Astill wrote:
> > > Hi people,
> > >
> > > I've been trying to use psqlODBC on windows XP to connect to 8.2.5
> > > running on Debian and had no luck whatsoever.
> > >
> > > I've currently got psqlodbc_08_03_0100 installed using the msi
> > > installer, but have tried older versions as well with no change.
> > >
> > > I've tried using both ANSI and Unicode driver, both have the same
> > > problem.
> > >
> > > The problem is, that I send a query and I seem to get no response. I
> > > can see my query in the servers logs, but nothing after that.
> > >
> > > The server log shows (my query):
> > > ----------------------------------------------------------------------
> > > STATEMENT:  select * from "Events.SHOW" limit 1
> > > ----------------------------------------------------------------------
> > >
> > > The mylog on the client shows:
> >
> > The logging options seem to be turned off.
> > Could you try to turn on the per DSN Debug option ?
> >
> > regards,
> > Hiroshi Inoue
> >
>
>
>
>
>       __________________________________________________________
> Sent from Yahoo! Mail..
> The World's Favourite Email http://uk.docs.yahoo.com/nowyoucan.html
>
> -----Inline Attachment Follows-----
>
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>
>




      __________________________________________________________
Sent from Yahoo! Mail.
The World's Favourite Email http://uk.docs.yahoo.com/nowyoucan.html