| noreply@pgfoundry.org 2006-02-10, 9:23 am |
| Bugs item #1000518, was opened at 2006-01-04 23:36
You can respond by visiting:
http://pgfoundry.org/tracker/?func=...roup_id=1000125
Category: None
Group: None
>Status: Deleted
Resolution: None
Priority: 3
Submitted By: saikit lam (taz_devilzz)
Assigned to: Nobody (None)
Summary: "Requested conversion is not supported" when trying to query information_schema.tables on SQL
Initial Comment:
I got this error:
Could not get the current row value of column '[MSDASQL].table_catalog' from the OLE DB provider 'MSDASQL'.
[OLE/DB provider returned message: Requested conversion is not supported.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetData returned 0x80040e1d].
when I am trying to execute the following queries on SQL Query Analyzer:
a) SELECT * FROM OPENQUERY(my_linked_
server,'SELECT * FROM information_schema.tables')
b) SELECT * FROM OPENQUERY(ufa_selfse
rve_PGSQL80,'SELECT * FROM pg_catalog.pg_constraint')
my_linked_server is defined as a SQL linked server using Microsoft OLE DB Provider (MSADSQL).
However, the following error result no error:
SELECT * FROM OPENQUERY(ufa_selfse
rve_PGSQL80,'SELECT * FROM pg_catalog.pg_depend')
I have tried both psqlodbc-08_01_0102 and psqlodbc-8_01_0106 but they behave the same.
Any help is appreciated.
Thanks.
----------------------------------------------------------------------
>Comment By: Ludek Finstrle (luf)
Date: 2006-02-10 15:17
Message:
User doesn't cooperate.
----------------------------------------------------------------------
Comment By: Ludek Finstrle (luf)
Date: 2006-01-05 20:31
Message:
Please attach mylog output as it's is more useful for bug hunting (it's much larger so feel free to compress it).
----------------------------------------------------------------------
Comment By: saikit lam (taz_devilzz)
Date: 2006-01-05 00:00
Message:
Here is what I got from the psqlodbc_xxx.log file about the
error:
Global Options: Version='08.01.0102', fetch=100, socket=0,
unknown_sizes=254, max_varchar_size=819
0, max_longvarchar_size
=0
disable_optimizer=1,
ksqo=1, unique_index=1,
use_declarefetch=0
text_as_longvarchar=
1,
unknowns_as_longvarc
har=0, bools_as_char=1 NAMEDATALEN=64
extra_systable_prefi
xes='dd_;',
conn_settings='' conn_encoding='OTHER
'
conn=81423936, query='select version()'
[ PostgreSQL version string = 'PostgreSQL 7.4.7 on
i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502
(Red Hat Linux 3.2.3-47)' ]
[ PostgreSQL version number = '7.4' ]
conn=81423936, query='set DateStyle to 'ISO''
conn=81423936, query='set geqo to 'OFF''
conn=81423936, query='set extra_float_digits to 2'
conn=81423936, query='select oid from pg_type where
typname='lo''
conn=81423936, query='select pg_client_encoding()
'
conn=81423936, query='set client_encoding to 'latin9''
conn=81423936,
PGAPI_DriverConnect(
out)='DSN=my_dsn;DAT
ABASE=my_db;SERVER=m
y_server;PORT=5432;S
SLMODE=prefer;UID=me
;PWD=pwd;ReadOnly=0;
Protocol=6. 4;FakeOidIndex=0;Sho
wOidColumn=0;RowVers
ioning=0;ShowSystemT
ables=0;ConnSettings
=;Fetch=100;Socket=8
192;UnknownSizes=0;M
axVa
rcharSize=254;MaxLon
gVarcharSize=8190;De
bug=0;CommLog=1;Opti
mizer=1;Ksqo=1;UseDe
clareFetch=0;TextAsL
ongVarchar=1;Unknown
sAsLongVarchar=0;Boo
lsAsChar=1;Parse=0;C
ancelAsFreeStmt=0;Ex
traSysTablePrefixes=
dd_;;LFConversion=1;
UpdatableCursors=0;D
isallowPrematur
e=0;TrueIsMinus1=0;B
I=0;ByteaAsLongVarBi
nary=0;UseServerSide
Prepare=0;LowerCaseI
dentifier=0'
DESCRIPTOR ERROR: func=PGAPI_SetDescFi
eld, desc='',
errnum=11, errmsg='bad parameter number'
conn=81423936, query='SELECT * FROM information_schema.tables'
conn=81423936, PGAPI_Disconnect
Global Options: Version='08.01.0102', fetch=100, socket=0,
unknown_sizes=254, max_varchar_size=819
0, max_longvarchar_size
=0
disable_optimizer=1,
ksqo=1, unique_index=1,
use_declarefetch=0
text_as_longvarchar=
1,
unknowns_as_longvarc
har=0, bools_as_char=1 NAMEDATALEN=64
extra_systable_prefi
xes='dd_;',
conn_settings='' conn_encoding='OTHER
'
conn=81423936, query='select version()'
[ PostgreSQL version string = 'PostgreSQL 7.4.7 on
i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502
(Red Hat Linux 3.2.3-47)' ]
[ PostgreSQL version number = '7.4' ]
conn=81423936, query='set DateStyle to 'ISO''
conn=81423936, query='set geqo to 'OFF''
conn=81423936, query='set extra_float_digits to 2'
conn=81423936, query='select oid from pg_type where
typname='lo''
conn=81423936, query='select pg_client_encoding()
'
conn=81423936, query='set client_encoding to 'latin9''
conn=81423936,
PGAPI_DriverConnect(
out)='DSN=my_dsn;DAT
ABASE=my_db;SERVER=m
y_server;PORT=5432;S
SLMODE=prefer;UID=me
;PWD=pwd;ReadOnly=0;
Protocol=6. 4;FakeOidIndex=0;Sho
wOidColumn=0;RowVers
ioning=0;ShowSystemT
ables=0;ConnSettings
=;Fetch=100;Socket=8
192;UnknownSizes=0;M
axVa
rcharSize=254;MaxLon
gVarcharSize=8190;De
bug=0;CommLog=1;Opti
mizer=1;Ksqo=1;UseDe
clareFetch=0;TextAsL
ongVarchar=1;Unknown
sAsLongVarchar=0;Boo
lsAsChar=1;Parse=0;C
ancelAsFreeStmt=0;Ex
traSysTablePrefixes=
dd_;;LFConversion=1;
UpdatableCursors=0;D
isallowPrematur
e=0;TrueIsMinus1=0;B
I=0;ByteaAsLongVarBi
nary=0;UseServerSide
Prepare=0;LowerCaseI
dentifier=0'
DESCRIPTOR ERROR: func=PGAPI_SetDescFi
eld, desc='',
errnum=11, errmsg='bad parameter number'
conn=81423936, query='SELECT * FROM pg_catalog.pg_constraint'
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=...roup_id=1000125
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|