Solved

using Stored Procedures for Access97

Posted on 1998-08-27
3
202 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
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
DennisH earned 20 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now