Parameters.Refresh error.

From: Adam Biser <adambiser(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Parameters.Refresh error.
Date: 2006-01-03 19:40:45
Message-ID: 43BAD33D.1000302@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I am trying to get a VB6 program to work on a PostgreSQL ANSI DSN. This
program runs fine using an AS/400 DSN and uses prepared, parameterized
SQL statements via an ADODB.Command object for Inserts and Updates. An
example statement is "Insert into CHAPTER (CHAPTERID, CHAPTERDESC)
values (?,?)".

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."

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.

If I use a non-parameterized SQL statement, everything works great, but
this is not the desired approach.

Has anyone experienced something like this? Am I posting in the right
place?

I'm running PostgreSQL 8.1.1 as a service on Windows XP Pro SP2.

Thanks,
Adam

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Peter Eisentraut 2006-01-04 00:27:22 Re: Library names on Unix
Previous Message Tom Lane 2006-01-03 15:20:43 Re: Library names on Unix