Output parameter isn"t available ???

Hi,

I have a question with Output parameter . I try to use Output parameter
with psqlodbc-8.01.01.02 which is intalled by intaller of
postgresql-8.1.1 , but it return a error : SqlState = HYC00 ,errorMsg =
"Output parameter isn't available" .

Output parameter isn't available in psqlodbc driver ,or I have made some
mistake ?

Regards, Zhao.


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Output parameter isn"t available ???

> Output parameter isn't available in psqlodbc driver ,or I have made some
> mistake ?

Output parameter isn't supported by psqlODBC yet.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: Output parameter isn"t available ???

I see , thanks.
Output parameter will be supported in the future version ?
is it in the To-do list ?

By the way , where can I get a detailed document about psqlodbc ,
I want to know the difference , example savePoint,autocommit, Output
parameter and so on . thanks.

Regards, zhao


Ludek Finstrle wrote:
>>Output parameter isn't available in psqlodbc driver ,or I have made some
>> mistake ?
>
>
> Output parameter isn't supported by psqlODBC yet.
>
> Regards,
>
> Luf
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

VBA, WIN ODBC system error: setup routine error 182, translator

Playing (?) further with M$ ODBC issues I wanted to add a new odbc data
source to my system, but...
Mr. Microsoft ODBC Administrator reported me:

"The setup routines for the PostgreSQL ANSI ODBC driver could not be
loaded due to system error code 182"

Driver's config DSN, ConfigDriver, or ConfigTranslator failed
"Could not load the setup or translator library"


Now what to do ????????

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: VBA, WIN ODBC system error: setup routine error 182, translator

=20

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org=20
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of linuxgps
> Sent: 10 January 2006 04:57
> Cc: Ludek Finstrle; pgsql-odbc@postgresql.org
> Subject: [ODBC] VBA, WIN ODBC system error: setup routine=20
> error 182, translator
>=20
>=20
> Playing (?) further with M$ ODBC issues I wanted to add a new=20
> odbc data=20
> source to my system, but...
> Mr. Microsoft ODBC Administrator reported me:
>=20
> "The setup routines for the PostgreSQL ANSI ODBC driver could not be=20
> loaded due to system error code 182"
>=20
> Driver's config DSN, ConfigDriver, or ConfigTranslator failed
> "Could not load the setup or translator library"
>=20
>=20
> Now what to do ????????

Given your other problems with the existing DSN, it sounds like
something is seriously hosed on that system. Where is psqlODBC
installed? Are all the dependency DLLs there as well? Should be
something like:

psqlodbca.dll
psqlodbcw.dll
libpq.dll
libintl_2.dll
libiconv_2.dll
libeay32.dll
ssleay32.dll
comerr32.dll
krb5_32.dll

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: Output parameter isn"t available ???

> I see , thanks.
> Output parameter will be supported in the future version ?
> is it in the To-do list ?

There are a lot of features on todo list. There is few developers with
few time. Feel free to join us and help.

> By the way , where can I get a detailed document about psqlodbc ,
> I want to know the difference , example savePoint,autocommit, Output
> parameter and so on . thanks.

I'm afraid you can only ask here. I don't know about detailed
documentation. We don't have enough time to develop so documentation
is the last problem for us :-(

What do you want know about these examples?
savePoint: You can use it in autocommit off mode. I see no support for
it in ODBC API so I don't know if there could be better
support for it in psqlODBC
autocommit: on - you don't care on commit/rollback, the driver makes
it automatically after each statement you could
use here manual transaction - this has same behaviour
as autocommit off ( I hope :-) )
off - you have to call BEGIN, COMMIT/ROLLBACK, ....
you can use here the savePoints
output param: isn't supported yet

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org