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

Pb sous Analyses Manager avec liaison sur Postgres

From: Eric HAGENBACH <eric(dot)hagenbach(at)vif(dot)tm(dot)fr>
To: pgsql-fr-generale(at)postgresql(dot)org
Subject: Pb sous Analyses Manager avec liaison sur Postgres
Date: 2004-06-25 09:08:26
Message-ID: 40DBEB8A.E36B79FC@vif.tm.fr (view raw or flat)
Thread:
Lists: pgsql-fr-generale
Bonjour,

Je souhaite accéder à partir d'analysis services (outils Microsoft Olap)
à une base de données Postgres (vers 7.4).
Os = Windows XP , la base Postgres est sur un serveur Linux Je n'ai
aucun problème pour créer une source de données via le
fournisseur OLE DB Provider for ODBC Drivers avec le driver ODBC pour
Postgres (PostgreSQL30 version 7.03.02.00). De
mêmej'arrive en création de dimension à accéder à toutes les tables et
même à parcourir les données. Par contre dès que j'essai de traiter une
dimension, j'ai le message suivant:
"Erreur du fournisseur de la source de données :
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable
et nom de pilote non spécifié;IM002; Heure :06/05/2004 17:55:09"
Alors que j'arrive quand même à visuliser les membres de la dimension
dans la
fenêtre "données". Cette même erreur se répète quand j'essaie de traiter
un cube.

Dans le fichier log de Postgres j'ai l'erreur suivante:
Global Options: Version='07.03.0200', fetch=100, socket=4096,
unknown_sizes=2, max_varchar_size=254, max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 NAMEDATALEN=64
                extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
conn=151862072, query=' '
conn=151862072, query='select version()'
    [ fetched 1 rows ]
    [ PostgreSQL version string = 'PostgreSQL 7.4.1 on
i686-pc-linux-gnu, compiled by GCC 2.96' ]
    [ PostgreSQL version number = '7.4' ]
conn=151862072, query='set DateStyle to 'ISO''
conn=151862072, query='set geqo to 'OFF''
conn=151862072, query='set extra_float_digits to 2'
conn=151862072, query='select oid from pg_type where typname='lo''
    [ fetched 0 rows ]
conn=151862072, query='select pg_client_encoding()'
    [ fetched 1 rows ]
    [ Client encoding = 'SQL_ASCII' (code = 0) ]
conn=151862072,
PGAPI_DriverConnect(out)='DSN=PostgreSQL30;DATABASE=decision;SERVER=decision;PORT=5432;UID=decision;PWD=xxxxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=1;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=2;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0'

STATEMENT ERROR: func=PGAPI_SetDescField, desc='', errnum=11,
errmsg='can't SQLSetDescField for this parameter number'

------------------------------------------------------------
                 hdbc=151862072, stmt=151855392, result=0
                 manual_result=0, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=-2, statement='(NULL)'
                 stmt_with_params='(NULL)'
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,

scroll_concurrency=1
                 cursor_name=''
                 ----------------QResult Info
-------------------------------
CONN ERROR: func=PGAPI_SetDescField, desc='', errnum=0, errmsg='(NULL)'
            ------------------------------------------------------------

            henv=151862016, conn=151862072, status=1, num_stmts=16
            sock=151854872, stmts=151854944, lobj_type=-999
            ---------------- Socket Info -------------------------------

            socket=1112, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=151873072, buffer_out=151877176
            buffer_filled_in=63, buffer_filled_out=0, buffer_read_in=63
conn=151862072, query='select gibcol from gibtab where 1=0'
    [ fetched 0 rows ]
conn=151892328, PGAPI_DriverConnect(
in)='DSN=PostgreSQL30;UID=decision;PWD=xxxxxxxx;', fDriverCompletion=0
DSN info:
DSN='PostgreSQL30',server='decision',port='5432',dbase='decision',user='decision',passwd='xxxxx'



onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='1'

          conn_settings='',conn_encoding='OTHER'
          translation_dll='',translation_option=''
Global Options: Version='07.03.0200', fetch=100, socket=4096,
unknown_sizes=2, max_varchar_size=254, max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 NAMEDATALEN=64
                extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
conn=151892328, query=' '
conn=151892328, query='select version()'
    [ fetched 1 rows ]
    [ PostgreSQL version string = 'PostgreSQL 7.4.1 on
i686-pc-linux-gnu, compiled by GCC 2.96' ]
    [ PostgreSQL version number = '7.4' ]
conn=151892328, query='set DateStyle to 'ISO''
conn=151892328, query='set geqo to 'OFF''
conn=151892328, query='set extra_float_digits to 2'
conn=151892328, query='select oid from pg_type where typname='lo''
    [ fetched 0 rows ]
conn=151892328, query='select pg_client_encoding()'
    [ fetched 1 rows ]
    [ Client encoding = 'SQL_ASCII' (code = 0) ]
conn=151892328,

PGAPI_DriverConnect(out)='DSN=PostgreSQL30;DATABASE=decision;SERVER=decision;PORT=5432;UID=decision;PWD=xxxxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=1;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=2;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0'

STATEMENT ERROR: func=PGAPI_SetDescField, desc='', errnum=11,
errmsg='can't SQLSetDescField for this parameter number'

------------------------------------------------------------
                 hdbc=151892328, stmt=151855392, result=0
                 manual_result=0, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=-2, statement='(NULL)'
                 stmt_with_params='(NULL)'
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,

scroll_concurrency=1
                 cursor_name=''
                 ----------------QResult Info
-------------------------------
CONN ERROR: func=PGAPI_SetDescField, desc='', errnum=0, errmsg='(NULL)'
            ------------------------------------------------------------

            henv=151862016, conn=151892328, status=1, num_stmts=16
            sock=151855968, stmts=151883336, lobj_type=-999
            ---------------- Socket Info -------------------------------

            socket=1132, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=151886192, buffer_out=151903328
            buffer_filled_in=63, buffer_filled_out=0, buffer_read_in=63
conn=151892328, query='select gibcol from gibtab where 1=0'
    [ fetched 0 rows ]
conn=151892328, query='select relname, nspname, relkind from
pg_catalog.pg_class, pg_catalog.pg_namespace where relkind in ('r', 'v')

and pg_namespace.oid = relnamespace order by nspname, relname'
    [ fetched 180 rows ]
conn=151892328, query='select relname, nspname, relkind from
pg_catalog.pg_class, pg_catalog.pg_namespace where relkind in ('r', 'v')

and pg_namespace.oid = relnamespace order by nspname, relname'
    [ fetched 180 rows ]
conn=151892328, query='select relname, nspname, relkind from
pg_catalog.pg_class, pg_catalog.pg_namespace where relkind in ('r', 'v')

and pg_namespace.oid = relnamespace order by nspname, relname'
    [ fetched 180 rows ]
conn=151892328, query='select u.nspname, c.relname, a.attname,
a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull,
c.relhasrules, c.relkind from pg_catalog.pg_namespace u,
pg_catalog.pg_class c, pg_catalog.pg_attribute a, pg_catalog.pg_type t
where u.oid = c.relnamespace and (not a.attisdropped) and c.oid=
a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like
'calend' and u.nspname like 'decision' order by u.nspname, c.relname,
attnum'
    [ fetched 14 rows ]
PGAPI_Columns: table='calend',field_name='csoc',type=1043,name='varchar'

PGAPI_Columns:
table='calend',field_name='typecalendrier',type=1043,name='varchar'
PGAPI_Columns:
table='calend',field_name='annee',type=1043,name='varchar'
PGAPI_Columns: table='calend',field_name='libannee',type=25,name='text'
PGAPI_Columns:
table='calend',field_name='semestre',type=1043,name='varchar'
PGAPI_Columns:
table='calend',field_name='libsemestre',type=25,name='text'
PGAPI_Columns:
table='calend',field_name='trimestre',type=1043,name='varchar'
PGAPI_Columns:
table='calend',field_name='libtrimestre',type=25,name='text'
PGAPI_Columns: table='calend',field_name='mois',type=1043,name='varchar'

PGAPI_Columns: table='calend',field_name='libmois',type=25,name='text'
PGAPI_Columns:
table='calend',field_name='semaine',type=1043,name='varchar'
PGAPI_Columns:
table='calend',field_name='libsemaine',type=25,name='text'
PGAPI_Columns:
table='calend',field_name='datedebut',type=1114,name='timestamp'
PGAPI_Columns:
table='calend',field_name='datefin',type=1114,name='timestamp'
conn=151892328, query='select relname, nspname, relkind from
pg_catalog.pg_class, pg_catalog.pg_namespace where relkind in ('r', 'v')

and pg_namespace.oid = relnamespace order by nspname, relname'
    [ fetched 180 rows ]
conn=151892328, PGAPI_Disconnect
conn=151862072, PGAPI_Disconnect

Merci de votre aide.

eric(dot)hagenbach(at)vif(dot)tm(dot)fr



Attachment: eric.hagenbach.vcf
Description: text/x-vcard (308 bytes)

pgsql-fr-generale by date

Next:From: isidore assiDate: 2004-06-28 10:31:07
Subject: demande d'aide
Previous:From: Eric HAGENBACHDate: 2004-06-25 08:41:44
Subject: Pb sous Analyses Manager avec liaison sur Postgres

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