Cannot get psqlODBC to work

Cannot get psqlODBC to work

am 07.03.2008 14:39:18 von Glyn Astill

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 =3D 'dd_;'
[1396-0.000]exe name=3DODBCView plaformId=3D2
[1396-0.000][[SQLAllocHandle]][1396-0.000]**** in PGAPI_AllocEnv **=20
[1396-0.000]** exit PGAPI_AllocEnv: phenv =3D 010E2980 **
[1396-0.000][[SQLSetEnvAttr]] att=3D200,3
[1396-0.000][[SQLAllocHandle]][1396-0.000]PGAPI_AllocConnect :
entering...
[1396-0.000]**** PGAPI_AllocConnect: henv =3D 010E2980, conn =3D 010E4308
[1396-0.000]EN_add_connection: self =3D 010E2980, conn =3D 010E4308
[1396-0.000] added at 0, conn->henv =3D 010E2980, conns[0]->henv
=3D 010E2980
[1396-0.015][SQLGetInfoW(30)][1396-0.015]PGAPI_GetInfo:
entering...fInfoType=3D77
[1396-0.015]PGAPI_GetInfo: p=3D'03.51', len=3D0, value=3D0, cbMax=3D12
[1396-0.015][SQLSetConnectAttrW][1396-0.015]PGAPI_SetConnect Attr for
010E4308: 115 00000001
[1396-0.015]the application is ansi
[1396-0.015][SQLDriverConnectW][1396-0.015]PGAPI_DriverConne ct:
entering...
[1396-0.015]**** PGAPI_DriverConnect: fDriverCompletion=3D3,
connStrIn=3D'DSN=3DPostgreSQL30W;'
[1396-0.015]our_connect_string =3D 'DSN=3DPostgreSQL30W;'
[1396-0.015]attribute =3D 'DSN', value =3D 'PostgreSQL30W'
[1396-0.015]copyAttributes:
DSN=3D'PostgreSQL30W',server=3D'',dbase=3D'',user=3D'',passw d=3D'xxxxx',p=
ort=3D'',onlyread=3D'',protocol=3D'',conn_settings=3D'',disa llow_prematur=
e=3D-1)
[1396-0.015]getDSNinfo: DSN=3DPostgreSQL30W overwrite=3D0
[1396-0.015]rollback_on_error=3D1
[1396-0.015]force_abbrev=3D0 bde=3D0 cvt_null_date=3D0
[1396-0.015]globals.extra_systable_prefixes =3D 'dd_;'
[1396-0.015]our_connect_string =3D 'DSN=3DPostgreSQL30W;'
[1396-0.015]attribute =3D 'DSN', value =3D 'PostgreSQL30W'
[1396-0.015]copyCommonAttributes:
A7=3D100;A8=3D4096;A9=3D0;B0=3D255;B1=3D8190;B2=3D0;B3=3D0;B 4=3D1;B5=3D1;=
B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0;C1=3D0;C2=3Ddd_;
------------------------------------------------------------ ----------

The psqlodbc log on the client shows:

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

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


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

Re: Cannot get psqlODBC to work

am 07.03.2008 19:31:51 von Hiroshi Inoue

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

Re: Cannot get psqlODBC to work

am 10.03.2008 12:21:17 von Glyn Astill

--0-1069563377-1205148077=:53093
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

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
=20



----- 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
>=20
> Glyn Astill wrote:
> > Hi people,
> >=20
> > I've been trying to use psqlODBC on windows XP to connect to 8.2.5
> > running on Debian and had no luck whatsoever.
> >=20
> > I've currently got psqlodbc_08_03_0100 installed using the msi
> > installer, but have tried older versions as well with no change.
> >=20
> > I've tried using both ANSI and Unicode driver, both have the same
> > problem.
> >=20
> > 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.
> >=20
> > The server log shows (my query):
> > ------------------------------------------------------------ ----------
> > STATEMENT: select * from "Events.SHOW" limit 1
> > ------------------------------------------------------------ ----------
> >=20
> > The mylog on the client shows:
>=20
> The logging options seem to be turned off.
> Could you try to turn on the per DSN Debug option ?
>=20
> regards,
> Hiroshi Inoue
>=20




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

--0-1069563377-1205148077=:53093
Content-Type: application/octet-stream; name="psqlodbc_2344.log"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="psqlodbc_2344.log"

WzAuMDA1XWNvbm49MDEwRTQzMDgsIFBHQVBJX0RyaXZlckNvbm5lY3QoIGlu
KT0nRFNOPVBvc3RncmVTUUwzMFc7JywgZkRyaXZlckNvbXBsZXRpb249Mwpb
MC4wMDhdRFNOIGluZm86IERTTj0nUG9zdGdyZVNRTDMwVycsc2VydmVyPScx
OTIuMTY4LjEuMTA3Jyxwb3J0PSc1NDMyJyxkYmFzZT0nU0VFJyx1c2VyPSdn
bHluJyxwYXNzd2Q9J3h4eHh4JwpbMC4wMDhdICAgICAgICAgIG9ubHlyZWFk
PScwJyxwcm90b2NvbD0nNy40JyxzaG93b2lkPScwJyxmYWtlb2lkaW5kZXg9
JzAnLHNob3dzeXN0YWJsZT0nMCcKWzAuMDA5XSAgICAgICAgICBjb25uX3Nl
dHRpbmdzPScnLGNvbm5fZW5jb2Rpbmc9JyhudWxsKScKWzAuMDA5XSAgICAg
ICAgICB0cmFuc2xhdGlvbl9kbGw9JycsdHJhbnNsYXRpb25fb3B0aW9uPScn
ClswLjAxMV1Ecml2ZXIgVmVyc2lvbj0nMDguMDMuMDEwMCwyMDA4MDEyMjAw
MDEnIGxpbmtpbmcgMTQwMCBzdGF0aWMgTXVsdGl0aHJlYWQgbGlicmFyeQpb
MC4wMTFdR2xvYmFsIE9wdGlvbnM6IGZldGNoPTEwMCwgc29ja2V0PTQwOTYs
IHVua25vd25fc2l6ZXM9MCwgbWF4X3ZhcmNoYXJfc2l6ZT0yNTUsIG1heF9s
b25ndmFyY2hhcl9zaXplPTgxOTAKWzAuMDEyXSAgICAgICAgICAgICAgICBk
aXNhYmxlX29wdGltaXplcj0xLCBrc3FvPTEsIHVuaXF1ZV9pbmRleD0xLCB1
c2VfZGVjbGFyZWZldGNoPTAKWzAuMDEyXSAgICAgICAgICAgICAgICB0ZXh0
X2FzX2xvbmd2YXJjaGFyPTEsIHVua25vd25zX2FzX2xvbmd2YXJjaGFyPTAs
IGJvb2xzX2FzX2NoYXI9MSBOQU1FREFUQUxFTj02NApbMC4wMTJdICAgICAg
ICAgICAgICAgIGV4dHJhX3N5c3RhYmxlX3ByZWZpeGVzPSdkZF87JywgY29u
bl9zZXR0aW5ncz0nJyBjb25uX2VuY29kaW5nPScnClswLjAyMV0gICAgWyBQ
b3N0Z3JlU1FMIHZlcnNpb24gc3RyaW5nID0gJzguMi41JyBdClswLjAyMV0g
ICAgWyBQb3N0Z3JlU1FMIHZlcnNpb24gbnVtYmVyID0gJzguMicgXQpbMC4w
MjRdY29ubj0wMTBFNDMwOCwgcXVlcnk9J3NlbGVjdCBvaWQsIHR5cGJhc2V0
eXBlIGZyb20gcGdfdHlwZSB3aGVyZSB0eXBuYW1lID0gJ2xvJycKWzAuMDI4
XSAgICBbIGZldGNoZWQgMCByb3dzIF0KWzAuMDMwXSAgICBbIExhcmdlIE9i
amVjdCBvaWQgPSAtOTk5IF0KWzAuMDMwXSAgICBbIENsaWVudCBlbmNvZGlu
ZyA9ICdVVEY4JyAoY29kZSA9IDYpIF0KWzAuMDMxXWNvbm49MDEwRTQzMDgs
IFBHQVBJX0RyaXZlckNvbm5lY3Qob3V0KT0nRFNOPVBvc3RncmVTUUwzMFc7
REFUQUJBU0U9U0VFO1NFUlZFUj0xOTIuMTY4LjEuMTA3O1BPUlQ9NTQzMjtV
SUQ9Z2x5bjtQV0Q9eHh4eHh4eHg7Q0E9ZDtBNj07QTc9MTAwO0E4PTQwOTY7
QjA9MjU1O0IxPTgxOTA7Qkk9MDtDMj1kZF87O0NYPTFiNTBmYmI7QTE9Ny40
LTEnClsxMi4xNjddY29ubj0wMTBFNDMwOCwgcXVlcnk9J3NlbGVjdCAqIGZy
b20gIkV2ZW50cyIuIlBSSUNFIiBsaW1pdCAxOycKWzEyLjIwMF0gICAgWyBm
ZXRjaGVkIDEgcm93cyBdClsxMi4yNDFdY29ubj0wMTBFNDMwOCwgcXVlcnk9
J3NlbGVjdCBuLm5zcG5hbWUsIGMucmVsbmFtZSwgYS5hdHRuYW1lLCBhLmF0
dHR5cGlkLCB0LnR5cG5hbWUsIGEuYXR0bnVtLCBhLmF0dGxlbiwgYS5hdHR0
eXBtb2QsIGEuYXR0bm90bnVsbCwgYy5yZWxoYXNydWxlcywgYy5yZWxraW5k
LCBjLm9pZCwgZC5hZHNyYyBmcm9tICgoKHBnX2NhdGFsb2cucGdfY2xhc3Mg
YyBpbm5lciBqb2luIHBnX2NhdGFsb2cucGdfbmFtZXNwYWNlIG4gb24gbi5v
aWQgPSBjLnJlbG5hbWVzcGFjZSBhbmQgYy5vaWQgPSAyOTc2NzA2NSkgaW5u
ZXIgam9pbiBwZ19jYXRhbG9nLnBnX2F0dHJpYnV0ZSBhIG9uIChub3QgYS5h
dHRpc2Ryb3BwZWQpIGFuZCBhLmF0dG51bSA+IDAgYW5kIGEuYXR0cmVsaWQg
PSBjLm9pZCkgaW5uZXIgam9pbiBwZ19jYXRhbG9nLnBnX3R5cGUgdCBvbiB0
Lm9pZCA9IGEuYXR0dHlwaWQpIGxlZnQgb3V0ZXIgam9pbiBwZ19hdHRyZGVm
IGQgb24gYS5hdHRoYXNkZWYgYW5kIGQuYWRyZWxpZCA9IGEuYXR0cmVsaWQg
YW5kIGQuYWRudW0gPSBhLmF0dG51bSBvcmRlciBieSBuLm5zcG5hbWUsIGMu
cmVsbmFtZSwgYXR0bnVtJwpbMTIuMzQxXSAgICBbIGZldGNoZWQgNTAgcm93
cyBdClsxMi4zNzRdUEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNFJyxmaWVs
ZF9uYW1lPSdSRUNOVU0nLHR5cGU9MjAsbmFtZT0naW50OCcKWzEyLjM5MV1Q
R0FQSV9Db2x1bW5zOiB0YWJsZT0nUFJJQ0UnLGZpZWxkX25hbWU9J1NIT1cn
LHR5cGU9MTcwMCxuYW1lPSdudW1lcmljJwpbMTIuNDA5XVBHQVBJX0NvbHVt
bnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFtZT0nVFBSSUNFJyx0eXBlPTE3
MDAsbmFtZT0nbnVtZXJpYycKWzEyLjQyNl1QR0FQSV9Db2x1bW5zOiB0YWJs
ZT0nUFJJQ0UnLGZpZWxkX25hbWU9J0NQUklDRScsdHlwZT0xNzAwLG5hbWU9
J251bWVyaWMnClsxMi40NDRdUEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNF
JyxmaWVsZF9uYW1lPSdDUkVETE9BRCcsdHlwZT0xNzAwLG5hbWU9J251bWVy
aWMnClsxMi40NjBdUEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNFJyxmaWVs
ZF9uYW1lPSdRUFVSQ0gnLHR5cGU9MTcwMCxuYW1lPSdudW1lcmljJwpbMTIu
NDc4XVBHQVBJX0NvbHVtbnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFtZT0n
UVNPTEQnLHR5cGU9MTcwMCxuYW1lPSdudW1lcmljJwpbMTIuNDk1XVBHQVBJ
X0NvbHVtbnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFtZT0nUVNPUicsdHlw
ZT0xNzAwLG5hbWU9J251bWVyaWMnClsxMi41MTJdUEdBUElfQ29sdW1uczog
dGFibGU9J1BSSUNFJyxmaWVsZF9uYW1lPSdTVEFUVVMnLHR5cGU9MTcwMCxu
YW1lPSdudW1lcmljJwpbMTIuNTMxXVBHQVBJX0NvbHVtbnM6IHRhYmxlPSdQ
UklDRScsZmllbGRfbmFtZT0nU0VMTF9UTycsdHlwZT0xNzAwLG5hbWU9J251
bWVyaWMnClsxMi41NDhdUEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNFJyxm
aWVsZF9uYW1lPSdQT1NUQUdFJyx0eXBlPTE3MDAsbmFtZT0nbnVtZXJpYycK
WzEyLjU2NV1QR0FQSV9Db2x1bW5zOiB0YWJsZT0nUFJJQ0UnLGZpZWxkX25h
bWU9J05BUlInLHR5cGU9MTA0MyxuYW1lPSd2YXJjaGFyJwpbMTIuNTgyXVBH
QVBJX0NvbHVtbnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFtZT0nTUFYX1NF
TEwnLHR5cGU9MTcwMCxuYW1lPSdudW1lcmljJwpbMTIuNjAwXVBHQVBJX0Nv
bHVtbnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFtZT0nVFlQRScsdHlwZT0x
NzAwLG5hbWU9J251bWVyaWMnClsxMi42MThdUEdBUElfQ29sdW1uczogdGFi
bGU9J1BSSUNFJyxmaWVsZF9uYW1lPSdTT0xENycsdHlwZT0xNzAwLG5hbWU9
J251bWVyaWMnClsxMi42MzVdUEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNF
JyxmaWVsZF9uYW1lPSdTT0xEMTQnLHR5cGU9MTcwMCxuYW1lPSdudW1lcmlj
JwpbMTIuNjUzXVBHQVBJX0NvbHVtbnM6IHRhYmxlPSdQUklDRScsZmllbGRf
bmFtZT0nTUVESUFfTE9BRCcsdHlwZT0xNzAwLG5hbWU9J251bWVyaWMnClsx
Mi42NzBdUEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNFJyxmaWVsZF9uYW1l
PSdTT1VSQ0UxJyx0eXBlPTE3MDAsbmFtZT0nbnVtZXJpYycKWzEyLjY4OF1Q
R0FQSV9Db2x1bW5zOiB0YWJsZT0nUFJJQ0UnLGZpZWxkX25hbWU9J1NPVVJD
RTInLHR5cGU9MTcwMCxuYW1lPSdudW1lcmljJwpbMTIuNzA2XVBHQVBJX0Nv
bHVtbnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFtZT0nUFJJTlRFRCcsdHlw
ZT0xNzAwLG5hbWU9J251bWVyaWMnClsxMi43MjRdUEdBUElfQ29sdW1uczog
dGFibGU9J1BSSUNFJyxmaWVsZF9uYW1lPSdQUk9NX0xPQUQnLHR5cGU9MTcw
MCxuYW1lPSdudW1lcmljJwpbMTIuNzQyXVBHQVBJX0NvbHVtbnM6IHRhYmxl
PSdQUklDRScsZmllbGRfbmFtZT0nSU5GTzEnLHR5cGU9MTA0MyxuYW1lPSd2
YXJjaGFyJwpbMTIuNzU5XVBHQVBJX0NvbHVtbnM6IHRhYmxlPSdQUklDRScs
ZmllbGRfbmFtZT0nSU5GTzInLHR5cGU9MTA0MyxuYW1lPSd2YXJjaGFyJwpb
MTIuNzc3XVBHQVBJX0NvbHVtbnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFt
ZT0nSU5GTzMnLHR5cGU9MTA0MyxuYW1lPSd2YXJjaGFyJwpbMTIuNzk0XVBH
QVBJX0NvbHVtbnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFtZT0nSU5GTzQn
LHR5cGU9MTA0MyxuYW1lPSd2YXJjaGFyJwpbMTIuODEyXVBHQVBJX0NvbHVt
bnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFtZT0nSU5GTzUnLHR5cGU9MTA0
MyxuYW1lPSd2YXJjaGFyJwpbMTIuODMxXVBHQVBJX0NvbHVtbnM6IHRhYmxl
PSdQUklDRScsZmllbGRfbmFtZT0nTE9HR0VEX0lOJyx0eXBlPTE3MDAsbmFt
ZT0nbnVtZXJpYycKWzEyLjg0OF1QR0FQSV9Db2x1bW5zOiB0YWJsZT0nUFJJ
Q0UnLGZpZWxkX25hbWU9J1NFQVRFRCcsdHlwZT0xMDQzLG5hbWU9J3ZhcmNo
YXInClsxMi44NjddUEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNFJyxmaWVs
ZF9uYW1lPSdUSUNLRVRTX0lOJyx0eXBlPTE3MDAsbmFtZT0nbnVtZXJpYycK
WzEyLjg4NF1QR0FQSV9Db2x1bW5zOiB0YWJsZT0nUFJJQ0UnLGZpZWxkX25h
bWU9J1RJQ0tFVFNfUFInLHR5cGU9MTcwMCxuYW1lPSdudW1lcmljJwpbMTIu
OTA0XVBHQVBJX0NvbHVtbnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFtZT0n
SE9XX01BTlknLHR5cGU9MTcwMCxuYW1lPSdudW1lcmljJwpbMTIuOTIyXVBH
QVBJX0NvbHVtbnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFtZT0nRlJFRV9B
TU9VTlQnLHR5cGU9MTcwMCxuYW1lPSdudW1lcmljJwpbMTIuOTQwXVBHQVBJ
X0NvbHVtbnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFtZT0nUkFOR0VfRlJP
TScsdHlwZT0xNzAwLG5hbWU9J251bWVyaWMnClsxMi45NTddUEdBUElfQ29s
dW1uczogdGFibGU9J1BSSUNFJyxmaWVsZF9uYW1lPSdSQU5HRV9UTycsdHlw
ZT0xNzAwLG5hbWU9J251bWVyaWMnClsxMi45NzRdUEdBUElfQ29sdW1uczog
dGFibGU9J1BSSUNFJyxmaWVsZF9uYW1lPSdTUEFSRScsdHlwZT0xNzAwLG5h
bWU9J251bWVyaWMnClsxMi45OTNdUEdBUElfQ29sdW1uczogdGFibGU9J1BS
SUNFJyxmaWVsZF9uYW1lPSdTUEFSRUEnLHR5cGU9MTA0MyxuYW1lPSd2YXJj
aGFyJwpbMTMuMDExXVBHQVBJX0NvbHVtbnM6IHRhYmxlPSdQUklDRScsZmll
bGRfbmFtZT0nT0ZGRVInLHR5cGU9MTcwMCxuYW1lPSdudW1lcmljJwpbMTMu
MDI4XVBHQVBJX0NvbHVtbnM6IHRhYmxlPSdQUklDRScsZmllbGRfbmFtZT0n
REFURV8xJyx0eXBlPTEwODIsbmFtZT0nZGF0ZScKWzEzLjA0NV1QR0FQSV9D
b2x1bW5zOiB0YWJsZT0nUFJJQ0UnLGZpZWxkX25hbWU9J0RBVEVfMicsdHlw
ZT0xMDgyLG5hbWU9J2RhdGUnClsxMy4wNjJdUEdBUElfQ29sdW1uczogdGFi
bGU9J1BSSUNFJyxmaWVsZF9uYW1lPSdJTlRfMScsdHlwZT0xNzAwLG5hbWU9
J251bWVyaWMnClsxMy4wNzldUEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNF
JyxmaWVsZF9uYW1lPSdJTlRfMicsdHlwZT0xNzAwLG5hbWU9J251bWVyaWMn
ClsxMy4wOTVdUEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNFJyxmaWVsZF9u
YW1lPSdJTlRfMycsdHlwZT0xNzAwLG5hbWU9J251bWVyaWMnClsxMy4xMTRd
UEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNFJyxmaWVsZF9uYW1lPSdJTlRf
NCcsdHlwZT0xNzAwLG5hbWU9J251bWVyaWMnClsxMy4xMzJdUEdBUElfQ29s
dW1uczogdGFibGU9J1BSSUNFJyxmaWVsZF9uYW1lPSdJTlRfNScsdHlwZT0x
NzAwLG5hbWU9J251bWVyaWMnClsxMy4xNTFdUEdBUElfQ29sdW1uczogdGFi
bGU9J1BSSUNFJyxmaWVsZF9uYW1lPSdTVFJJTkdfMScsdHlwZT0xMDQzLG5h
bWU9J3ZhcmNoYXInClsxMy4xNjldUEdBUElfQ29sdW1uczogdGFibGU9J1BS
SUNFJyxmaWVsZF9uYW1lPSdTVFJJTkdfMicsdHlwZT0xMDQzLG5hbWU9J3Zh
cmNoYXInClsxMy4xODddUEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNFJyxm
aWVsZF9uYW1lPSdSRVNFUlZFRCcsdHlwZT0xNzAwLG5hbWU9J251bWVyaWMn
ClsxMy4yMDVdUEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNFJyxmaWVsZF9u
YW1lPSdJTlRfNicsdHlwZT0xNzAwLG5hbWU9J251bWVyaWMnClsxMy4yMjJd
UEdBUElfQ29sdW1uczogdGFibGU9J1BSSUNFJyxmaWVsZF9uYW1lPSdJTlRf
NycsdHlwZT0xNzAwLG5hbWU9J251bWVyaWMnClsxMy4yNDFdUEdBUElfQ29s
dW1uczogdGFibGU9J1BSSUNFJyxmaWVsZF9uYW1lPSdTVFJJTkdfMycsdHlw
ZT0xMDQzLG5hbWU9J3ZhcmNoYXInCls1Ny40MDVdY29ubj0wMTBFNDMwOCwg
cXVlcnk9J3NlbGVjdCAqIGZyb20gIkV2ZW50cyIuIlBSSUNFIiBsaW1pdCAx
JwpbNTcuNDM4XSAgICBbIGZldGNoZWQgMSByb3dzIF0K

--0-1069563377-1205148077=:53093
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


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

--0-1069563377-1205148077=:53093--

Re: Cannot get psqlODBC to work

am 11.03.2008 10:40:52 von Glyn Astill

Any Ideas Chaps?


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




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


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