Connecting Tech Pros Worldwide Help | Site Map

ADO and PostgreSQL functions

  #1  
Old November 23rd, 2005, 03:04 AM
Zlatko Matiæ
Guest
 
Posts: n/a
Hello.

While I was working with Access Projects (Access front-end with MSDE) I was
able to call stored procedures by using ADO command and parameters object.
Now I am trying to migrate my database from MSDE to Postgre and I'm
wondering about stored procedures on Postgre...I couldn't find such
expression in Pg documentation, so I suppose that there are no such thing on
Postgre. On the other hand, I could see that functions could play such role.
Am I right?
If that is so, how can I call such functions from the client (MS Access, for
example) ? I couldn't call MSDE functions from MS Access using ADO, because
ADO recognize only stored procedures (adCmdStoredProc), so I suppose that
the same problem could be with Postgre functions...
How can I use Postgre functions as recordset for my forms and reports in MS
Access? How can I call and execute parameterized functions?

Thanks.


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
OT What is the comparison of Access to Filemaker Pro. Chuck answers 2 September 12th, 2008 03:35 PM
General advice needed regarding MS Access, MS SQL Server, MySQL/PostgreSQL Ted answers 5 November 28th, 2006 08:35 PM
calling MSDE functions via ODBC ? Zlatko Matiæ answers 5 November 13th, 2005 10:02 AM
author index for Python Cookbook 2? Andrew Dalke answers 10 July 19th, 2005 12:26 AM