Re: Parameters.Refresh error. - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: Parameters.Refresh error.
Date
Msg-id 20060106084609.GA7100@soptik.pzkagis.cz
Whole thread Raw
In response to Parameters.Refresh error.  (Adam Biser <adambiser@gmail.com>)
Responses Re: Parameters.Refresh error.  (Adam Biser <adambiser@gmail.com>)
List pgsql-odbc
> My ConnectionString for my PostgreSQL DSN is simply "DSN=DSN Name" and I
> connect successfuly.  However, when I use .Parameters.Refresh I get the
> following error:
>
>  "Provider cannot derive parameter information and SetParameterInfo has
> not been called."

I have no idea what SQLXXX ODBC calls are represented under this.

> When I try "Provider=PostgreSQL.1;Data Source=localhost;Location=DB
> Name;", I can also connect, but .Parameters.Count simply returns 0
> instead of the appropriate amount.
>
> Has anyone experienced something like this?  Am I posting in the right
> place?

This is the right place.

Please could you send here full mylog output (turn on in Global and
DataSource dialogs). It helps us to find the problematic place.

Regards,

Luf

pgsql-odbc by date:

Previous
From: Ludek Finstrle
Date:
Subject: Re: VBA 6 crashes with WIN2K, Postgres 8.1, why ? which dll ??
Next
From: "Dave Page"
Date:
Subject: Re: VBA 6 crashes with WIN2K, Postgres 8.1, why ? which dll ??