Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Call Stored Procedure from DAO

Status
Not open for further replies.
Phailak

Phailak

Programmer
Apr 10, 2001
142
CA
Hail,

How can I call a stored procedure on a SQL 7.0 DB from VB with DAO (have it in code for ADO but I need for DAO)? I don't want to convert everything to ADO even though I know ADO is better for SQL and DAO is more for Access...


Phailak
 
Sort by date Sort by votes

In the DAO help files (or section there of), look up ODBC Direct, and off the top of my head I think you can...
[tt]
SQLStringVariable = "exec Stored_Proc_Name " & Optional_Parameter & ", " & Optional_Parameter 'That is if the SP is expecting such parameters
DAODataBase.Execute SQLStringVariable 'DAOWorkSpace,DAODataBase,DAORecordset
[/tt]

You can use a the recordset if the SP is returning information (recordset)

Good Luck

 
Upvote 0 Downvote
Thanks,

I'll try that today, but sounds right...

Phailak
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
UPDATE DAO RECORDSET 1
Replies
11
Views
775
strongm
strongm
sal21
  • Locked
  • Question
get value from html page 1
Replies
7
Views
424
strongm
strongm
Andrzejek
  • Question
Update SQL's varbinary(max) field from VB6
Replies
4
Views
273
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
NOT FOR ME, get value from table web
Replies
1
Views
237
sal21
sal21
sal21
  • Locked
  • Question
get controll type, controll name from the second panel of SStab 1
Replies
4
Views
810
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top