Обсуждение: ODBCng and OpenOffice 2.1

Поиск
Список
Период
Сортировка

ODBCng and OpenOffice 2.1

От
Hannes Dorbath
Дата:
I tried to connect OpenOffice 2.1 Base (win32) via ODBCng to a PG 8.1.5
database.

While it lists schemas, tables and views just fine, I'm unable to edit
data. OO always returns:

The data content could not be loaded
Invalid descritor index
SQL Status: 07009
You tried to set a parameter at position 1 but there is/are only 0
parameter(s) allowed. One reason may be that the property
"ParameterNameSubstitution" is not set to TRUE in the data source.

Where is the problem?

--
Regards,
Hannes Dorbath

Re: ODBCng and OpenOffice 2.1

От
Richard Huxton
Дата:
Hannes Dorbath wrote:
> I tried to connect OpenOffice 2.1 Base (win32) via ODBCng to a PG 8.1.5
> database.

> The data content could not be loaded
> Invalid descritor index
> SQL Status: 07009
> You tried to set a parameter at position 1 but there is/are only 0
> parameter(s) allowed. One reason may be that the property
> "ParameterNameSubstitution" is not set to TRUE in the data source.

You'll probably need to activate query logging on the server, that way
people can see the SQL that is being sent.

--
   Richard Huxton
   Archonet Ltd

Re: ODBCng and OpenOffice 2.1

От
"Joshua D. Drake"
Дата:
Hannes Dorbath wrote:
> I tried to connect OpenOffice 2.1 Base (win32) via ODBCng to a PG 8.1.5
> database.
>
> While it lists schemas, tables and views just fine, I'm unable to edit
> data. OO always returns:
>
> The data content could not be loaded
> Invalid descritor index
> SQL Status: 07009
> You tried to set a parameter at position 1 but there is/are only 0
> parameter(s) allowed. One reason may be that the property
> "ParameterNameSubstitution" is not set to TRUE in the data source.
>
> Where is the problem?
>

This should be addressed on the odbcng list:

http://lists.commandprompt.com/mailman/listinfo/odbcng

I actually don't have an answer to your question except to say, I can
not duplicate it on OpenOffice for Linux.

Sincerely,

Joshua D. Drake


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/