[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

using Stored Procedures for Access97

HI,
how do i use a stored procedures of sQL SErver 6.5 from within Access97 environment?
thanks.
0
msali
Asked:
msali
  • 2
1 Solution
 
DennisHCommented:
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
 
msaliAuthor Commented:
How about the parameters?
0
 
DennisHCommented:
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now