conncetion string.
So, I should disable that option, but don't know which option is that ?
Where can I find description of these constants in connection string (A, B,
C)?
-
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Re-GENERAL-MS-Access-and-Stored-proce
ot;
Case Else
MsgBox "An error occured in the function 'TransferQueryToTable': "
& Err.Number & " " & Err.Description
End Select
End Function
++++++++++++++
Just thought I'd share in case it
all round coverage of Access development issues, including
client-server.
>
> Do you have form/subform/subform...based on stored procedures ? If so, how
> do you synchronize form with subform ?
>
>
> Greetings,
>
> Zlatko
>
>
> ----- Original Message -
&
;
Case Else
MsgBox "An error occured in the function 'TransferQueryToTable': " &
Err.Number & " " & Err.Description
End Select
End Function
++++++++++++++++++++++++++
Just thought I'd share in case it helps an
bject: [GENERAL] MS-Access and Stored
procedures
Hello !
How can I use stored procedures (functions) with
MS-Access 2002 connected to PostgreSQL 8.0 ?
Best regards.
Luc
;, so using DAO is
not a problem, even if ADO is supposed to be the future... If you put logic on
the client, that's another problem maybe.
Philippe Lang
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Zlatko Matic
Envoyé : vendredi, 13. mai
--- Original Message -
From: "Hervé Inisan" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 12, 2005 11:06 PM
Subject: Re: [GENERAL] MS-Access and Stored procedures
Hello...This is very interesting. I have also asked myself
how to prepare and execute stored procedures on POstgre fro
> Hello...This is very interesting. I have also asked myself
> how to prepare and execute stored procedures on POstgre from
> MS Access.
> Could you, please, give some example of Postgre function with
> parameters that is executed as stored procedure from MS
> Access? How would you pass paramet
ADO Command object?
Greetings,
Zlatko
- Original Message -
From: "Hervé Inisan" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 12, 2005 6:15 PM
Subject: Re: [GENERAL] MS-Access and Stored procedures
How can I use stored procedures (functions) with MS-Access
2002 connect
> How can I use stored procedures (functions) with MS-Access
> 2002 connected to PostgreSQL 8.0 ?
An alternative to Philippe's solution is to use ADO.
Here is an sample function :
(assuming ActiveX Data Object lib is checked in the Tools/References menu)
Function ADO_PG()
Dim cnn As ADODB.Connec
_disponible_semaineError:
MsgBox "Error in charge_disponible_semaine."
Resume charge_disponible_semaineExit
End Function
I hope this helps. One or two utility function are needed:
Public Function global_dsn_name() As String
global_dsn_name = "you_dsn_
Hello !
How can I use stored procedures (functions) with
MS-Access 2002 connected to PostgreSQL 8.0 ?
Best regards.
Luc
12 matches
Mail list logo
