Use of PgOleDB and Microsoft ADODB - Mailing list pgsql-novice

From David and Ashley Haycraft
Subject Use of PgOleDB and Microsoft ADODB
Date
Msg-id A2803FF300AE44B38A5B7743DDC6E87C@VOSTROV230ST
Whole thread Raw
List pgsql-novice
Dear pgsql-novice mailing list

I have some novice question relating to the use of PgOleDB and Microsoft
ADODB in a Windows Server context.

By way of background, I am attempting the migration of a legacy
client-server GIS application from Microsoft SQL Server to PostgreSQL.  In
this system the SQL Server database contains a set of stored procedure, each
being an SQL Select queries with one or more parameters.  In response to a
client request, the server program - classic ASP VBScript - uses Microsoft
ADODB to fill in the parameters values, execute the requested query and
return the result set as an XML document to the client.

In the preliminary phase of the migration I have successfully:

1. installed PostgreSQL 9.3 for Windows, PgOleDB 1.0.0.20 and psqlODBC on a
32.bit Windows 7 Pro development PC
2. migrated the SQL Server database table definitions and constraint to a
new PostgreSQL database and populated them using psqlODBC
3. using pgAdmin III, created and executed test queries against the
PostgreSQL database
4. using pgAdmin III, created two test PostgreSQL table-valued Select
functions - test1() one with no parameters and test2(text) with a single IN
parameter  - and verified that both execute correctly
5. written a test ASP/VBscript program that uses ADODB.Connection and
ADODB.Command to connect to the PostgreSQL database, execute test1() - the
no-parameter stored function - and create an ADODB.Recordset correctly

However when I change my test ASP/VBscript program to use test2() and use
objCmd.Parameters.Append()  like this:

    objCmd.CommandText = "test2"
    objCmd.Parameters.Append objCmd.CreateParameter("p1", adVarChar,
adParamInput, 15, "000007-01012013")

 to specify the required IN parameter,  I get the ASP  runtime error:

PgOleDB error '80004005'   " Procedure name for automatic arguments is not
unique "

Q1. What is the appropriate forum for questions about PostgreSQL 9.3 for
Windows and PGOLEDB

Q2. Is there any public documentation available for PgOleDB other than the
README.TXT and RELEASENOTES.TXT files installed along with PgOleDB.dll?

Q3. Is there any other info about the subset of  Microsoft's ADODB
capabilities that is actually implemented in PgOleDB

Q4. What does the diagnostic "Procedure name for automatic arguments is not
unique" mean?

Thanks for your interest

David Haycraft
Email: haycraft@webone.com.au
<blocked::blocked::mailto:haycraft@webone.com.au>
Web: http://www.maps-group.org <http://www.maps-group.org/>





Attachment

pgsql-novice by date:

Previous
From: Venkata Balaji Nagothi
Date:
Subject: Re: Upgrading from 9.1 to 9.3
Next
From: Sameer Kumar
Date:
Subject: Re: Master-slave failover question