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 procedure from MS Access
> 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: > > call msp_BillingBySavingsNo(4211) > > I get the expected result; a few records that match the query. > However if I create a pass-through query in MS Access, point it at > MySQL, and type the same exact same text as above, I get: > > 'SELECT in a stored procedure must have INTO (# 1282)' > > Anyone know what's wrong? > > Thanks! > > -- > 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 9922 7989 > email: [EMAIL PROTECTED] > website: http://www.nusconsulting.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]