Re: Calling a stored procedure from MS Access

2003-09-09 Thread Daniel Kasak
Martin Gainty wrote: Daniel Pass thru query executes on an ODBC Database. Is your MySQL Server setup as an ODBC Database? -Martin Yes of course. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2

Re: Calling a stored procedure from MS Access

2003-09-09 Thread Martin Gainty
Daniel Pass thru query executes on an ODBC Database. Is your MySQL Server setup as an ODBC Database? -Martin - Original Message - From: "Daniel Kasak" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 4:17 PM Subject: Calling a stored pr

Calling a stored procedure from MS Access

2003-09-09 Thread Daniel Kasak
Hi all. I have MySQL-5 running and have made a simple stored procedure which accepts a varaible and selects from a table based on that variable: create procedure msp_BillingBySavingsNo(input_SavingsNo int) select * from Billing where SavingsNo=input_SavingsNo If I enter the mysql client and type