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

Cannot get psqlODBC to work

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Cannot get psqlODBC to work
Date: 2008-03-07 13:39:18
Message-ID: 971610.64044.qm@web25806.mail.ukl.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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


Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2008-03-07 18:09:12
Subject: Re: " for read only" clause appended for safety when UseDeclareFetch=1 breaks some sql statements with trailing semicolons
Previous:From: Jack WilsonDate: 2008-03-06 13:14:00
Subject: Re: " for read only" clause appended for safety when UseDeclareFetch=1 breaks some sql statements with trailing semicolons

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