SEO

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='',pas swd='xxxxx',port='',onlyread='',protocol='',conn_s ettings='',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='5 432',dbase='SEE',user='glyn',passwd='xxxxx'
[0.015]
onlyread='0',protocol='7.4',showoid='0',fakeoidind ex='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


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

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 via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc