Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Calling Stored Procedures and other SQL statements from MS Access 2003 (Pass Through)
Started 3 months, 3 weeks ago by Marc Ozin
Hi All, I had a bit of a dig round on the forums but couldn't find anything to help me work out how to call stored procedures from MS Access. After a bit of reading I managed to work it out and thought I'd share. * ENVIRONMENT * SERVER MySQL v5.1 Database: TestDB CLIENT Windows XP Access 2003 MySQL ODBC Driver 5.1 (http://dev.mysql.com/downloads/connector/odbc/5.1 .html)...
Site: MySQL AB - MySQL Forums  MySQL AB - MySQL Forums - site profile
Forum: Microsoft Access  Microsoft Access - forum profile
Total authors: 1 author
Total thread posts: 2 posts
Thread activity: no new posts during last week
Domain info for: mysql.com

Other posts in this thread:

Marc Ozin replied 3 months, 3 weeks ago
OK, now I've got that working here's a quick and nasty way to pass parameters using vba to our Pass Through Query In the pass though query above the following sql statement is run: CALL spTest(123,456); I now want to be able to call this query using parameters instead of the fixed values 123 and 456. The only way i can figure out how to do this so far is for access to edit the...
Size: 4,203 bytes
Customize:  Customize "<b>Reply 1</b>: Going further, passing parameters (1st attempt) :: Microsoft Access :: MySQL AB - MySQL Forums"

 

Top contributing authors

Name
Posts
Marc Ozin
2
user's latest post:
Going further, passing...
Published (2009-08-28 11:41:00)
OK, now I've got that working here's a quick and nasty way to pass parameters using vba to our Pass Through Query In the pass though query above the following sql statement is run: CALL spTest(123,456); I now want to be able to call this query using parameters instead of the fixed values 123 and 456. The only way i can figure out how to do this so far is for access to edit the sql for me. I start with editing the SQL in the query,...

Related threads on "MySQL AB - MySQL Forums":

Calling stored procedures from other stored procedures....  MySQL AB - MySQL Forums - site profile Microsoft SQL Server - forum profile Calling stored procedures from other stored procedures. Possible?
Calling stored procedures from other stored procedures. Possible?
Fastest method for calling Stored procedures  MySQL AB - MySQL Forums - site profile .NET - forum profile Fastest method for calling Stored procedures
Fastest method for calling Stored procedures
Calling Stored Procedures from Visual Basic 6  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Calling Stored Procedures from Visual Basic 6
Calling Stored Procedures from Visual Basic 6
Calling stored procedures.  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Calling stored procedures.
Calling stored procedures.
Calling stored procedures in php problem  MySQL AB - MySQL Forums - site profile Newbie - forum profile Calling stored procedures in php problem
Calling stored procedures in php problem
Calling Stored Procedures from Access?  MySQL AB - MySQL Forums - site profile Microsoft Access - forum profile Calling Stored Procedures from Access?
Calling Stored Procedures from Access?
Calling stored procedures in mysql using php  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Calling stored procedures in mysql using php
Calling stored procedures in mysql using php
Calling Stored Procedures inside CREATE VIEW  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Calling Stored Procedures inside CREATE VIEW
Calling Stored Procedures inside CREATE VIEW
Calling Stored Procedures with a CREATE VIEW  MySQL AB - MySQL Forums - site profile Views - forum profile Calling Stored Procedures with a CREATE VIEW
Calling Stored Procedures with a CREATE VIEW
Stored Procedures, PREPARE and sql command stored in table  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Stored Procedures, PREPARE and sql command stored in table
Stored Procedures, PREPARE and sql command stored in table

Related threads on other sites:

MS SQL 2005 :: Error calling Stored Procedures.  http://www.sql-server-performance.com - site profile by: - forum profile MS SQL 2005 :: Error calling Stored Procedures.
MS SQL 2005 :: Error calling Stored Procedures.
PROC SQL, stored procedures (SQL)& input parameters...  SAS Discussion Forums - site profile SAS Procedures - forum profile PROC SQL, stored procedures (SQL)& input parameters to SQL database
PROC SQL, stored procedures (SQL)& input parameters to SQL database
Calling Stored Procedures within Stored Procedures  Tek-Tips Forums - site profile IBM: DB2 - forum profile Calling Stored Procedures within Stored Procedures
Calling Stored Procedures within Stored Procedures
Stored Procedures - SQL Server  Overclockers UK Forums - site profile HTML, Graphics & Programming - forum profile Stored Procedures - SQL Server
Stored Procedures - SQL Server
Calling stored procedures using dynamic SQL  www.oracle.com - site profile General Migration discussion - forum profile Calling stored procedures using dynamic SQL
Calling stored procedures using dynamic SQL
Java.sql.SQLException: ORA-06550 and ORA-00900 Calling...  www.oracle.com - site profile TopLink/JPA - forum profile Java.sql.SQLException: ORA-06550 and ORA-00900 Calling Stored Procedures
Java.sql.SQLException: ORA-06550 and ORA-00900 Calling Stored Procedures
Calling stored procedures in...  Discussions in microsoft.public.dotnet.framework.compactframework - site profile microsoft.public.dotnet.framework.compactframework - forum profile Calling stored procedures in microsoft.public.dotnet.framework.compactframework
Calling stored procedures in microsoft.public.dotnet.framework.compactframework
Calling stored procedures using VB6  DBAsupport.com Forums - site profile Oracle Applications DBA - forum profile Calling stored procedures using VB6
Calling stored procedures using VB6
Calling stored procedures from another stored procedure -...  MSDN Forums - site profile Transact-SQL - forum profile Calling stored procedures from another stored procedure - MSDN Forums
Calling stored procedures from another stored procedure - MSDN Forums
Calling stored procedures from Base  OpenOffice.org Forum at OOoForum.org - site profile OpenOffice.org Base - forum profile Calling stored procedures from Base
Calling stored procedures from Base
Thread profile page for "Calling Stored Procedures and other SQL statements from MS Access 2003 (Pass Through)" on http://www.mysql.com. This report page is a snippet summary view from a single thread "Calling Stored Procedures and other SQL statements from MS Access 2003 (Pass Through)", located on the Message Board at http://www.mysql.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity