Cannot get psqlODBC to work

[Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>]

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