?
Solved

using Stored Procedures for Access97

Posted on 1998-08-27
3
Medium Priority
?
220 Views
Last Modified: 2010-03-19
HI,
how do i use a stored procedures of sQL SErver 6.5 from within Access97 environment?
thanks.
0
Comment
Question by:msali
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
DennisH earned 80 total points
ID: 1089791
Create a new query.  Select Query/SQL Specific/Pass Through from the menu. In the SQL window type the following SQL statement.

EXEC sp_myprocedure

Where sp_myprocedure is the name of your stored procedure.

Open the properties window for the query and set the properties.  Pay close attention to setting the Connect string and the "ReturnsRecords" properties correctly.  Save your query and test it.
0
 

Author Comment

by:msali
ID: 1089792
How about the parameters?
0
 
LVL 1

Expert Comment

by:DennisH
ID: 1089793
You did not ask about parameters.  You use the same format except you add the arguments in the correct order.

Example:
EXEC sp_esr_CalculateStatistics 'E', 1, 1997

You must pass the arguments as the proper data type.
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question